I have a database that opens from another database. The main database uses a
shortcut to open where users must enter username and password. The second
database actually has no security, and if you browse to it in windows
explorer and double-click, it opens normally....usually.

A user was working in the database who was connected via dial-up connection
and lost his connection. Now when anybody tries to open the database, it
says it needs to be repaired...but it won't repair! I've made a copy of the
second database (the main one still works fine) and it won't let me open it
anymore saying I don't have permission. The database is in Access 2000,
although I'm using 2003 to try to recover it. I'm looking for the Wrkgadmn
file, and can't find it on my computer...is this done differently in 2003?

I've also tried downloading the JetComp utility, but it just says "There was
an error compacting the database" and does nothing.

Any ideas how I can get the data from this damaged database?? I can't
import from it or link to it...just get the message saying I don't have
permission!
Thanks!!
Susan

"Susan" <(E-Mail Removed)> wrote in message
news:6D2619C3-D7AF-40FD-8BB6-(E-Mail Removed)...
>I have a database that opens from another database. The main database uses
>a
> shortcut to open where users must enter username and password. The second
> database actually has no security, and if you browse to it in windows
> explorer and double-click, it opens normally....usually.
>
> A user was working in the database who was connected via dial-up
> connection
> and lost his connection. Now when anybody tries to open the database, it
> says it needs to be repaired...but it won't repair!

Running an Access database directly over a dial-up connection is a terrible
idea (and you've found out why).

> I've made a copy of the
> second database (the main one still works fine) and it won't let me open
> it
> anymore saying I don't have permission. The database is in Access 2000,
> although I'm using 2003 to try to recover it. I'm looking for the
> Wrkgadmn
> file, and can't find it on my computer...is this done differently in 2003?

It's part of Access now - Tools, security menu - workgroup administrator.

> Any ideas how I can get the data from this damaged database?? I can't
> import from it or link to it...just get the message saying I don't have
> permission!

You should be able to join the correct workgroup and get in (or import from
it). Before doing so, check in the folder where the mdb is, and if there is
a file with the same name but a ldb extension, delete the ldb file.

It is possible that your database is not repairable by the standard methods,
and you'll have to consider restoring a backup or, if it's worth it, having
a data recovery firm help (www.pksolutions.com).

You should consider using Terminal Services for that remote user.

--
Joan Wild
Microsoft Access MVP

Well done on taking a copy of the bad db, so you're no worse off if the
original one gets messed up further :-) Many people keep messing with
their single copy of the bad db, to the point where it gets thoroughly
clobbered, and no-one can fix it at all.

A competent data recoivery service should be able to fix it, IMO.

HTH,
TC