> I have got following annoying problem:

> When attempting to access a secured MS Access database (workgroup file is
> set with the workgroup administrator etc...) using following code:

> DbEngine.SystemDB = msSystemDB
> Set mWS = DBEngine.CreateWorkspace ("nameofmdwfile",
> "myloginname","mypassword")

> Results always in:

> Runtime error 3028 Can't start you application: The workgroup information
> file is missing or opened exclusively by another user.

> Workgroup file is in place.
> Workgroup file is registered in the registery as it should be
> Workgroup file nor database is opened/in use by someone else (stand-alone
> machine) even not by myself.

> When trying to access the database with a fake password or username it
gives
> the good result that access was denied due to wrong username or password.
> When trying to access it with right username-password it get the runtime
> error 3028

> Opening the database in Access using logon-password works fine

> What is wrong? What should I check or try?

> PS it is a MS Access 97 database
> using VB 5 Pro on a NT 4 machine

> Any help or tips are welcome
> Thanx in advance!

> Nicolas