Invalid Argument

[Guest]

Here is the scenario...

I have 5 local tables in Access that are growing on a weekly basis as follows:

Millions of records are being pulled manipulated and loaded from 5 linked
SQL server tables to each of these 5 local tables in question 1 to 1 through
individual Append queries.

This process has been working fine for the past six months but at this point
these five tables combined are over 2gigs which may have something to do with
my issue.

ISSUE:
Upon running the SAME append queries with no changes made to the tables in
question whatsoever I started getting an error message [Run-time error '3001'
Invalid Argument] at the end of each process. I am able to view the results
of the queries but when trying to append the records to the tables it's a no
go.

It just so happened that I also got the same error message when I tried to
Index (Duplicates OK) one of the fields in the local tables. HELP explained
something about "...number of locks per file was exceeded,...".
Unfortunately I don't know how LockFiles work in these processes to
understand the source of the problem.

Thank you in advance for your feedback.

 

[Brendan Reynolds]

2GB is the maximum size of an MDB, so if you're exceeding that then yes,
that is very probably the cause of your problems.

You could try putting each table into a separate MDB, and linking them.

 

[Guest]

Thank you. Although I had figured out the size issue I didn't have a logical
solution to fit our requirements. Your workaround turned out to be the best
approach.

Your feedback is greatly appreciated.

Arsen

2GB is the maximum size of an MDB, so if you're exceeding that then yes,
that is very probably the cause of your problems.

You could try putting each table into a separate MDB, and linking them.

--
Brendan Reynolds (MVP)

Here is the scenario...

I have 5 local tables in Access that are growing on a weekly basis as
follows:

Millions of records are being pulled manipulated and loaded from 5 linked
SQL server tables to each of these 5 local tables in question 1 to 1
through
individual Append queries.

This process has been working fine for the past six months but at this
point
these five tables combined are over 2gigs which may have something to do
with
my issue.

ISSUE:
Upon running the SAME append queries with no changes made to the tables in
question whatsoever I started getting an error message [Run-time error
'3001'
Invalid Argument] at the end of each process. I am able to view the
results
of the queries but when trying to append the records to the tables it's a
no
go.

It just so happened that I also got the same error message when I tried to
Index (Duplicates OK) one of the fields in the local tables. HELP
explained
something about "...number of locks per file was exceeded,...".
Unfortunately I don't know how LockFiles work in these processes to
understand the source of the problem.

Thank you in advance for your feedback.