Invalid Argument

[Toni]

On one table of my Database I've got a record that was
enter incorretly and/or was corupted when trying to make a
change to the data after the initail entry. I'm now
getting a "Invalid Argument" and can't get past it to try
to make a correction. I've tried deleting this one record
but it won't allow it.

I can't find anything in the HELP files.

Any suggestions?

Toni

 

[John Vinson]

On one table of my Database I've got a record that was
enter incorretly and/or was corupted when trying to make a
change to the data after the initail entry. I'm now
getting a "Invalid Argument" and can't get past it to try
to make a correction. I've tried deleting this one record
but it won't allow it.

The "Invalid Argument" error message usually means you have some
incorrect VBA code. If you can open the database, try typing Ctrl-G to
bring up the VBA window and selecting Debug... Compile <yourdatabase>.
Do you get any error messages?

It's also possible that you're looking at a Query with a function call
(with an invalid argument in it) rather than a table - is that the
case?

If neither is true, then your database may be seriously corrupt. See
Tony's excellent FAQ at

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Tony Toews]

On one table of my Database I've got a record that was
enter incorretly and/or was corupted when trying to make a
change to the data after the initail entry. I'm now
getting a "Invalid Argument" and can't get past it to try
to make a correction. I've tried deleting this one record
but it won't allow it.

So just one record is corrupt?

3001 - Invalid argument. This one typically happens when clicking on a
corrupted record within a table. Or by running a query or form against
that record. All the fields show #Error. See Damaged record(s) within
tables.
www.granite.ab.ca/access/corruptmdbretrievedata.htm#DamagedRecords

Another cause may be missing Access 2000 SR-1 if you are trying to
"import data, copy a table, or run an append query."

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm