Prevent Access Opening Twice

  • Thread starter Thread starter Alan Z. Scharf
  • Start date Start date
A

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,

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
 
Back
Top