can't open an mdb db, need to map a shared drive, join security db

[Janis]

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

 

[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

I can't open the ascs.mdb file. It looks for the path z:SwimClub/ascs.mdb.
I don't have a network. Is there a way to force this db to open or to change
the path? I'm not even getting a login screen.
thanks,

 

[Tom Wickerath]

Hi Janis,

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

This document, which you can download from my web site, shows you how to use
a shortcut with the full path to the .mdw file in the target, so that you do
not need to permanently join to anything other than the vanilla system.mdw
file:

http://www.accessmvp.com/TWickerath/downloads/shortcut.doc

It is looking for the database in a shared drive z:\SwimClub
\acsc_be.mdb.

See my reply in the second thread that you opened up on this topic:

http://www.microsoft.com/office/com...d20853-f094-4bab-a1d7-365066bcb767&sloc=en-us


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Janis]

Thanks for the answer. I'm sorry my computer went down all weekend and I
didn't notice the previous answer until today when it was fixed.