Active Directory permissions on back end database

[vbajock]

I have a BE that I don't want the users to have access to. How would I set the folder rights so that my VBA program can access the data under the user's login while preventing him from having the ability to open the BE via Explorer?

 

[StarPassing]

Set a password in the BE.

 

[Ed2020]

I secure the database with Access's user level security then create a launcher in VB6 to open the frontend and pass access.exe the user name and password. That way the user doesn't need their own user name and password so they have no way of opening the backend.

Ed Metcalfe.

Please do not feed the trolls.....