 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / June 2006Disk Error
A client wanted to place an MS Access 2000 database in a folder on her C: drive and then share the folder on her c: drive out to certain users using a local network setup. Those certain users all have Full Control (through the shared folder). However, if more than one person attempts to add new data to the table or to access two different forms, the second person gets a DISK ERROR message and then the entire MS Access database locks up with a message 'cannot execute command' if the user attempts to click on any button in the main menu. The only way to remove this message is for the user to exit out of the dB and close the shared folder. The MS Access database and all forms have been set to only lock edited records and the dB has been split with the front-end residing on the different workstations while the back-end resides on the clients shared drive. The front-end tables have all been linked through the link manager utility as well. My question is why is the DISK ERROR occurring? Would this still occur if instead of using the client's c: drive as a network server, the client moves the database to a true server? Can someone please help me with this? I have checked all of the folder settings and the users all have full control and can enter the database at the same time but if they try to enter data or even view data from the same table at the same time, the DISK ERROR message results. Please, help with this from an Access pro would be much appreciated... > A client wanted to place an MS Access 2000 database in a folder on her > C: drive and then share the folder on her c: drive out to certain users [quoted text clipped - 17 lines] > client's c: drive as a network server, the client moves the database to > a true server? I'm not sure what "Full Control" means. Do the users have create file and and delete file rights? Problems not occurring with a single user, but with the second and following concurrent user, do happen when they don't have file create/delete rights. But, even that should not, I think, give the kind of error that you describe. Aside from the possibility of a problem with installing Access (which doesn't seem likely unless all were installed from a defective file/CD), or some wierd type of database corruption, I don't have any other suggestions. Larry Linson Microsoft Access MVP > Can someone please help me with this? I have checked all of the folder > settings and the users all have full control and can enter the database [quoted text clipped - 23 lines] >> client's c: drive as a network server, the client moves the database to >> a true server? Hi Larry, Thanks for your reply. Yes, all users have create and delete file rights. User Groups were not created in Access to limit rights. Do you think this is the problem? Should I create usergroups to eliminate the Disk or network Error Message? Thanks again for your help! > I'm not sure what "Full Control" means. Do the users have create file and > and delete file rights? Problems not occurring with a single user, but with [quoted text clipped - 38 lines] > >> client's c: drive as a network server, the client moves the database to > >> a true server? If by "usergroups," you mean Access User/Group Level Security, no, I wasn't talking about that at all. I was talking about user's Windows rights of access to the shared folder. If the last user to close the database does not have delete file authority, the .LDB file can't be deleted, and that can leave an LDB open and 'mislead' Access. Larry Linson Microsoft Access MVP > Hi Larry, > [quoted text clipped - 55 lines] >> >> to >> >> a true server? Hi Larry, If the dB were built in Access 2002 and the client has Microsoft Office 2003 Pro, will this cause the 'disk or network error' message? > If by "usergroups," you mean Access User/Group Level Security, no, I wasn't > talking about that at all. [quoted text clipped - 66 lines] > >> >> to > >> >> a true server? > If the dB were built in Access 2002 and > the client has Microsoft Office 2003 Pro, > will this cause the 'disk or network error' > message? It shouldn't. Access 2002 and 2003 share the same database file format, but both create databases by default in Access 2000 file format. In any case, no, none of these should cause the problem. Because I need to test DBs in various versions, I have both A2002 and A2003, generating in 2002/2003 database file format, and I switch DBs between them "at will" without any problems. MVP Tony Toews has told you that it is most likely indicative of a hardware or connection error, and he's done more with this kind of error than I have. Larry Linson Microsoft Access MVP ---------- > Hi Larry, > [quoted text clipped - 47 lines] >> >> client's c: drive as a network server, the client moves the database to >> >> a true server? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.