Connecting to a secure Access 2.0 database with DAO

[jeremyw]

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????

[Michael]

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.