Compact & Repair alters query results

[CathWren]

I did a C&R on my Access 2003 db on Friday (I always save the old version
with a new name). Now a query that runs a report is not catching all the
data. I've compared the query from the non-compacted db to the query now and
they appear identical but the outcome looks like a parameter was assigned to
ignore certain data. The data is in the table correctly.

Any idea what could have happened and how I can fix it? I don't want to
enter any more new data until I know if something was damaged during the
compacting process.

 

[John W. Vinson]

I did a C&R on my Access 2003 db on Friday (I always save the old version
with a new name). Now a query that runs a report is not catching all the
data. I've compared the query from the non-compacted db to the query now and
they appear identical but the outcome looks like a parameter was assigned to
ignore certain data. The data is in the table correctly.

Any idea what could have happened and how I can fix it? I don't want to
enter any more new data until I know if something was damaged during the
compacting process.

Sorry for being so long in responding. It's possible that you have a damaged
index - this might have been damaged before, or even damaged BY the Compact.

Try making a backup of your database (you DO have routine backups, right...!?
Make an additional one, don't overwrite your current backup); open this table
in design view and delete any indexes on the field that you're searching for
the purposes of this report. Compact the database; open the table in design
again and re-add the index. Compact once more. Does the query now return the
correct records?