If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Invalid Argument" Error Message
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! |
#2
|
|||
|
|||
"Invalid Argument" Error Message
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. wrote in message ... 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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"invalid argument" | r person | General Discussion | 2 | July 7th, 2004 03:43 AM |
"Invalid argument" error message when trying to use a combo box | Tim | Using Forms | 5 | June 23rd, 2004 03:07 AM |
invalid argument | kathy | Running & Setting Up Queries | 1 | June 22nd, 2004 04:52 PM |
Runtime Error "3001" Invalid Argument | Gail @ Pre-Funding | General Discussion | 2 | June 9th, 2004 02:52 AM |