Problem working with access database that has 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

I know for sure that the login I am using gives me administrative rights on the second database, which is the only one I am trying to work with right now (trying to delete tables:

dbBackup.TableDefs.Delete "customers"
dbBackup.TableDefs.Delete "hardware"
dbBackup.TableDefs.Delete "hospital systems"
dbBackup.TableDefs.Delete "Specialist"

Every time I try this, it says I don't have the necessary permissions so my conclusion is that I am DEFINITELY passing the user id and password incorrectly, since I can't even read the tables when accessing them this way. Can anyone help?

 

[gk207541]

Just for curriosity : why doesn't anybody around here use ADO ?

 

[Paladyr]

Hey, if you know of a way to use ADO and do this, let me know. I use ADO for all my recordset stuff, but haven't seen a way to do it with ADO.