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.

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"

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm



"Steffan Conroy" <(E-Mail Removed)> wrote in message
news:0a5301c368a7$25190650$(E-Mail Removed)...
> 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.