Table appears blank in database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Willjurgens@gmail.com - 05 Dec 2007 19:56 GMT

I have two tables in a database that suddenly appear blank (white
screen) when I attempt to open them. I am able to export the data to
another table, however, when I rename the old table and paste the new
one in its place, it too opens blank and off goes a report to MS. Can
anyone tell me where the source of the problem might be or better yet,
how to correct it. Using the database "compact and repair" utility
does not solve the problem.

Your help would be greatly appreciated. Thanks.

Will

Reply to this Message

Stefan Hoffmann - 06 Dec 2007 09:12 GMT

hi Will,

> I have two tables in a database that suddenly appear blank (white
> screen) when I attempt to open them. I am able to export the data to
[quoted text clipped - 3 lines]
> how to correct it. Using the database "compact and repair" utility
> does not solve the problem.

Sounds like corrupted data.

I had such a case once, the only thing which worked out was a VBA method
to copy the data to a new table. Just read the data twice, the first
time from the beginning to the corrupted data and the second time form
the end to the corrupted data. Under normal circumstance you have only
lost one record.

mfG
--> stefan <--

Reply to this Message