Locked out of database

[Steffan Conroy]

I want to allow another user to share an Access 2000
database. I split the database and now have a server mdb
file with just the data and a client mdb. I set up
security on the development workstation. I then copied the
client mdb file and the workgroup file (mdw) to the other
workstation and used the workgroup administrator to link
to the workgroup.

However, when I launched the database, I was not prompted
to login. The users i had added did not show in the
database security dialog. I created a new user and added
him to the admins group. I then removed the Admin user
from the admins group.
Result. I am now locked out of the database on that
workstation. Can anyone advise me.
Steffan.

 

[Lynn Trapp]

If you were not prompted for a password, that indicates that the Admin user
for the workgroup information file has a blank password. You should create a
shortcut for each workstation to use. The general syntax for the target is:

"FullPathToMSAccess.exe" "FullPathToDatabase.mdb" /wrkgrp
"FullPathToSecureWorkgroup.mdw"