You may receive an "Invalid argument" error message when you run an append query, run a make-table query, or import data in a large Access database file (835416)
The information in this article applies to:
- Microsoft Office Access 2003
- Microsoft Access 2002
- Microsoft Access 2000
This article applies only to a Microsoft Access database (.mdb).
Moderate: Requires basic macro, coding, and interoperability
skills.
SYMPTOMSWhen you try to run an append query, to run a make-table query, or to import data in a large Microsoft Access
database file, you may receive the following error message: Invalid argument. This problem occurs when the size of
the Access database file approaches the 2 gigabyte (GB) size
limitation. WORKAROUNDTo work around this problem, you must reduce the size of
your Access database file. To do this, use one of the following methods: Compact your Access database fileYou can reduce the size of your Access database file by running
the Compact and Repair Database utility. To do this, follow these
steps. Note If you want to compact a shared Access database file that is
located on a server or in a shared folder, you must make sure that no other
user on the network has opened the Access database file. You must have
exclusive use of the Access database file.
- Start Access.
- On the Tools menu, point to
Database Utilities, and then click Compact and Repair
Database.
- In the Database to Compact From dialog
box, select the Access file that you want to compact, and then click
Compact.
- In the Compact Database Into dialog box,
select the name for the compacted Access database file.
- Click Save.
Split your Access database fileYou can also work around this problem by dividing your Access
database file into multiple Access database files. If your Access database file
contains modules with a lot of code, you can consider using library databases
to store the code. You can also consider using the Database Splitter Wizard to
divide your single Access database file into two Access database files. One of
the Access database files contains all the tables. The other Access database
file contains the remaining database objects, such as forms and reports. To do
this, follow these steps:
- Start Access.
- Open the problem Access database file.
- On the Tools menu, point to
Database utilities in the Database window, and then click
Database Splitter.
- In the Database Splitter dialog box, click
Split Database.
- In the Create Back-end Database dialog
box, type a name for the back-end Access database file in the File
name box, and then click Split.
- Click OK.
REFERENCES For
additional information, click the following article numbers to view the
articles in the Microsoft Knowledge Base: 304932
How to manually split a Microsoft Access database
302495 ACC2000: "Invalid Argument" when you import, copy, or append data to a table
209912 ACC2000: How to reference classes that exist in multiple libraries
288631 Defragment and compact database to improve performance
Modification Type: | Major | Last Reviewed: | 2/8/2005 |
---|
Keywords: | kbQuery kbMemory kbDatabase kberrmsg kbprb KB835416 kbAudDeveloper |
---|
|