"Could not lock file"

[Rochelle Treister]

An Access DB sitting on a PC running XP opens successfully
from the PC.

But when anyone tries to access the PC over the network
and open the MDB, they get the message "Could not lock
file"

When the whole MDB is copied onto someone else's PC, then
they get the message,
"You do not have the necessary permissions to use
the 'C:\...\...\xxx.mdb' object. Have your system
administrator or the person who created this object
establish the appropriate permissions for you."

What needs to be done to make this mdb available either
through the network or on other PCs?

 

[TC]

An Access DB sitting on a PC running XP opens successfully
from the PC.

But when anyone tries to access the PC over the network
and open the MDB, they get the message "Could not lock
file"

When the whole MDB is copied onto someone else's PC, then
they get the message,
"You do not have the necessary permissions to use
the 'C:\...\...\xxx.mdb' object. Have your system
administrator or the person who created this object
establish the appropriate permissions for you."

You will probably need to copy the workgroup information file (MDW) as well.
Then use a shortcut of the following format to open the database. All on one
line:

"full path to MSACCESS.EXE"
"full path to MDB file"
/wkgrp "full path to MDW file"

HTH,
TC