Hi,
I have an access database which is workgroup protected. The default user does not need a password. When the default user attempts to open an ODBC table access prompts them for their login and password as expected. For the users which enter a password when logging in (amdin, desginer, myself) access automatically uses their login id and password for all odbc or ado connections, as they are not the same not odbc tables can be accessed when using a password protected login. How can I stop this ??
THanks
Mordja