invalid argument

[Duane]

When I run a macro with approx 20 steps at night it fails at different steps
with Invalid Arguments as an error message. When I try to open the query it
fails and it gives the Invalid Argument message again. I then re-boot and run
a compact and repair on the database, restart the macro at the step that
failed and it runs fine to the finish. The database is approx 3 gig in size
running on an IBM 2.6G P4 processor with 2 gig ram, and I have 65 gig free
space on the hard drive.

 

[Brendan Reynolds]

The size of the database is three GB? According to the documentation, the
maximum size of an Access MDB is two GB.

 

[Duane]

It is almost 3 gig when it fails after compacting it goes to approx 1.9 gig

 

[Tom Wickerath]

Hi Duane,

I think what Brendan is trying to tell you is that *if* your database is a
JET database (ie. .mdb file), then you should expect it to fail if you do
anything that might cause it to exceed (or even come perilously close to) the
2 GB limit. If it is still 1.9 GB after compacting, then it's way past time
to look into either moving the data to a different database, or trying to
figure out if there is something unnecessary that is causing it to be that
large.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Brendan Reynolds]

As Tom says, if it is 1.9 GB after compacting, it is close to the limit and
any intensive processing is likely to push it over.
You could still use your Access application (forms, reports, macros, etc)
but you need to move the tables to a database with greater capacity, such as
SQL Server. (A possible alternative would be to separate your tables into
different linked MDBs, but that may not help if all or most of the data is
in one big table).