"Invalid Argument" Error Message

G

Guest

I have created a database which contains very large
tables. The database itself is over 2Gb. I have tried
compacting the database, however, I get a "Invalid
Argument" message. I get the same message when I run a
query that I have created within the database. I would
like to add more tables into the database and more fields
to the query, but, my concern is that my database is too
large. Any suggestions? Thanks in advance!
 
B

Brendan Reynolds

Yes, the database is too large. 2GB is the limit for Access 2000 and later.
You could try splitting the tables between multiple MDBs, but when you have
that much data to work with, and you appear to be expecting it to grow
further, it is probably time to start looking at a heavy-duty server
database such as SQL Server.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Top