[AccessD] Refreshing ODBC linked tables

Must be having a duh moment.  Thank you so much Gustav.

Doug 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, January 30, 2009 2:14 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Refreshing ODBC linked tables

Hi Doug

Delete the linked tables and relink them. This time, make sure you mark the
checkbox to save user name and password in the connection info.

/gustav

>>> dw-murphy at cox.net 30-01-2009 22:57 >>>
 
Folks,

I have a database linked to an ODBC backend. When the database is opened and
my code refreshes the links the ODBC Driver logon screen comes up.  Is there
a way to hard code the user id and password into the front end so it can
just open with the tables connected? I have the user id and password in the
connection string refresh code, but that doesn't seem to do the trick.

Thanks in advance.

Doug


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com