Resolving the – Invalid argument – error message in Access

Let’s consider a real life scenario wherein when you try to run an append query or import data in a large MS Access database file, you get to face the following error message:

“Invalid argument”

Now let’s try to understand the root cause behind the occurrence of the aforementioned error message.

The primary reason behind the occurrence of the aforementioned error message is that the Access database file nears 2 GB in size.

Now that we have come to know about the cause behind the occurrence of the aforementioned error message, let’s focus on the resolution part.

In order to resolve the aforementioned error message, you must try to reduce the Access database file size.

You can reduce the size of the Access database file in the below-mentioned two ways;

Method 1: Use the Compact and Repair utility to reduce the size of Access database file.

Method 2: Split the Access database file.

Let’s first of all see as to how using the Compact and Repair utility, you can reduce the size of the Access database file.

1. Start MS Access.

2. Click Tools -> Database Utilities -> Compact and Repair Database.

3. Select the Access database file which you want to compact in the “Database to compact from” dialog box.

4. Enter a name for the compacted database in the “Compact Database Info” dialog box.

5. Click the Save button.

By performing the aforementioned steps, the Access database file would be compacted and its size reduced.

The second method is to split the Access database file.

1. Start MS Access.

2. Open the problematic Access database file.

3. Click Tools -> Database Utilities -> Database Splitter.

4. In the Database Splitter dialog box, click Split Database.

5. Enter a new name for the split Access file.

6. Click the Split button.

7. Click the Ok button.

By performing the aforementioned steps, the Access database file would be split and its size would be reduced.

However, if the aforementioned issue is still not resolved, we would suggest you to take help of a professional Access repair tool to resolve the issue.

Numerous repair Access database tools are available in the market. Be careful enough to decide upon an appropriate tool.

Kernel for Access is a professional and efficient repair Access database tool that is specifically devised to repair the damaged and corrupt Access database files in an easy and effective manner.

Comments are closed.