[AccessD] Connecting to SQL from Access w/a single login?

Gustav Brock gustav at cactus.dk
Sun Sep 19 10:01:36 CDT 2004


Hi Christopher

How are you looking for the password?

It will not be present in the Msys-tables but should be present in the
Connect property of the tabledef.

/gustav


> Mind you, the password is in the metadata table.  But it seems to get
> ignored.  Here is a sample of the string I'm using to create the link:

> [code]
> ODBC;DSN=MyDataSource;Description=My SQL Server
> Date;UID=MyUser;PASSWORD=MyPassword;APP=Microsoft Office
> 2003;WSID=MyWorkstation;DATABASE=MyDatabaseName[/code]

> Here's my function.  How can I ensure that the password that's baked
> into the path gets remembered?  I'm thinking that there must be a way
> to emulate checking the 'Remember Password' checkbox in the Linked
> Table dialog.




More information about the AccessD mailing list