If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Error in field
I have one field in one of the many entries in my table that has #Error.
When I go into the field a popup comes up with "more than one person has tried to enter at the same time". I have tried to delete the record and cannot as soon as I click on the field the popup comes up. How can I delete this record ? |
#2
|
|||
|
|||
First, check if this is just a bad locking message.
Close the database. Look in the folder where this database is stored. If you see a small ldb file with the same name as your mdb database, delete it. The ldb (typically 1kb) contains locking information, and can be left over if Access does not terminate normally. If that does not solve the problem, you can get Access to recreate the table without the bad record. Follow the steps for the 3rd symptom in this article: Recovering from Corruption at: http://allenbrowne.com/ser-47.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "SG" wrote in message ... I have one field in one of the many entries in my table that has #Error. When I go into the field a popup comes up with "more than one person has tried to enter at the same time". I have tried to delete the record and cannot as soon as I click on the field the popup comes up. How can I delete this record ? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help to merge Image (Doug Robins?) | JohnB | Mailmerge | 21 | June 23rd, 2005 05:28 PM |
DCount compare table.textfield to form.text field question | RNUSZ@OKDPS | Using Forms | 1 | March 11th, 2005 02:05 AM |
LOOKUP FOR A VALUE ON A TABLE | Samora | New Users | 9 | February 22nd, 2005 01:06 PM |
New Record Update | Michelle | Using Forms | 5 | October 28th, 2004 07:59 AM |
field manipulation | Steve | Running & Setting Up Queries | 2 | May 28th, 2004 03:12 PM |