Prevent Access Opening Twice

[Alan Z. Scharf]

1. I need to prevent users from opening two instances of Access ADP. I'd
like to do this in VBA.

2. Ideally, in startup window of app, there would be code to close app if
that Access app is already open.

How can I do this?

Thanks.

Alan

 

[Allen Browne]

See:
Preventing multiple instances of a database
at:
http://www.mvps.org/access/api/api0041.htm

 

[Alan Z. Scharf]

Allen,

Thanks very much. That did the trick.

One more question:

Is there also a way to prevent the message dialog:

The application will be opened in read-only.....

I'm running this from Autoexec macro.

Thanks again.

Alan

 

[Allen Browne]

Sorry: I'm not sure what's causing you to get this message.