How do I open a database with security setup on it

[Paladyr]

I have a database that whenever you open it, it prompts you for a user name and password. This is a security feature built into Access. Here is the way I am opening the database:

Set dbMaster = OpenDatabase("Networkpath\database97.mdb", , , "User Id=***;Password=***;&quot
Set dbBackup = OpenDatabase("C:\Backups\Log.mdb", , , "UID=***;PWD=***;&quot

Am I doing this correctly? Thanks for the help!

 

[Paladyr]

Wrong forum sorry .

 

[adscrims]

Scrap the way your doing it now. There is a feature in Access which is built in. Go on to the tools menu and then on security. Use the user level security wizard to set up accounts for your database for the different users of it. hope this is of help
Andy:-9