Workgroup Information File

[Vincent]

Help!!!

I created a database and then moved it to another computer
together with its SYSTEM.MDW file. Once there, I created a
workroup information file on the new computer, which
specified the system.mdw as the one I had copied.

I was able to view the database without problems. Now, I
cannot do so on the computer where I created the
workgroup information file, although I can access the
database from every other computer in the network. What
should I do?

Vincent

 

[Vincent]

Hi Eric,
the error message i am getting is that the Workgroup
Information File is no available or has been opened
exclusively by another user. How do i get round this?

Vincent

 

[Eric Butts]

Is it possible that you have the MDW file and the MDB file as the same name
residing in the same folder?
If so, try moving the MDW file to a different folder.

I think we can help better if you could answer the following:

- What directory does the MDB file reside:

- What directory does the MDW file reside:

- What's the name of the MDB file:

- What's the name of the MDW file:

- What are the exact steps the user's are using to open the database:

 

[Vincent]

The following files all reside in the same folder:
S:\directory\mydatabase.mdb
S:\directory\System.mdw
S:\directory\mydatabase.ldb

The database is being opened by opening the directory
where it is and then opening the file from there.

 

[Joan Wild]

Help!!!

I created a database and then moved it to another computer
together with its SYSTEM.MDW file. Once there, I created a
workroup information file on the new computer, which
specified the system.mdw as the one I had copied.

I don't follow this. You shouldn't need to 'create' a workgroup file on the
new computer. Just refer to the mdw file that you copied (I assume this is
the mdw that was used to secure the database).

I was able to view the database without problems. Now, I
cannot do so on the computer where I created the
workgroup information file, although I can access the
database from every other computer in the network. What
should I do?

On the new computer create a desktop shortcut like:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
The 'path to mdw' would be the path to the mdw that you copied to the
computer. You could instead put the mdw on the server and have everyone
point to it.

 

[Eric Butts]

So here's how I would open the file

- First close Microsoft Access
The file S:\directory\mydatabase.ldb should disappear
(confirm that this file has disappeared, if not, and you've assured
yourself that no one is in the database <MDB> then delete the LDB
file....If you can't delete then you are looking at corruption in your
database)

- Create a shortcut on your desktop that has the following as the target

c:\Program Files\Microsoft Office\Office\msaccess.exe
S:\directory\mydatabase.mdb /wrkgrp
S:\directory\System.mdw

Database should open fine and you should receive a prompt to enter User
Name and Password (of course assuming the Admin account has a password
assigned)