mdb fails to open with double-click

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-
 
T

Tom van Stiphout

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.
 
R

Robert Morley

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
 
L

Loralee

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.
 
L

Loralee

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?
 
J

John W. Vinson

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.

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]
 
T

Tom van Stiphout

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.
 
R

Robert Morley

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


Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top