preventing multiple users using a frontend db

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

R.Warning - 04 May 2007 15:56 GMT

Hi,

In my front end access 2003 application I need to prevent that multiple
users are opening this file at the same time. is there a way to do this?

regards

Rob

Reply to this Message

Aaron Kempf - 04 May 2007 21:07 GMT

SQL Server has a simple 'single user mode'

if you used Access Data Projects-- like it is reccomended-- then you would
have a very very simple solution to your problem

> Hi,
>
[quoted text clipped - 4 lines]
>
> Rob

Reply to this Message

Ed Metcalfe - 05 May 2007 02:50 GMT

> Hi,
>
[quoted text clipped - 4 lines]
>
> Rob

1. Add a table to the frontend containing a single "UserID" field.

2. Add a hidden form to your database that is opened as part of your startup
routine.

3. Add an On_Open event to the form to add a record to the table.

4. Add an On_Close event to remove the record on form close (this will
happen when the user exits the database).

5. Add code to your startup routine to check the recordcount of the table.
If the recordcount >0 then Application.Quit.

Ed Metcalfe.

Reply to this Message