[AccessD] Database access denied to workgroup member

Hi Tina

Reboot computer1 and delete the ldb file for the shared database.

/gustav

>>> tinanfields at torchlake.com 19-12-2007 18:58 >>>
Hi All,

Well, here is another little puzzle.  An Access database (2K format) 
resides on computer1 in a shared folder.  The workgroup contains 
computer1, computer2, and computer3.  Computer2 is physically nearby, 
while computer3 has an internet connection to computer1.  The network is 
peer-to-peer, with computer1 hosting the database.

Last Friday, the data entry person on computer2 made a backup of the 
database onto a flash drive, as she normally does, then continued 
working with the database until quitting time, when she shut down her 
computer (computer2).  The next person to use computer2 was unable to 
open the database. The person with remote access was also unable to open 
the database.  I've been over to see what was going on (this is a first 
contact).  I'm not a network guru, so I'm looking for both database and 
network guidance here.

Here's what I've established so far: 
1.  from computer2 it is impossible to open the database on computer1.  
The message is "cannot find Z:\\foldername\databasename"  If one 
launches Access and navigates to the folder where the database resides 
and attempts to open the database, the message is that another user has 
opened the database exclusively - this comes up even if nobody is using 
the database.
2.  from computer2 it is impossible to copy the database to the flash 
drive.  The message is that access is denied.

The database has some real structural issues, such as tables without PKs 
and missing relationships - but, it was working for them until Friday.  
They state that the database was closed when the backup was made and 
that the backup process was the same as always before. 

What should I be looking for?  I'm guessing that the database was 
actually open and somehow copied in an "open" state that has scrambled 
things.  I would like to get these folks back up and running on all 
three computers, instead of being restricted as they now are, to one 
computer for their listings data.  Please point me in the right direction.

Thanks for all help,
Tina