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=***;"
Set dbBackup = OpenDatabase("C:\Backups\Log.mdb", , , "UID=***;PWD=***;"
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?
Set dbMaster = OpenDatabase("Networkpath\database97.mdb", , , "User Id=***;Password=***;"
Set dbBackup = OpenDatabase("C:\Backups\Log.mdb", , , "UID=***;PWD=***;"
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?