User accounts and passwords

[ndltx5]

I'm trying to set up user account and passwords for a specific database file, but the user accounts and passwords are being applied to all my access files. How do I make my accounts and passwords local to on database?

Thank you

 

[StrikeEagleII]

It sounds like you used the User Level Security Wizard--on the first screen it asks you if you want to create a new workgroup information file (yes). On the second screen it asks if you want to make this the default workgroup information file or if you want to make a shortcut to open your security enhanced database (you want to create a shortcut). Did you by chance select "I want to make this my default workgroup information file"? Access comes with a standard workgroup information file that it uses to logon any time access is started (although the logon is not seen if the logon name is admin with no password as is default) and it sounds like you replaced it by accident.

The fix is not really hard, but sort of in depth, so let me know if I'm on the right track and I'll write more...

 

[ndltx5]

Ok thank you i understand what my problem is now, but when i use the wizard everything goes through fine. Except when i try to open the database from the shortcut that was created on my desktop it says that the file can't be found and that this file is required for start up. When I try to open it using the new file that was created in the folder with the back up it says i don't have the necessary permission to use the object file and to have my system administrator or the person who created this object establish the appropriate permissions for me(but thats me).

 

[ndltx5]

nevermind i think this is a server issue and not an access issue so think you for you help