Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Manually importing table into a db gives "invalid argument" error

Status
Not open for further replies.

VBAguy22

IS-IT--Management
Aug 5, 2003
180
CA
Hi
I enherited an Access 2000 format db, that was used to run some simple queries on a dBase 5 table. So the process is basically to manually import the dBase table, rename it, and the queries pick it up.

I tried importing a dBase table using Get External Data, Import -- but it gave me "invalid argument" error.

I tried importing the same table into a brand new database and it worked fine.

Any ideas why it wouldn't work with the db my ex co-worker wrote?
 
The database file may be too large. Access has a restriction of 2 GB for a database, and if any process causes the file to exceed that limit, you'll get the "invalid argument" error. You'll either need to export the objects to a brand new database or try compacting the file.

This has happened to me a few times, including once last week.

Rob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top