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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Workgroup Security - Access defaults login for ODBC logins

Status
Not open for further replies.

mordja

Programmer
Apr 27, 2004
294
GB

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top