
Password protected Access.mdb from VB?
I've set up a password protected Access database. Unfortunately, I
can't seem to access it from VB and get the following message:
Can't start your application. The system database is missing or opened
exclusively by another user.
A sample of the code is as follows:
Dim MyWorkspace As Workspace
Dim MyUserName As String
dbengine.DefaultUser = "admin"
dbengine.DefaultPassword = "password"
' Error message appears trying to execute this statement
MyUserName = dbengine.Workspaces(0).UserName
Set MyWorkspace = dbengine.CreateWorkspace("Special", MyUserName,
"password")