Error in a Table

  • Thread starter Thread starter Greg Rodgers
  • Start date Start date
G

Greg Rodgers

Hi....

It seems that during a shutdown last night that an error
occurred in the access table.

The " #error" does not appear to hurt the function of any
of the forms, however, its is affecting the reports.

I have tried many different ways to get rid of this line,
but when I open the table I get a box that pops open that
says "Invalid Argument".

Do any of you know of an easy way to eliminate this line?

I have tried copying the table..(it freezes the database),
deleting the line..("invaild argument") pops up, and I
have looked at all of the forms and there is nothing that
suggests it has caused this problem.

I think it is related to a server issue.

Help me please!!!

Greg Rodgers
 
Go to your backup if you have one. If not, make a backup now so you can
play in the backup without further damaging the original.

Compact and repair if you can. If you can't or that doesn't fix the problem
(it probably won't) then create a "structure only" ropy of the problem table
and copy all of the records preceding the problem record. Copy all of the
records subsequent to the failing record. Try to identify what the problem
record should contain so that remedial action can be taken. Delete the
original version of the table. Give the new table the name of the original.
Test your application, particularly hitting on the records before and after
the problem one.

HTH
 
Back
Top