Owner locked out on certain condition

[Guest]

I developed a secured, multi-user Access application whereby I have a
front-end and a back-end. I copied the front-end on everyone's workstation
and I placed the data file on the server. I also copied the MDW file on the
server in the same folder as the data file and everyone points to that MDW
file when they log in.

But something strange happens when I go into the public folder and I
double-click the data file to view the tables. I sometimes get the message
"You do not have the necessary permissions to open this database" (Or
something close to that). I happen to be the owner of the database files, so
I don't understand why I get this message.

However, when I copy the data file locally to my workstation, I don't get
the message. Keep in mind that I'm still pointing to the MDW file on the
server, like everyone else. I do notice something else. The message appears
when there are other users using the system concurrently... When nobody is
using it, I can open the file from the public folder.

Upon investigation, I noticed that I cannot have the MDW file in the same
directory as the data file. Why you ask? Well, I copied the MDW file and the
data file to my workstation (in the same folder) and I get the error message
popping up again. So my temporary solution was to place the MDW file in a
separate folder.

Has anyone come across this before or explain why this is so?

 

[steve]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

Steve