Invalid Argument for large import or link

[veaux]

Peeked around here but didn't really see an explanation as to the
varied "Invalid Argument" errors that appear in Access sometimes. I'm
using Access 2003 and trying to import an Access table of ~200,000
records into my DB. I've tried importing, linking, exporting the
original table to txt and importing or linking to that. Then I tried
exporting the table to it's own DB (which worked) but still cant then
import or link to the DB I'm using. I get "Invalid Argument" errors.

There's no code or anything and I've repaired and compacted all
relevant DB at least 3 times each, rebooted, shut down and restart and
nothing works. This happened to me about 2 yrs ago with importing
"large" files and seems like an Access bug, but is there anything that
can be done??? I've wasted a day already trying to get this data in!!

Thanks,
Darrell

[Kc-Mass]

Try setting up an append query that only transfers maybe a fourth of your
import data at a time

Kevin C
<ve***@aol.comw rote in message
news:11******** *************@b 28g2000cwb.goog legroups.com...

Peeked around here but didn't really see an explanation as to the
varied "Invalid Argument" errors that appear in Access sometimes. I'm
using Access 2003 and trying to import an Access table of ~200,000
records into my DB. I've tried importing, linking, exporting the
original table to txt and importing or linking to that. Then I tried
exporting the table to it's own DB (which worked) but still cant then
import or link to the DB I'm using. I get "Invalid Argument" errors.

There's no code or anything and I've repaired and compacted all
relevant DB at least 3 times each, rebooted, shut down and restart and
nothing works. This happened to me about 2 yrs ago with importing
"large" files and seems like an Access bug, but is there anything that
can be done??? I've wasted a day already trying to get this data in!!

Thanks,
Darrell

[veaux]

Didn't really work, still got error. Guess my question is that
shouldn't Access be able to handle a table of 500,000 records? This
must be a known issue so are there any system settings, etc. that
should be adjusted to overcome this? Is Microsoft just trying to get
you to move to SQL when you get to a certain point? (I only have 1-2
tables of this size and am not a DBA so not really interested in moving
to SQL, though I do have a MYSQL server and might have to look at that
if I can't get around this stuff.)

Kc-Mass wrote:

Try setting up an append query that only transfers maybe a fourth of your
import data at a time

Kevin C
<ve***@aol.comw rote in message
news:11******** *************@b 28g2000cwb.goog legroups.com...

Peeked around here but didn't really see an explanation as to the
varied "Invalid Argument" errors that appear in Access sometimes. I'm
using Access 2003 and trying to import an Access table of ~200,000
records into my DB. I've tried importing, linking, exporting the
original table to txt and importing or linking to that. Then I tried
exporting the table to it's own DB (which worked) but still cant then
import or link to the DB I'm using. I get "Invalid Argument" errors.

There's no code or anything and I've repaired and compacted all
relevant DB at least 3 times each, rebooted, shut down and restart and
nothing works. This happened to me about 2 yrs ago with importing
"large" files and seems like an Access bug, but is there anything that
can be done??? I've wasted a day already trying to get this data in!!

Thanks,
Darrell