Prevent user opening database twice

[grazer99]

I have a small peer-peer setup with a database on 1 pc, another 3 users access the database.

Is there any way I can stop the same user from opening the database more than once ?

 

[orna]

This can help you

http://www.mvps.org/access/api/api0007.htm

 

[Pampers]

On the same PC? (Because I think that is not possible)...

Pampers
Keeping it simple can be complicated

 

[orna]

Try:

http://www.mvps.org/access/api/api0013.htm

 

[grazer99]

Hi Pampers,

I thought you were right at first, but then i discovered that if the db is on the local pc, you are right it is impossible, but if the db resides on a remote drive and you create a shortcut to open from another pc, it can be opened more than once.

 

[TheAceMan1]

How are ya grazer99 . . .

Your present state of affairs are certainly [red]headed for corruption.[/red] You should [blue]give strong consideration[/blue] to [purple]spliting you database![/purple]

Why Split a database?

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886