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]

Anyone know?

 

[Paladyr]

Help me database guy, please!!!

 

[scorpio66]

OK, this is from memory, so may be wrong.

Access security is handled in a separate file. In the ODBC settings for Access you need to provide a System database - this is where all of your UserID/Password information is kept.

I'm not sure how this is set when setting the DSN by hand.

Chaz

 

[Paladyr]

Okay, I found what you were talking about, found the database on my hard drive, changed it in the ODBC settings, but it still doesn't work . Thanks for the reply though, didn't know about that before!!! Any other ideas??? Has anyone messed with anything like this before?

 

[Paladyr]

Found a local expert, you were on the right track. The workgroup file had to be re-created so that I was an admin (person that initially created it is gone!). Thanks for the help!

 

[scorpio66]

no problem ;-)

Chaz

 

[Paladyr]

SPOKE TOO SOON!!!!! Still doesn't work. I have set myself up as admin and have verified that I am the owner/administrator of this database, however I get the same darn message when trying to delete tables!!! It doesn't seem to like how I am passing the User name and password. When I was using an ADO recordset it seemed to take my user name and password just fine, but I couldn't figure out a way to delete the table itself. Any ideas?