469,935 Members | 1,924 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,935 developers. It's quick & easy.

How to delete a Error record?

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!

Nov 13 '05 #1
4 6497
do a compact/repair?

Nov 13 '05 #2
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
Nov 13 '05 #3
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

Nov 13 '05 #4
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!


Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by Philip Boonzaaier | last post: by
8 posts views Thread by Steve | last post: by
4 posts views Thread by Susan Bricker | last post: by
3 posts views Thread by John Rivers | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.