Table empty!

[Guest]

Hi - I've just had the most bizarre thing happen at a client. They were
getting an error that said "no current record" when entering the database and
when trying to add time records to the time records table. When I checked
the time records table, it was completely empty. It should have had about
8000 records in it. In preparation for restoring from a backup, I made a
copy of the database. I went into the copy to see what else I might see and
when I opened the time records table, all the records were there. To
summarize, original db - no records in the table. Copy of db - all records
in the table. Only change I made was to make the copy and to kill the
autoexec which ran a number of queries, none of which affect the time records
table. Any thoughts???

 

[ChrisM]

Hi - I've just had the most bizarre thing happen at a client. They were
getting an error that said "no current record" when entering the database
and
when trying to add time records to the time records table. When I checked
the time records table, it was completely empty. It should have had about
8000 records in it. In preparation for restoring from a backup, I made a
copy of the database. I went into the copy to see what else I might see
and
when I opened the time records table, all the records were there. To
summarize, original db - no records in the table. Copy of db - all
records
in the table. Only change I made was to make the copy and to kill the
autoexec which ran a number of queries, none of which affect the time
records
table. Any thoughts???

Weird!!

Just some thoughts, imagine you have already covered these, but just in
case...

I guess the records MUST have been there in the original database somehow...
When you go back to the original DB, are the records still missing? How
about if you do a 'Compact and Repair'

Are you QUITE sure the autoexec'd queries don't affect the TimeRecords Table
(even if indirectly, through inter-table relationships or somthing...??)

When you were viewing the TimeRecords Table, and it appeared empty, you were
viewing the table date directly, and not through a query?

Did you make sure that there was not filter data applied to the table when
you were viewing it?

Cheers,

Chris.

 

[Guest]

Hi Chris -
I was looking directly at the table, no filters, nothing in the autoexec to
affect it. The records showed in the copy right away. I did run Compact and
Repair on both, and now they do show in the original database. I'm going to
use the copy going forward, though! Thanks for your thoughts.