Whippet wrote:
I was adding data to a Base file. I pressed the Refresh button in the
toolbar and all the data disappeared. I renamed the file then
restored it from a backup copy. That file also shows no rows of data.
Both files are the same size they were before the refresh button was
used. If I add data the row number is one more than it was before the
problem started. File size is the same as it was before the problem
started.
Why am I unable to see the data in the backup file? How can I get the
data to display again?
I have no idea really.
Maybe you inadvertently set a filter, one that is filtering out all
records. Filters in a dataview (meaning the window you get if you double
click a table in the Tables section) are persistent.
( Open the table dataview and look at the toolbar, is the "Remove
filter/sort" button active..if so click it)
Maybe you deleted all your data, instead of refresh. (In which case the
data is gone)
The fact that the AUTO_INCREMENT generator is creating the correct
number, per your description, is of no consequence here. That number is
not a count of records + 1, it started at 0, goes up by one each time
it's used - create 10 records, delete all 10 and create a new on..the
new records gets a value of 10. (remember we started at 0)
Why your backup copy would be identical...hmm, no reason that I can
think of..are you sure you opened the backup?
Drew
ps - if all that makes no sense and the data is not particularly
sensitive I could take a look at the file for you
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
