By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,545 Members | 832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,545 IT Pros & Developers. It's quick & easy.

How to delete a Error record?

P: n/a
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
Share this Question
Share on Google+
4 Replies

P: n/a
do a compact/repair?

Nov 13 '05 #2

P: n/a
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

P: n/a
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

P: n/a
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.