DAO multiple user security

[Arunraj]

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

[phunkydude]

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