ODBC linked table is not asking for password - Why

[Guest]

I setup a new database and imported some ODBC linked tables. Whenever my
users attempt to connect to the tables, once imported, it no longer asks for
the password.

In another Databse that I setup the same way, it continues to ask for the
password each time you try to connect to the imported tables.


Any idea as to how I can ensure that a password is requested each time the
users try to connect to the imported tables!

Thanks

 

[david epsom dot com dot au]

You may have imported the tables instead of linking them.
Make sure you have linked tables, not local copies.

Or you may have saved the password with the link. Link again,
and this time make sure that you don't select the option
to save the user name and password.

Or you may be using a trusted connection. Make sure that
your database does not accept trusted connections.

Or you may have no password for the 'admin' user. If you
have an 'admin' user, make sure there is a password.

(david)