Recreate a corrupt table

[Sammy]

I have been getting errors in my database lately, and
finding wierd things like duplicate records being created
automatically, and records deleting themselves. I would
like to create a fresh table. What's the best way to
create a new fresh table from my old one, preserving all
the data and field properties? Will a simple copy be
clean or should I export the data and import it into the
new table? Could something else besides my table be
causing these types of errors in my database?
Thanks.

 

[Ken Snell]

Iimport the table (for that matter, all the objects) into a new database.
That is a common way to fix corruptions. If you think it's just the table
and not the rest of the database, you then could import the new table from
the new database back into the old one.

See Tony Toews' site for info on corruptions:
http://www.granite.ab.ca/access/corruptmdbs.htm