HELP! Having trouble with Workspace

[Jozef]

Hello,

I am trying to put together a module and open a workspace on a database that
has a simple password (using Access XP). This is the lin that I'm having
trouble with;

Set wrk = CreateWorkspace("TestWrkspc", "Admin", conDbPwd)

conDBPwd is a variable that contains the password. There is no independant
workgroup file, just the default. This is the error message I'm getting;

"Runtime error 3028: Cannot start your application. The workgroup
information file is missing or opened exclusively by another user".

This is a standalone machine, I have only one Access window opened. The
default WGIF is used.

Any ideas what's wrong?

Thanks!

[Douglas J. Steele]

AFAIK, that only works if you've got Access security turned on, as opposed
to a simple database password.

Try opening the workspace without the User and Password, then providing the
password for the OpenDatabase command:

Set wrk = CreateWorkspace("TestWrkspc")
set myDB = wrk.OpenDataBase(app.path & _
"\mydata.mdb",0,0,";pwd=" & conDbPwd)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Jozef" <[e-mail]> wrote in message news:Ar02f.10757$Io.6390@clgrps13...

Hello,

I am trying to put together a module and open a workspace on a database
that has a simple password (using Access XP). This is the lin that I'm
having trouble with;

Set wrk = CreateWorkspace("TestWrkspc", "Admin", conDbPwd)

conDBPwd is a variable that contains the password. There is no
independant workgroup file, just the default. This is the error message
I'm getting;

"Runtime error 3028: Cannot start your application. The workgroup
information file is missing or opened exclusively by another user".

This is a standalone machine, I have only one Access window opened. The
default WGIF is used.

Any ideas what's wrong?

Thanks!

[Jozef]

Thanks Doug,

I had to specify the "Admin" user and "" password, other wise I'd get an
"Argument not optional" message, but other than that, it worked.

Thanks again!

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:DN********************@rogers.com...

AFAIK, that only works if you've got Access security turned on, as opposed
to a simple database password.

Try opening the workspace without the User and Password, then providing
the password for the OpenDatabase command:

Set wrk = CreateWorkspace("TestWrkspc")
set myDB = wrk.OpenDataBase(app.path & _
"\mydata.mdb",0,0,";pwd=" & conDbPwd)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Jozef" <[e-mail]> wrote in message news:Ar02f.10757$Io.6390@clgrps13...

Hello,

I am trying to put together a module and open a workspace on a database
that has a simple password (using Access XP). This is the lin that I'm
having trouble with;

Set wrk = CreateWorkspace("TestWrkspc", "Admin", conDbPwd)

conDBPwd is a variable that contains the password. There is no
independant workgroup file, just the default. This is the error message
I'm getting;

"Runtime error 3028: Cannot start your application. The workgroup
information file is missing or opened exclusively by another user".

This is a standalone machine, I have only one Access window opened. The
default WGIF is used.

Any ideas what's wrong?

Thanks!