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

[Guest]

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

 

[Guest]

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.

 

[Joseph Meehan]

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

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.

 

[Guest]

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.

 

[Joseph Meehan]

Kenco Computers wrote:
....>>

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

Well that about blows my idea.

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.

Good going.

 

[Guest]

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