secure database corruption recovery

[Teresa]

I hope someone can give me some advice...

I have my acccess 2002 database secured over a network. I
was the only admin. When I tried to log on as an admin
from a different computer, it somehow corrupted my
workgroup file and now the database will not let anyone in
from anywhere. We get the "you do not have permission to
access..." message. I tried to restore my work group
fromt the print out that was created when I used the
security wizard, using the exact information. That didn't
work. What I noticed on the print out is that the Admins
group says it was previously created so there was no
written group ID. Is that a default value? Or do I need
that group ID along with all the other user/group data to
restore my workgroup file?

Also, if I am out of luck, and can no longer access this
database, is there a way using VBA code to access the
table data? If so, how?

Thanks for your help,
Teresa

 

[Joan Wild]

I hope someone can give me some advice...

I have my acccess 2002 database secured over a network. I
was the only admin. When I tried to log on as an admin
from a different computer, it somehow corrupted my
workgroup file and now the database will not let anyone in
from anywhere. We get the "you do not have permission to
access..." message.

It likely wasn't corrupted. You were perhaps not joined to the correct
workgroup. Put the secure.mdw workgroup file you created on the server with
the database. Then create a desktop shortcut with a target of
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
and try logging in as one of your users.

 

[Teresa]

Thanks for your help.

I was able to get on as one of the users after re-creating
the work group with just his information. That was a very
good suggestion. Now I can also access the DB from own
computer using the same workgroup file. There are no
longer any passwords required, which is fine for now.
Next time I will make backups of my secured.mdw file, in
addition to printing out the information.

Thanks again!
Teresa