471,089 Members | 1,098 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,089 software developers and data experts.

HELP! Having trouble with Workspace

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
2 4358
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
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.

Similar topics

9 posts views Thread by Tom | last post: by
4 posts views Thread by Sarir Khamsi | last post: by
2 posts views Thread by Sudheer Kareem | last post: by
6 posts views Thread by wukexin | last post: by
3 posts views Thread by Colin J. Williams | last post: by
5 posts views Thread by Steve | last post: by
8 posts views Thread by Mark | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.