Tina Norris Fields
tinanfields at torchlake.com
Thu Dec 20 08:13:37 CST 2007
Thanks Drew, Today, we are checking out all the suggestions. Truly I appreciate your help. Tina Drew Wutka wrote: > 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/> > >> >>