Re: Question about saving user name and password

Thank you for your quick reply.

I don't see any place to specify "save username and password".

When I run the form in Access file, the pop-up window shows:
- Database
- SSL Mode (which has only "disable" option)
- Server
- Port
- User Name
- Password
- Connection (button; when I click on it, another window shows up but
I don't see any options related to password)
- Manage DSN (button; when I click on it, nothing pops up)

Any idea what I should check next?

Many thanks!!

On 11/2/2009 4:03 PM, Raymond O'Donnell wrote:
> On 02/11/2009 20:59, Nim Li wrote:
>
>> I'm building an Access UI to work with a postgresql database. I'm using
>> psqlodbc for the database connection.
>>
>> Every time I start the Access file to run the form, a pop-up window
>> shows up to ask for username and password.
>>
>> Can we avoid the pop-up window by saving the username and password
>> somewhere?
>
> Hi there,
>
> I haven't used ODBC in a while, but I seem to remember that there were
> fields to enter the username & password in the DSN configuration
> dialogs.... have you tried that?
>
> HTH,
>
> Ray.
>