Error when trying run query in mde

[JoeA2006]

I placed an mde file in a network folder. I have no trouble running a copy
from my c drive or from the network folder. The app only has one linked table
in another mdb in another network drive. A user gets the error "cannot open
F:\.......
It is already open exclusively by another user or you need permission to
view the data.

I have never received this message in testing.. might it have something to
do with were it is compiled or something else?

 

[Carl Rapson]

I placed an mde file in a network folder. I have no trouble running a copy
from my c drive or from the network folder. The app only has one linked
table
in another mdb in another network drive. A user gets the error "cannot
open
F:\.......
It is already open exclusively by another user or you need permission to
view the data.

I have never received this message in testing.. might it have something to
do with were it is compiled or something else?

Is the file name that it cannot open (F:\...) pointing to the mde file or
the mdb file? If it's the mdb file, you'll need to be sure that the link
within the mde file is done in such a way that each user's PC can recognize
it. Sometimes, some PCs won't have the same drive letter mappings. I find it
best to use a file's UNC path (\\server\path\file) instead of a drive
letter, for that reason.

If the error is on the mde (compiled) file, it may be that someone else has
already opened the mde file. It could also be a network permissions problem.
Those kind of problems occur frequently when multiple users try to run the
same mde file off a server. What works best is to copy the mde file to each
user's PC. As long as any tables are linked instead of local, it shouldn't
be a problem.

Carl Rapson