ODBC Connect Strings

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

When I link table in Access, it asks me to save the
password. That's great; when I re-enter the app, the
tables are linked and do not require that I re-enter the
password.

When I build pass-thru queries, it asks me to save the
password. I can even read it in the connection string.

Here's the question:

How can I link to ODBC tables in a macro or module so
the passwords persist?

I want the tables not to require that I re-enter the
password when I return to the application after exiting
Access.

I would appreciate any help.
Phil
 
When you exit Access you'll be breaking the connection. There is no way on
earth that any decent database engine would save the security token to let
you back in. The only thing I'd suggest is if your machine's are relatively
secure, that you hard-code the connection string.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top