PDA

View Full Version : Database passwords



icthus123
06-13-2007, 01:04 AM
Hi,

I'm trying to set up a database with user level passwords. However, when I set up accounts through Tools > Security > User and Group Accounts the Users and passwords I set up end up applying to all the databases on my computer.

And if I try to access the database I want to protect on another computer over the network there is no password on it at all. Can anybody help?

mattj
06-13-2007, 05:20 AM
More than likely, ULS has been applied incorrectly, and it sounds as if the default system.mdw workgroup file has been modified.
See these links:
http://support.microsoft.com/?id=207793
http://support.microsoft.com/default.aspx?scid=kb;en-us;305542
http://www.databasedev.co.uk/access_security.html

HTH
Matt