how to join the workgroup security file system?

[JRough]

I'm trying to fix someone's db and I'm trying to get it set up so I
can look at it. There are 3 files:
1. The Access database filename is acsc_be.mdb
2. the Access program filename is acsc.mdb.
3. The workgroup security file is system.mdw.

I'm getting the error message: You must join the workgroup that
defines the user accounts used to access the db. I have the login and
password.

It is looking for the database in a shared drive z:\SwimClub
\acsc_be.mdb. So I tried to map a z:SwimClub drive and put the mdb
file in there. My computer doesn't have a shared drive so I don't
know how to open this file to look at it? Also I don't know how to
join the workgroup user accounts?

There seems to be a simple problem with the db. Everytime a report
runs it has to be compressed first or it crashes. My thought was to
add a compression step after the report runs so that it is already
compressed for the next time the report is run. That is if I can
figure out how to open it.

thanks in advance,
Janis

 

[Joan Wild]

Create a desktop shortcut with the following in the target...
"path to msaccess.exe" "path to acsc.mdb" /wrkgrp "path to secure
system.mdw"

You don't need to map z: to anything. Use the shortcut to launch the
mdb, and login using the username/password you were given. You might
need to hold down the shiftkey while you open it to bypass any startup
settings.

It's looking for the acsc_be.mdb on z:\SwimClub because that is the last
known location of the backend. To fix this, go to Tools, Database
Utilities, Linked Table Manager. Select all, and put a check beside
'prompt for new location'. Locate the acsc_be.mdb file and refresh the
links.

Joan Wild
MS Access MVP

 

[Keith Wilby]

Haven't "seen" you around in a while Joan, welcome back