Error message "Invalid Argument"

[Guest]

Hi,

I am relatively new to Access 2003...

I have imported a table with more than 2million records into Access...and
when I create a query based on this table, it gave me the Erro message as
"Invalid Argument" and I don't know where is wrong with my table as the data
in the table seems correct...

Any idea how to fix this?

Thanks in advance for your help!

 

[Guest]

Hi,

Just to further elaborate the problem I encountered...

When I run the Query (i.e. I joined the table with 2 million record and
another small table), it took forever to run the Query and seemed everything
was frozon on the screen...then if I try to make changes to the format of
some fields and Save it in the table (with 2 million records) and it returned
the Error message as "Invalid Argument"...

Thanks...

 

[OfficeDev18 via AccessMonster.com]

Even in Access 2003, the max size of an Access database is still severely
limited. In A97, it was only 1 gig max. In 2003, I think it's 2 gig. With 2
million records in the new table, it very possibly made the size of your
database too large to handle. That might be the explanation of your error
message.

Try two things. First of all, click on Tools-->Database Utilities-->Compact
and Repair Database. Compacting might relieve the problem. Now try your query
again. If it doesn't work (I doubt it will work, but it's worth a try!) go to
plan b. Export the new 2-million record table to a new blank database. Re-
compact the current database. In your current database, link to the table,
and try your query again. Because the table is not there, only linked, you
get the benefits of the table without the liability of its size.

HTH

Hi,

Just to further elaborate the problem I encountered...

When I run the Query (i.e. I joined the table with 2 million record and
another small table), it took forever to run the Query and seemed everything
was frozon on the screen...then if I try to make changes to the format of
some fields and Save it in the table (with 2 million records) and it returned
the Error message as "Invalid Argument"...

Thanks...

Hi,

[quoted text clipped - 8 lines]

Thanks in advance for your help!

 

[Guest]

Thank you...I will try Plan B as Plan A as you predicted didn't work...

Even in Access 2003, the max size of an Access database is still severely
limited. In A97, it was only 1 gig max. In 2003, I think it's 2 gig. With 2
million records in the new table, it very possibly made the size of your
database too large to handle. That might be the explanation of your error
message.

Try two things. First of all, click on Tools-->Database Utilities-->Compact
and Repair Database. Compacting might relieve the problem. Now try your query
again. If it doesn't work (I doubt it will work, but it's worth a try!) go to
plan b. Export the new 2-million record table to a new blank database. Re-
compact the current database. In your current database, link to the table,
and try your query again. Because the table is not there, only linked, you
get the benefits of the table without the liability of its size.

HTH

Hi,

Just to further elaborate the problem I encountered...

When I run the Query (i.e. I joined the table with 2 million record and
another small table), it took forever to run the Query and seemed everything
was frozon on the screen...then if I try to make changes to the format of
some fields and Save it in the table (with 2 million records) and it returned
the Error message as "Invalid Argument"...

Thanks...

Hi,

[quoted text clipped - 8 lines]

Thanks in advance for your help!

 

[OfficeDev18 via AccessMonster.com]

Uh-oh, I forgot a detail. After exporting the table to a new database, make
sure to delete it from the current database before re-compacting.

Oops, sorry.

Thank you...I will try Plan B as Plan A as you predicted didn't work...

Even in Access 2003, the max size of an Access database is still severely
limited. In A97, it was only 1 gig max. In 2003, I think it's 2 gig. With 2

[quoted text clipped - 29 lines]