Permitting a single copy of the database to be opened.

[biscuitboy]

Hi

Ive created a database in access and what I would like to be able to do is create a piece of code so that if it is open on a computer the user can not open a second copy of it.

Is this possible?

Regards

 

[SJMcAbney]

You could just set it to be opened exclusively.

Why woudl you want to do this anyway? To me it reads as if you may be having data locking problems because you have not properly split the database into a frontend and backend application.

Stewart