how to join the workgroup security file system?

7 Mar 2009 9:07 PM

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

8 Mar 2009 2:17 PM

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

JRough wrote:
Show quoteHide quote

> 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

9 Mar 2009 9:41 AM

Keith Wilby

"Joan Wild" <jwild@nospamtyenet.com> wrote in message
news:e3JhZr$nJHA.5412@TK2MSFTNGP04.phx.gbl...

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