Accessing database information when the table has no entries

[Guest]

I have a database file, it is 28 mb in size, yet when i open the database
there is only one table, and in the table there are no entries. This is a
database we use for our business, and i need to get to the information that
is in the database yet not visible in the table. The table is deleted every
few days from the main program we use. the data is there it's just not
visible. Does anyone have a clue as to what i can do to access the
information that has been deleted?

 

[Guest]

Bad news I'm afraid.

When you delete a record or object, such as a table, in Access it is not
deleted immediately but is instead flagged as deleted and hidden. However, as
far as I am aware, there is no way of seeing these deleted items and
'unflagging' them in Access (unlike FoxPro - perhaps a feature for future
versions <grin>).

When you run compact & repair everything flagged as deleted goes and the
space is recovered - your file size is likely to reduce considerably if you
were to do this.

In future if you just want to hide old records, rather than physically
deleting them as you have been doing, add an lDeleted Yes/No field to the
table. You can use this as a filter to show/hide 'deleted' records.