ODBC connection

[Guest]

Hello,

I have linked several tables to a database called sondb on the SQL server
called orlapp. I have used a DSN called MYAPP with userid and password of
"monthly"

Once I open the database and run my query I have to sgn on using the user id
and password.

I would like to use code to connect to the server without having to sign on
manually.

Can someone please let me know what the code should be.

 

[Dave Patrick]

Delete and recreate the links but this time check the box for 'Save
password'

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Hello,
|
| I have linked several tables to a database called sondb on the SQL server
| called orlapp. I have used a DSN called MYAPP with userid and password of
| "monthly"
|
| Once I open the database and run my query I have to sgn on using the user
id
| and password.
|
| I would like to use code to connect to the server without having to sign
on
| manually.
|
| Can someone please let me know what the code should be.
|
|
| --
| deodev

 

[Guest]

Thanks. Would this work if someone else access the database from their PC?
If not, can it be coded to create the DSN and the appropriate sign on?

 

[Dave Patrick]

Yes because the connection string (including the username and password) is
stored in the 'Connect' column of the hidden access table 'MSysObjects'

The DSN you created to make the links is no longer needed.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Thanks. Would this work if someone else access the database from their
PC?
| If not, can it be coded to create the DSN and the appropriate sign on?