By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,584 Members | 1,750 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,584 IT Pros & Developers. It's quick & easy.

HELP! Having trouble with Workspace

P: n/a
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!
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <me@you.com> 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!

Nov 13 '05 #2

P: n/a
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" <me@you.com> 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!


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.