[AccessD] Database access denied to workgroup member

Thanks to all who have responded. 

I agree, it sounds as though a lock file just didn't get deleted.  When 
I was there, I watched the lock files disappear when the database was 
closed on computer1 and did not see any other lock files, but I am going 
back over there to do exactly as so many of you have suggested.  Even 
though I think the ldb file disappeared as it is supposed to, perhaps 
there is an instance of it still hanging out.  We shall see.

The mapped drive issue has me puzzled, because on computer2 I can 
navigate to the shared folder on computer1.  So, computer2 appears to 
know where drive Z: is.  But, hey, we'll just refresh its memory and see 
what happens.  I'll let you all know what results we get.

Thanks again,
Tina

jwcolby wrote:
> Sounds like the lock file didn't get deleted.  Rebooting the server is the
> accepted solution however I think someone posted a way to force the lock
> file to delete even though it is supposedly open.
>
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
> Fields
> Sent: Wednesday, December 19, 2007 12:58 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Database access denied to workgroup member
>
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>