[AccessD] Database access denied to workgroup member

HI Tina,
 
We had this issue before with some medical software we wrote that was being used on a workgroup.  We found that if we gave every user an account on the pc holding the database, and then gave those users permission on the shared folder, the problem went away.  You my need to re-map the shared folder on each pc that is trying to access the database.  Julie ReardonPRO-SOFT OF NY, INC. 44 Public Square Suite #5Watertown, NY 13601 Phone: 315.785.0319 Fax: 315.785.0323www.pro-soft.netNYS IT Services Contract CMT026ANYS Certified Woman-Owned Business> Date: Wed, 19 Dec 2007 12:58:26 -0500> From: tinanfields at torchlake.com> To: accessd at databaseadvisors.com> 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
_________________________________________________________________
Get the power of Windows + Web with the new Windows Live.
http://www.windowslive.com?ocid=TXT_TAGHM_Wave2_powerofwindows_122007