Invalid Argument - Append Query

[AFSSkier]

I have a backend data base that houses tables for about 40 front end users.
I manage a frontend that updates, deletes & appends new/changed data into the
backend tables. They updated via a frondend macro to linked tables.

This week the macro crashed on one of the append queries with an error
"Invalid Argument". We have been updating the records with no problems for
about 3yrs.

The 1st thing i did was compact/repair. The 2nd, reran the macro & it
crashed again on a different append query. Running past the query that
caused the original crash. After compact/repair again, I changed each of the
append queries to Make Table queries. Then I reran the macro, making tables
on my front end without crashing.

Is there something else I should try? The tables grow & shrink to a max of
200,000 records (60,000kb when exported to txt).

 

[Tom van Stiphout]

On Thu, 11 Jun 2009 14:54:01 -0700, AFSSkier

I would try following the lead of the error message: "Invalid
Argument". What does that mean? What argument could be invalid? I'm
not a macro guy but if this were a VBA routine I would outfit it with
better error handling, recording the pertinent values to a log file,
etc. to get a better idea why the error occurred, and where.
My guess: there is unexpected data causing this error.

-Tom.
Microsoft Access MVP