Table Importing/Exporting - Errorr message!

[alish]

ALL, CAN YOU PLEASE GIVE ME YOUR ADVICE OR HELP ON SOLVING THE FOLLOWING ISSUE:
I am trying to Import a table from one DB to another. It gives me errorr
message: "Invalid Argument". The tables are quite big. Each has in average
300,000 recs. It cause another problem: after that message I am not able to
use that database as fas as even creating a new (blank) table. I tried to
Repair Access aplication. Still did not work. I would appreciate if you help
me with this issue. Thanks.

 

[pietlinden]

ALL, CAN YOU PLEASE GIVE ME YOUR ADVICE OR HELP ON SOLVING THE FOLLOWING ISSUE:
I am trying to Import a table from one DB to another. It gives me errorr
message: "Invalid Argument". The tables are quite big. Each has in average
300,000 recs. It cause another problem: after that message I am not able to
use that database as fas as even creating a new (blank) table. I tried to
Repair Access aplication. Still did not work. I would appreciate if you help
me with this issue.  Thanks.

try a compact/repair before exporting?
are you running out of memory when you export? (show the performance
monitor before you start the process so you can tell...) Are you
doing the export in code or through a macro? It looks like if you do
a TransferSpreadsheet in a macro, it for some reason uses an implicit
transaction, so it succeeds, whereas I have tried it in code without a
transaction and it crashes the database.

Hope that gets you started...

Pieter

 

[alish]

Pieter, I tried compacting/repairing, and also tried the way you suggested.
Still gives me "Invalid Argument" message. I did have enough memory to run
it. It does not even try, the message appears immediately. Thanks in advance
for help.