Hi, Nicole.
I am now missing 30 records. Is
there a way to recover these records?
Are the records missing when you open your form or query, or are they
missing from the table, itself? If these records are missing from the form
or query but remain in the table, then the record source or filter may need
to be altered to ensure that these records are included in the recordset.
If these records are missing from the table, then even database recovery
services can only recover up to 5% of the records from a table in an
Microsoft Access database. If this is the case, then you'll need to restore
these records from your latest backup and investigate how the records were
deleted so that it doesn't happen again.
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.)