 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / November 2004Cannot delete record
I am running Access 2000 on a Citrix network with multi-users. If 2 users attempt to enter a new record at the same an issue may arise. In the past we replaced the entire file with yesterday's backup and rebuilt the latest records. Now the file is way too large, too many users and cannot be done in this manner. I have replaced the latest error record and just want to delete the damaged record. I get an error message "The search key was not found in any record". The only entry in the record is 0(actually a sq) 0 (again sq)RVC. How can I just delete the record? Thanks,Steve Addition: This table does not have a primary key. Is it needed? > I am running Access 2000 on a Citrix network with multi-users. If 2 users > attempt to enter a new record at the same an issue may arise. In the past we [quoted text clipped - 7 lines] > just delete the record? > Thanks,Steve >Addition: This table does not have a primary key. >Is it needed? All tables should have a primary key. An autonumber field will be just fine. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm >I have replaced the latest error record and just want to delete the damaged >record. I get an error message "The search key was not found in any record". >The only entry in the record is 0(actually a sq) 0 (again sq)RVC. How can I >just delete the record? This is more of a sign of corruption than anything else. First thing I'd do is check that everyone is running the same version of Jet. Second thing I'd do is run down the lengthy list of things that can cause corruption. 1) What I've done is use the various API calls available and am checking the version number and date/time of a crucial dll, msjetxx.dll, to ensure it matches what I have on my system. See the Verify Appropriate Jet Service Pack is installed page at my website for more details including sample code: www.granite.ab.ca\access\verifyjetsp.htm 2) For more information on corruption including possible causes, determining the offending PC, retrieving your data, links, official MS KB articles and a list of vendors who state they can fix corruption see the Microsoft Access Corruption FAQ at http://www.granite.ab.ca/access/corruptmdbs.htm Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm |
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.