[AccessD] Database access denied to workgroup member

Don't forget that if it is a PATH error, then rebooting it will help solve
that (Z:\ sounds like a mapped drive to me.  Actually, on my system it is
now my TrueCrypt Mounted Drive).  If you cannot see the path and/or folders
in Windows Explorer (or go to Start/Run and type it in), then a reboot may
help)

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Wednesday, December 19, 2007 8:36 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Database access denied to workgroup member

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/> 



No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.503 / Virus Database: 269.17.4/1189 - Release Date: 18/12/2007
21:40