Hi Jeff,
It sounds like you may have some corruption developing. Here is a KB article
that you should read:
http://support.microsoft.com/?id=308630
Try creating a brand new database, and importing all objects (tables,
queries, forms, reports, macros, DAP's and modules) from the suspect database
into the new database. When importing tables, make sure to check the options
to import Relationships, Menus and Toolbars, and Import/Export Specs. Set the
startup options and references to match the source DB. Compile the code in
the new DB. Then repeat your test to see if you can import the table. If you
still cannot import the table, then you can likely use VBA code to recover
records from this table, since you stated that you can read and write records
to it okay.
Tom
____________________________________
:
i am attempting to import a table and i receive the error message "record is
deleted". i have tried a compact and repair but that hasn't worked. the
table itself is fine, i can read/write to it, i just can't import. any ideas
on this one?
