Can't open access mdb by double click if open on another pc

[Kenco Computers]

I can't open a mdb by double clicking on it in explorer if that mdb is open
on another pc on the same lan. However, if I start access and from its file
menu choose open it opens the file just fine.
Additional note: If the mdb is not open on another pc on the lan then it
opens up just fine via doubleclick.
OS Windows 2003 Server
Access 2003

 

[Jerry Whittle]

Double check with your network people that all users of the database have
read, write, create, and delete privileges on the folder holding the database
file.

 

[Kenco Computers]

It sounds like the double click is trying to open it exclusively. What
happens if you open it up by double clicking and then someone else tries to
open it while you still have it open?


Access works best if it does not need to move a lot of information over
the LAN. It is usually best to split a database when it will be sharing
data over a LAN. This will allow the whole system to work faster and in
some cases allow for customization of some forms reports etc.

This may seem like a lot of work and off the point of the question you
were asking, but it is very important that this part of the job be done
first and right.

Practice on some copies to make sure you know what you are doing.

Splitting a database can be a big job, but done right everyone will
thank you and wonder how they did their jobs without it.

Note: back ups become more important here. If you LAN does not support
automatic backups you should provide a method of backing up the data, even
if that means you do it manually.

It opens just fine from the other computers on the LAN even when I have it
open.

BTW I have already split the access programs we use into 6 mdb files each
with different UIs. However they still have to link to the main datafile.

 

[Kenco Computers]

Further update: It opens on the production windows 2003 server so it appears
to not be windows 2003 problem. It only happens on my windows 2003
development server. A comparison of the programs installed on both machines
shows they have the exact same service packs and hot fixes and the same
version of office 2003, however only my development machine has development
environments tools on it.
Another symptom: Every time I run one of my access programs that uses VBA to
ref DAO the OS tries to reinstall DAO.
List of development tools:
Visual studio v6 (C++, MFC, VB, J++)
Visual studio 2003(C++, MFC, C#.NET, VB.NET)
Visual web developer express (Asp.net, VB.NET, C#.NET)
..NET version 2.0
SQL express
C# express
C++ express
VB express