How to delete a Error record?

[barbara_dave]

Hi all,

We have a Access database used by multiple user. For some reason the
database get a "Error" record. When doing search or record pointer
point to this record, we get run time error "Invalid Argument". I try
to delete that record, but it does not allow me to do that, always get
"Invalid Argument" message. but if I delete a good record, it works.
How can I delete that "Error" record in table?
Please give me some suggestions!
Thanks a lot!

[pietlinden]

do a compact/repair?

[Br]

pi********@hotmail.com wrote:

do a compact/repair?

I didn't see the original post...

Are you talking about error tables created after a failed import?

I simply cycled through the table defs and deleted any that started with
"Import error*" (or whatever the table names start with).
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response

[Barry]

I had this problem once. I had a blank record and The Primary key had
a record that was a duplicate even though this should never happen. I
guess it was a shut down and caused a corrupted the table problem. I
deleted the blank record. Then I removed the primary key. I created a
query to find the dupe. I deleted the dupe record and put back the
primary key and it was OK. The message "Invalid Argument" doesn't seem
correct but I won't forget it since it shut down a customers entire
operation.

Good luck

[Tom van Stiphout]

On 24 May 2005 10:53:33 -0700, ba**********@yahoo.com wrote:

Create a new table with same structure as the current one.
Import all data before the bad record: ... where PrimaryKeyField <=
1234.
Import all data after the bad record: ... where PrimaryKeyField >=
2345.
Rename the tables.

-Tom.

Hi all,

We have a Access database used by multiple user. For some reason the
database get a "Error" record. When doing search or record pointer
point to this record, we get run time error "Invalid Argument". I try
to delete that record, but it does not allow me to do that, always get
"Invalid Argument" message. but if I delete a good record, it works.
How can I delete that "Error" record in table?
Please give me some suggestions!
Thanks a lot!