Tina Norris Fields
tinanfields at torchlake.com
Wed Dec 19 13:32:54 CST 2007
Gustav, So, the lock file disappears as it should. Is there then any reason to reboot computer1 and delete the lock file? Tina Gustav Brock wrote: > 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 >> > > > >