Prompt ODBC Connection??

[mohsinhq]

hi all,

is it possible for me to prompt a user to connect to a database as soon as they open my Access Application?

my access app uses linked tables and the user is prompted for a password and username one they enter a form that requires linked data. it only asks the user to enter the password and user id once but i would like to change the point at which they are asked. i.e. connect as soon as they have opened the DB.

ive had a look around the forums and found a few topics for creating connection strings but not sure how to go about making a prompt?

thanks in advance

 

[namliam]

Simply open a table on opening the database or do a "select sysdate from dual" ODBC query.

Anyway something to "trigger" the connection to the database

Regards