Cannot run Access query or report as "record is deleted" error ap.

J

JClary

I was entering records in a form. I went to the next record. I went back to
the previous record and all of the fields contained "#Deleted. I tried to
remove the record in the table, which Access allowed. When I went back into
the table the same record was there. It had not been deleted. I cannot run
a query or report based on the table because of this record. What can I do?
 
6

'69 Camaro

Hi.

Is the #Deleted record in a linked table in an Oracle or SQL Server
database? If not, does the table where the #Deleted record is stored have
at least one memo field where a form is bound to this field?

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


JClary said:
I was entering records in a form. I went to the next record. I went back to
the previous record and all of the fields contained "#Deleted. I tried to
remove the record in the table, which Access allowed. When I went back into
the table the same record was there. It had not been deleted. I cannot run
a query or report based on the table because of this record. What can I
Click to expand...
do?
 
Top