By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,462 Members | 2,394 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,462 IT Pros & Developers. It's quick & easy.

How To Prevent a User from running 2+ copies of the Same Access Application

P: n/a

I have a rather unusual problem. Users sometimes run 2 or more copies of the
Access application on the same computer simultaniously. This creates some
problems with duplication of records. Is there any way to programatically keep
users from running more than one copy of the program at a time.

I'm running MS Access 97 on a brand new, XP system.

(For what it is worth, I've tried explaining the problem to the users, have
given them written instructions, and frequently remind them NOT to do this. I
simply can't count on them to understand nor follow the instructions.)

Thanks!
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 31 Dec 2004 19:38:44 GMT, jk******@aol.comTijuana (Hulda Clark Got
Zapped) wrote:

I have a rather unusual problem. Users sometimes run 2 or more copies of the
Access application on the same computer simultaniously. This creates some
problems with duplication of records. Is there any way to programatically keep
users from running more than one copy of the program at a time.

I'm running MS Access 97 on a brand new, XP system.

(For what it is worth, I've tried explaining the problem to the users, have
given them written instructions, and frequently remind them NOT to do this. I
simply can't count on them to understand nor follow the instructions.)


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

mike
Nov 13 '05 #2

P: n/a
Mike's answer should cover you completely. antother alternative is to
use a lockfile.

George Marselis

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.