Deleted bad line, can't back up database

[Guest]

I was away from the office for a few weeks, and in the interim something
happened with our communal database. There was one line on our "logsheet"
(jobs to-do list) that had some weird corruption in it, so it would crash the
database when you scrolled across to look at the last few items in the line.

So I opened up the design for the logsheet, saved a new version (New
Logsheet), copied all the "good" lines over from Logsheet to New Logsheet,
then deleted Logsheet.

The database works fine now.

EXCEPT when I try to back it up, it crashes. Ditto with compact and repair.
The Jetcomp utility reports an error when I try that method.

We can keep limping along as we are, but the knowledge that there's some
"rotten" data somewhere in there is creeping me out.

Suggestions?

 

[tina]

recommend you immediately stop entering new data into any database that you
cannot successfully compact and repair; the database is corrupted in some
way. you could try creating a new, blank database. import all the objects,
except the table that you believe is causing the problem. see if you can
successfully compact and repair. if it works, so far so good.

next, you can try several methods to get the data from that last table into
the database, attempting a compact/repair after each attempt; your goal is
to end up with a database that can be compacted and repaired successfully.

1) import the entire table.
2) link the table, and append the data in it to a new table, then delete the
link.
3) export the data from the table to a text file, then inport the text file
into a table in the new database.

hth

 

[Guest]

I will try that this evening when everyone is out of the office. Thanks!

- Matt