No logon prompt on database open

[jasons]

Came across a very strange problem. Finished up a six month long database design and finalized the security. Everything checks out and looks good until I try to open the database over the network. Every computer on the network that I use to open the database doesn't ask for the logon and password. It just opens the database with admin permissions. If I open the database on the system where the database resides it prompts for username and password. As a test I copied the database to another machine and tried opening the file locally and again the same thing happened. No logon prompt just logs in as admin. Another strange thing that might be a clue is when I look at the security of the database on any of the systems that don't prompt for login, all the accounts/groups I created don't exist. I see them when I open the database on the system where the database resides.

Any ideas?

Thanks,

Jason

 

[MStef]

You have to copy a SYSTEM.MDW file from your PC,
or to create a New Workgroup on every PC (the same as
it is on the your PC). On My Pc (XP, Access 2000, 2002, 2003)
the System.mdw is on C:\Documents and settings\myName\
ApplicationData\Microsoft\Access directory.

 

[gemma-the-husky]

note that you should not amend the file system.mdw

you ought to create a new mdw file, and remove admin permissions.

Take backups, bcause you can easily lock yourself out of your database completely.