MS Access Security Question

[Greenstein]

I have created an Access database that resides on a shared server. On my own computer, I opened the database from the shared server and began to create users, groups, permissions, passwords, etc. I then went through and logged on as each user (still on my own computer) to ensure that the correct permissions were added, and they were.

I then went to each user, and had them open the database (on their own computer) just to make sure they were prompted to enter their username password, but they weren't. There were automatically logged on as Admin, just like any other unsecured d/b.

I tried to do some research, and it appears that the security I created is not specific to the database file itself, but rather to my hard drive. Now everytime I open any other database, I'm asked to enter the same credentials I created even though the other databases have no security whatsoever.

Does anyone know how I can fix this problem. I want each user to be able to open (from their own computer) the database from the shared server, but they need to be prompted a username and password.

Any help would be much appreciated.

Thanks.

[maxanon]

While most versions of Access work this way, knowing what version you're working with may help a little bit. The thing with passwords and permissions is that the file is separate and resides on your host computer. So, unless you want to go and do this set-up at every workstation you'll have to find another strategy.

The MS KB has reams of documentation on the short-comings of MC Access and this method of security.

Why do you need the l/p? Is it for data security?

[Greenstein]

  maxanon said:

While most versions of Access work this way, knowing what version you're working with may help a little bit. The thing with passwords and permissions is that the file is separate and resides on your host computer. So, unless you want to go and do this set-up at every workstation you'll have to find another strategy.

The MS KB has reams of documentation on the short-comings of MC Access and this method of security.

Why do you need the l/p? Is it for data security?

Access 2000

I need the l/p for data security purposes.

[Greenstein]

Anyone else have any suggestions? Please :D

Thanks.