Re: Access Database Security

From: Rob Schneider (rmschne_at_removetheones_b1e1e1b.net.net)
Date: 07/15/04 

Date: Thu, 15 Jul 2004 18:56:32 +0100

I see you've asked this three times, all without reply ... best to:
1. re-ask in a newsgroup dedicated to Access, especially for Access
developers.
2. hire an Access developer to do this for you.

Hope this is useful to you. Let us know.

rms

Kevin wrote:
> Can anyone help us set up a database that can only be
> opened by one user at a time? We are using Access 2000 on
> Windows 2000 Professional. We tried using the user level
> security wizard and setting the user group permissions to
> exclusive and then no one could open the database at all,
> not even the admin user.
>
> We tried setting the database to exclusive in the options
> of all users and that failed.
>
> We tried using file-open and selecting exclusive using the
> down arrow next to the open button and that failed.
>
> Instructions on how to do this correctly would be much
> appreciated.
>