workgroup information file is missing

J

JRough

I get the error "cannot start your application running this vbscript.
The workgroup information file is missing or opened exclusively by
another user." The front-end is located in the folder c:\SwimClub
\acsc.mdb. The backend and the system file are located at Z:\SwimClub
\acsc_be.mdb & Z:\SwimClub\system.mdb so this should work. Where is
the workgroup information file? Isn't it in the system file? tnx,

set dbe = createobject("dao.dbengine.36")
dbe.SystemDB="Z:\SwimClub\system.mdb"
dbe.DefaultUser = "Brian"
dbe.DefaultPassword ="Kiyote#3"
dbe.CompactDatabase "Z:\SwimClub\acsc_be.mdb","Z:\SwimClub
\compact_acsc_be.mdb",";pwd=Kiyote#3"
 
J

JRough

I think you have a typo.  Workgroup files have the mdw file extension, not an
mdb file extension.  Try changing this line

dbe.SystemDB="Z:\SwimClub\system.mdb"

so it looks like this:

dbe.SystemDB="Z:\SwimClub\system.mdw"

Chris
I changed it to SYSTEM.mdw and I got the same error. "the workgroup
info file is missing or opened in exlusive mode by another user
even though I don't have the database open. I think the workgroup
info file (system.mdw) is corrupted? I did have several folders with
the database and somehow it got crisscrossed. I had an older
system.mdw file and i tried that one and it still didn't work. What
can I do?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top