Printable View
After setting different users and passwords through Ms Access to a database ( secured database ) ; How can I open that database with a specific user name through DAO 's opendatabase method in VB ? I know how to open a password protected database file ; here I wants to open with the privilages of a specific user. ie; I wants to provide user level security. Thankz
We're going back sometime here, but I'll try give you some pointers.
First set the the path to the system.mdw (workgroup security settings file). This path is a property of the DBEngine, probably something like systemdb(?).
Once you have that property set you should create a workspace with the appropriate User Name and Password (for this you can create a logon form). If the procedure fails (i.e. workspace could not be created) then the username or password was invalid.
HTH