Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA to automatically launch an ODBC login on start-up?

Status
Not open for further replies.

cratho

MIS
Mar 1, 2002
9
0
0
US
Anyone know of or have some code to automatically launch an ODBC login upon startup of an Access database? I have a couple of Oracle tables linked and the login process prompts only when these tables are accessed. I need to add this to the startup of the database. Thanks!
 
I don't know of one off the top of my head, but if you don't get than answer you're looking for you could always create a "dummy" form that is bound to one of the tables and open and close that upon startup. That would make Access attemp to access one of the tables which should prompt for the login...

Kyle
 
Or maybe change your dsn setup (if using one) ...to use "user logon" instead of prompt.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top