mdb fails to open with double-click

  • Thread starter Thread starter Loralee
  • Start date Start date
L

Loralee

I have an MDB that is working fine on 5 systems, but it will NOT open with a
double-click on the icon on ONE machine if other users have the file open.
If NO ONE has the file open, this machine will open the mdb with a
double-click on the icon. Also, if another user has the mdb open, this
machine can open the mdb only IF the user first opens Access, then opens the
file.

The mdb is A2K and is set up to share with multiple users(not open
exclusive). It has been running fine for almost a year with no issues like
this. The machine in question is running XP-Pro, and has a full version of
A2003. (Other machines that use the mdb have A2003 runtime version or full
license.)

Any ideas of things that we can try to fix this? Is there a setting I may
have missed? It's an annoyance that I'd like to get fixed if possible.

Thanks in advance-
 
On Fri, 25 Jan 2008 17:18:00 -0800, Loralee

Note that per best practices you're supposed to have the application
split in a front-end (on each workstation) and a back-end (on a
central server). It sounds like that is not your configuration. Make
it so, and post back if you're still having problems.

-Tom.
 
The only thing I can think of is that on all systems, but most especially
the one giving you trouble, go into Tools, Options, Advanced, then make sure
that the Default Open Mode is set to "Shared".


Rob
 
I don't have it split at this time as when I did split it, it took a long
time for each bound form to load (sometimes 15 seconds). When I kept it
intact there was no delay. This occurred whether the FE was placed locally
on each machine, or whether it was on the server in the same folder with the
BE. Also, we are going to have "thin clients" implemented in the department
soon and there will essentially be no "local" machine to put a FE on.
 
Thanks- her machine is set to shared also. (The app retained my settings.)
Is there another setting I may be missing- such as a default for all mdb's?
 
I don't have it split at this time as when I did split it, it took a long
time for each bound form to load (sometimes 15 seconds). When I kept it
intact there was no delay. This occurred whether the FE was placed locally
on each machine, or whether it was on the server in the same folder with the
BE. Also, we are going to have "thin clients" implemented in the department
soon and there will essentially be no "local" machine to put a FE on.
Click to expand...

See Tony Toews' performance FAQ to solve the form opening delay:

www.granite.ab.ca/access/performancefaq.htm

and his database splitting FAQ:

www.granite.ab.ca/access/splitapp.htm

By all means use your thin clients - but each user should have their own
folder with their own frontend.

John W. Vinson [MVP]
 
On Fri, 25 Jan 2008 17:18:00 -0800, Loralee

Another suggestion may be to create a new shortcut. Not to the MDB
directly, but like this:
<path_to>msaccess.exe <path_to>your.mdb

-Tom.
 
Virus scanners can cause inordinate delays sometimes. Try disabling virus
scanning and see if there's a sudden (often dramatic) improvement.


Rob
 
Back
Top