Invalid Argument error

[Jeremy Cote]

I am working with an existing Database that was created
using Access 2002. Everything was working wonderfully the last time we
used it which was 2 months ago. The users started to complain that the
system would not let them in. After investigating further, I discovered
that the problem was that one of the table’s which contain several
thousand entries will not open. I am receiving the error “Invalid
Argument” when trying to open it in datasheet view (below is what the
Help file said about this error).

I’m not trying to do anything fancy. I just want to open
the table up in datasheet view and view the data. I am not doing this
through any form or any other method. I open the database in access
click on tables then double click on the table in question and I get
that error. Every other table in the database has no problem opening up
using this method and at on of the other locations the same database is
in use with different data. When I try this on that database I have no
trouble viewing the data. What could possibly be going on here? Could
it be a corrupt database?


Invalid argument. (Error 3001)


You tried to perform an operation that involves a routine in a DLL
<JavaScript:hhobj_1.Click()> , and one of the arguments
<JavaScript:hhobj_2.Click()> to the routine is invalid. Check your
entry to make sure you have specified the correct arguments, and then
try the operation again.

This error also occurs when you attempt to use mutually exclusive
constants in an argument to a method, such as specifying both
dbConsistent and dbInconsistent in the options argument to the
OpenRecordset method.

 

[Jeff Conrad]

in message:

I am working with an existing Database that was created
using Access 2002. Everything was working wonderfully the last time we
used it which was 2 months ago. The users started to complain that the
system would not let them in. After investigating further, I discovered
that the problem was that one of the table’s which contain several
thousand entries will not open. I am receiving the error “Invalid
Argument” when trying to open it in datasheet view (below is what the
Help file said about this error).

I’m not trying to do anything fancy. I just want to open
the table up in datasheet view and view the data. I am not doing this
through any form or any other method. I open the database in access
click on tables then double click on the table in question and I get
that error. Every other table in the database has no problem opening up
using this method and at on of the other locations the same database is
in use with different data. When I try this on that database I have no
trouble viewing the data. What could possibly be going on here? Could
it be a corrupt database?


Invalid argument. (Error 3001)


You tried to perform an operation that involves a routine in a DLL
<JavaScript:hhobj_1.Click()> , and one of the arguments
<JavaScript:hhobj_2.Click()> to the routine is invalid. Check your
entry to make sure you have specified the correct arguments, and then
try the operation again.

This error also occurs when you attempt to use mutually exclusive
constants in an argument to a method, such as specifying both
dbConsistent and dbInconsistent in the options argument to the
OpenRecordset method.

Sure sounds like some kind of corruption to me.
Make two backups of this file immediately and review the following
corruption information:

http://allenbrowne.com.au/ser-47.html

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

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Whittle,Jerry
(See Fix Corrupt Access Database v3.9 Document)

http://www.e-tech.ca/001-AccessFAQ.asp

http://www.everythingaccess.com/tutorials.asp?ID=0

ACC2000: How to Recover Data from a Corrupted Table by Using the DAO Method
http://support.microsoft.com/?id=815280

ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/?id=306204

ACC2000: How to Troubleshoot and Repair a Damaged Jet 4.0 Database
http://support.microsoft.com/?id=209137

ACC2000: How to Recover Data from a Damaged (Corrupted) Table
http://support.microsoft.com/?id=247771

ACC2000: How to Use MS Query to Recover Data from a Damaged Jet 4.0 Database
http://support.microsoft.com/?id=304561

Jetcomp utility available at:
http://support.microsoft.com/?id=273956

Good luck,