[AccessD] Database access denied to workgroup member

Drew Wutka DWUTKA at Marlow.com
Wed Dec 19 16:43:35 CST 2007


Ok, a reboot would have fixed any file locks.

Your best bet now is that the share is corrupt.  It happens.  Remove the
share on Computer1.  Reboot the machine.  When it comes back up, create
a new share WITH A NEW NAME.  See if Computer2 and 3 can open the
database through the new share.  If they can, either leave that share to
use, or try to put the old share name back.

If that still fails, it's time to start digging through the event
viewer.  You may have to turn some auditing on, to capture what is
actually happening in the background.

Drew

-----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 3:08 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Database access denied to workgroup member

Drew,

The computer1 has already been rebooted, in fact several times.  I 
expect you have properly diagnosed the problem - the flash drive 
probably was removed too soon, or the operator actually had the database

open, or some other thing that put the database into an "opened 
exclusively by another user" state.  The database works from computer1, 
computer2 and computer3 are denied access.  Computer1 has been rebooted 
and doesn't appear to know there is anything wrong. 

I will get a look at all instances of the mdb and ldb - thanks for that 
suggestion.

Tina

Drew Wutka wrote:
> The quickest and fastest solution is to reboot computer1.  
>  
> If you don't want to reboot that machine, and it's windows 2000 or
later, go into computer management, and under shared folders you'll find
open files.  Find all instances of that .mdb and .ldb in Open Files,
right click and close those connections.
>  
> My best guess is that the flash drive was removed before the copy was
completed....this puts the database in a locked state.  After closing
the connections (either through Open Files, or by rebooting), your
database may prompt you that it's corrupt.
>  
> Drew
>
> ________________________________
>
> From: accessd-bounces at databaseadvisors.com on behalf of Tina Norris
Fields
> Sent: Wed 12/19/2007 11:58 AM
> 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
<http://www.databaseadvisors.com/> 
>
>
>   
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list