Securing an Access Database from Unauthorized Access

[judelakmal]

We have an access database installed in the server.
Multiple users have been recieved rights to access the folder
which contain that database.

how can we stop accessing this shared folder by other users.

Regards
Jude

[ADezii]

We have an access database installed in the server.
Multiple users have been recieved rights to access the folder
which contain that database.

how can we stop accessing this shared folder by other users.

Regards
Jude

From what you are describing, this is not an Access Security issue, but an Operating System restriction revolving around access to the folder containing the Access Database. This can be done on a User/Group basis on your Network.

[NeoPa]

From what you are describing, this is not an Access Security issue, but an Operating System restriction revolving around access to the folder containing the Access Database. This can be done on a User/Group basis on your Network.

Please reply if you need more help on the subject.
If so, we can move your thread to the Windows Forum.

[judelakmal]

Yes can I direct to the Windows Forum

[Rabbit]

It has been moves as per your request.

[CondoPC]

You will need to set up file and folder level security, as well as proper share security. In addition, you should not have "Creator Owner" as a member in the folder because you could run into locking issues with the database because a user will own the .ldf file, preventing other users from connecting to the database.

[NeoPa]

So all users of the database should have Change permissions in their own right that means.

[Cyberdyne]

In your server navigate to the drive that contains the folder that you want to secure and right click on it, go to properties > sharing > permissions then remove everyone and add the users you want to access the folder, apply the changes and you should be all done.

You can also right click > properties > security and chose what kind of access to the database each user will have.

And last but not least, you can secure the database within itself, by implementing an access by username and password when you launch the database.

Good luck.

Cyber