Error 3001

[Leo Luyendijk]

Please help

Getting error 3001 (Invalid Argument) when writing to
Access 2003 Table via VB (DAO). Error triggers
inconsistently ie. it works sometimes - no change in data
being written.

Anyone seen this

Thanks

Leo

 

[Allen Browne]

Possible leads:
- ACC2000: "Invalid Argument" Error When You Export Data to a Text File
at:
http://support.microsoft.com/?id=263946

- ACC2000: "Invalid Argument" When You Import, Copy, or Append Data to a
Table
at:
http://support.microsoft.com/?id=302495

You may receive an "Invalid argument" error message when you run an append
query in a large Access database file
at:
http://support.microsoft.com/?id=835416

Jet 8 also address this issue:
http://support.microsoft.com/?id=829558

 

[Leo]

Thanks Allen. Compacting the db helped

-----Original Message-----
Possible leads:
- ACC2000: "Invalid Argument" Error When You Export Data to a Text File
at:
http://support.microsoft.com/?id=263946

- ACC2000: "Invalid Argument" When You Import, Copy, or Append Data to a
Table
at:
http://support.microsoft.com/?id=302495

You may receive an "Invalid argument" error message when you run an append
query in a large Access database file
at:
http://support.microsoft.com/?id=835416

Jet 8 also address this issue:
http://support.microsoft.com/?id=829558

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.