how to fix corrupted table or form?

[M. Afzal]

This Access 2000 program worked fine for many months and
all of a sudden, one of the forms open but it is blank
(nothing shows up). Another copy of the same program (some
data is different), the above form opens up but when we
try to use the drop down list that loads data from
associated table (raw source uses SELECT statement..), it
gives "invalid argument" error message.

Does any one know what's going on and how to fix it?
(Compacting and repairing didn't work).

Thank You in advance
M. Afzal

 

[M. Afzal]

I have narrowed it down to one table. I tried to copy and
paste that table (structure & data) to a new table but I
get "Invalid Argument". The table opens in datasheet view
and design view OK.
Does any one know how to fix this corrupted table?

 

[TC]

Perhaps try copy/pasting the first 20 records, then the next 20, & so on,
until you find the spot where it goes bad. Then skip & few & continue from
there. That way, you may be able to get back most of the records. Change 20
to 40, 100, "10% of the table", or whatever, depending on your table size.

HTH,
TC