View Single Post
  #1 (permalink)  
Old May 11th, 2006, 10:30 AM
nbourre nbourre is offline
Registered User
 
Join Date: May 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Permissions on DB without user-level security

Hi,

Is it possible to set permissions on a MDB file without using the user-level security?

I'm working on a project and it will be copied on many computers on the field (No network connection). I want to protect the structure and other things from the coordinator who will only enter the data into the database. If I use user-level security, the DB cannot be opened on foreign computers.

By example:
When the user open the MDB file a form appears and ask for the login and password.
Depending on the user group, permissions are granted for a number of objects.

Is it possible to program that in VBA?

Thank you

Nick

Reply With Quote