Tuesday, September 27, 2011

Resolve “Invalid Argument” error in MS Access

This error message is signify that user cannot open MS Access database to perform any activity because MS Access database is fail. It can happen even when anything thing goes awry with database that leads to a database inaccessible. The MS Access database get inaccessible due to most of the reasons such as access database error, virus attack, sudden system shutdown, hardware failure, software failure & many more. Error messages “Invalid arguments” comes due to access database get failed.

Find some conditions in which Invalid argument error arises: 

1. When user import, copy, or append data to a table in MS Access
2. When user try to import data in a large access database file (mdb or accdb)
3. Corrupt Records in a Microsoft Access MDB

Due to these error messages user may not be able to access database. I will explain all the conditions step by step:

1) If error occurs due to first condition then use can obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a) to resolve this error.

2) If error occurs due to second condition then user can resolve this error by splitting the Access database file.

Steps to Split Access Database:

1. Start Access Database.
2. Open the problem Access database file.
3. Go to Tools menu, point to Database utilities in the Database window, and then click Database Splitter button.
4. In the Database Splitter dialog box, click on Split Database button.
5. 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 on Split button.
6. Now Click OK button.

3) If error occurs due to third condition then it is advisable to use an inbuilt repair utility “Compact and Repair”. In some conditions “Compact and Repair” utility won't work because of its own limitation then user can use Access Database Recovery Software.

No comments:

Post a Comment