Error #47131
Error: Run-time error '3028'
Can't start your application. The system database is missing or
opened exclusively another user.
Debug: Set My Workspace = DBEngine.CreateWorkspace("New", _
"Admin", _
"")
Cause: You are setting the workspace using the global administrator
user name and password. The global administrator may not have
the necessary permissions to open the secured database.
Solution: Change the parameters to a valid user and password as
specified in the system database.
Debug: DBEngine.IniPath = <path and file name of an initialization
file specifying the location of the
system database>
Cause: In 32-bit Visual Basic, this property requires the registry
entry of the system database.
Solution: Set the property to the system database registry location
or use the SystemDB property of the DBEngine object. Set
the SystemDB property to the location and file name of the
system database.
Error: Run-time error '3029'
Not a valid account name or password
Debug: Set MyWorkspace = DBEngine.CreateWorkspace("New",
"UserName", _
"Password")
Cause: User name or password is not in the system database.
Solution: Add the user name and password to the system database.
Refer to the chapter in the Access documentation listed in
the references section of this article on how to add users
to the system database.
Error: Run-time Error '3265'
Item not found in this collection.
Debug: Set db = DBEngine.Workspaces("New").OpenDatabase("SecuredDB")
Cause: New workspace was not appended to the workspace object of the
DBEngine object.
Solution: Use the Append method of the DBEngine.Workspaces object to
append the new workspace object to the DBEngine object.
For more information, see the Append method in the Visual
Basic online Help.
Can't start your application. The system database is missing or
opened exclusively another user.
Debug: Set My Workspace = DBEngine.CreateWorkspace("New", _
"Admin", _
"")
Cause: You are setting the workspace using the global administrator
user name and password. The global administrator may not have
the necessary permissions to open the secured database.
Solution: Change the parameters to a valid user and password as
specified in the system database.
Debug: DBEngine.IniPath = <path and file name of an initialization
file specifying the location of the
system database>
Cause: In 32-bit Visual Basic, this property requires the registry
entry of the system database.
Solution: Set the property to the system database registry location
or use the SystemDB property of the DBEngine object. Set
the SystemDB property to the location and file name of the
system database.
Error: Run-time error '3029'
Not a valid account name or password
Debug: Set MyWorkspace = DBEngine.CreateWorkspace("New",
"UserName", _
"Password")
Cause: User name or password is not in the system database.
Solution: Add the user name and password to the system database.
Refer to the chapter in the Access documentation listed in
the references section of this article on how to add users
to the system database.
Error: Run-time Error '3265'
Item not found in this collection.
Debug: Set db = DBEngine.Workspaces("New").OpenDatabase("SecuredDB")
Cause: New workspace was not appended to the workspace object of the
DBEngine object.
Solution: Use the Append method of the DBEngine.Workspaces object to
append the new workspace object to the DBEngine object.
For more information, see the Append method in the Visual
Basic online Help.
User's solution
This works!