I am trying to connect to a secure Access 2.0 database using DAO/Jet. I have an ID and password that has full rights, the Admin ID does not have any rights. I need read only rights, but everytime and way I try to connect I get errors. Any ideas????
Printable View
I am trying to connect to a secure Access 2.0 database using DAO/Jet. I have an ID and password that has full rights, the Admin ID does not have any rights. I need read only rights, but everytime and way I try to connect I get errors. Any ideas????
Hi Jeremy
I have exactly the same setup as you with one difference - it is Access 97.
I use the following code to open my secured db:
Dim ws As Workspace
Dim db as Database
DBEngine.SystemDB = "YourSecuredSystem.mdw"
Set ws = CreateWorkspace("", strUserName, strPassWord, dbUseJet)
Set db = ws.OpenDatabase("YourDatabaseName")
I have never used Access 2.0 - I started with 97 and I don't know what the differences are.
Hope this is of some use.