Hi everyone.
I'm creating a database that is located out on the company's network and will be accessed by several employees. They have asked for security so only certain users can see certain information. I converted the database to an MDB and have set up User Level Security.
Now here's the problem. On my computer, when I open the database I am being prompted to login as I intended. However, when I open the database from other computers on the network, the security is being bypassed and users are not required to login, and they are receiving full permissions. I assumed that they are being automatically logged in as Admin, so I removed Admin from the "Admins" group and it is only left in the "Users" group which I have removed all permissions from. However, other computers are still logging in to the database and are able to access/change all the data.
How can I ensure that EVERY person/computer that accesses the database from the network will be forced a login prompt?