Stopping Multiple Instances

[Guest]

My 50 or so access users feel it necessary to have the same database open several times on their PC. I feel this is causing instability to this database, please correct me if I'm wrong. Is there a way I can prevent that linked database to be open more than once at the same time?

 

[Jeff Conrad]

This link may be of help:

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

--
Jeff Conrad
Access Junkie
Bend, Oregon

My 50 or so access users feel it necessary to have the same database open several times on their

PC. I feel this is causing instability to this database, please correct me if I'm wrong. Is there
a way I can prevent that linked database to be open more than once at the same time?

 

[Albert D. Kallal]

I do assume that you have a copy of the front end on each pc..right?

You REALLY need to have a split system..where you place the program part on
each pc.

Generally, then you *can* allow multiple copies..and stability as a rule
will NOT change.

Here is some info on splitting...
http://www.granite.ab.ca/access/splitapp.htm

 

[Tony Toews]

My 50 or so access users feel it necessary to have the same database open several times on their PC. I feel this is causing instability to this database, please correct me if I'm wrong. Is there a way I can prevent that linked database to be open more than once at the same time?

Possible but unlikely that opening the MDB several times on thief PC
is causing instability.

What do you mean by instability? What error messages are you getting?

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm