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 deleted record in table.
There is an error in one of the records within a table, as a result none of
the queries can be run. If I select this record and choose delete, it goes through the process of displaying one record will be deleted. If I open the table again the record is there again. Any ideas of what is happening and if there is a way of deleting it this one record. Many thanks for any help and advice. |
#2
|
|||
|
|||
Error in deleted record in table.
See the 3rd symptom in this article on recovering from corruption:
http://allenbrowne.com/ser-47.html#RowsShowDeleted -- 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. "CEL504" wrote in message ... There is an error in one of the records within a table, as a result none of the queries can be run. If I select this record and choose delete, it goes through the process of displaying one record will be deleted. If I open the table again the record is there again. Any ideas of what is happening and if there is a way of deleting it this one record. Many thanks for any help and advice. |
#3
|
|||
|
|||
Error in deleted record in table.
Many thanks for that and I manged to sort it out as a result.
Cel504 "Allen Browne" wrote: See the 3rd symptom in this article on recovering from corruption: http://allenbrowne.com/ser-47.html#RowsShowDeleted -- 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. "CEL504" wrote in message ... There is an error in one of the records within a table, as a result none of the queries can be run. If I select this record and choose delete, it goes through the process of displaying one record will be deleted. If I open the table again the record is there again. Any ideas of what is happening and if there is a way of deleting it this one record. Many thanks for any help and advice. |
Thread Tools | |
Display Modes | |
|
|