Deleting record with Error# Error#..( 3001)

[stephenson22]

Dear Experts.

I have a commercial database with 31K records. Yesterday a record was
entered into the data with Error# in each column of data.

When the data forms attempt to navigate passed this record a message is
presented to the user for each column of data with the error

"Invalid argument (Error 3001)"

When i visit the table and attempt to delete this data I receive the same
error and the system does not remove the record.

I have tried to make a new table using a query to filter all records with
values in a column >1 (the IDs), but the program crashes and does not create
the table, also I receive the error message again when it appears the Make
table query is attempting to process the information.

Can anyone assist with a method to remove this record, or how this error was
created?

 

[Roger Carlson]

Have you tried Repairing the database? Sounds like corruption.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Tanisl]

Hi, I have the same sort of problem but the message I get is that two people
are trying to change the information at the same time, however I know that I
am the only one in access at the time any help????