[AccessD] Database access denied to workgroup member

Hi Tina

Yes.

/gustav

>>> tinanfields at torchlake.com 19-12-2007 20:04 >>>
Hi Gustav,

The ldb file disappears as one would expect when the database is closed 
on computer1.  When the database is open, there is lock file for it and 
a lock file for the mdw file as well.  Is this as it should be?

Tina


Gustav Brock wrote:
> 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