invalid argument on append query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I've been running this Access 2000 code for a few years with no problems. Now when I run it it gets stuck on a piece of code that runs an append query and I get the message 'invalid argument'. I know this is bogus and I do have SR-1 installed
After that the code gets stuck in a different place with the same error - it did not get stuck in this place the first time so again something weird is going on. Can someone tell me the cause and solution for this? I have tried changing the query around but nothing work

The code is

DoCmd.RunSQL "insert into tblbillingsreporttemp select * from tblbillingsreport

Thanks
 
In the other group where you posted this, you will find a reply regarding
the service packs that will probably solve your issue.

If not, try:
dbEngine(0)(0).Execute "INSERT INTO ...", dbFailOnError
and Access should give you more info about the error.

Presumably you have already verified that the field structure of the two
tables is identical.

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

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

ac said:
I've been running this Access 2000 code for a few years with no problems.
Click to expand...
Now when I run it it gets stuck on a piece of code that runs an append query
and I get the message 'invalid argument'. I know this is bogus and I do have
SR-1 installed.
After that the code gets stuck in a different place with the same error -
Click to expand...
it did not get stuck in this place the first time so again something weird
is going on. Can someone tell me the cause and solution for this? I have
tried changing the query around but nothing works
 
Okay,

I have installed the SPs and the problem persists. The error message is: Runtime error '3001' invalid argumen

That is all the info Access provides. The code is a simple append query

DBEngine(0)(0).Execute "insert into tblbillingsreporttemp select * from tblbillingsreport", dbFailOnErro

After this bug occurs I get the same error message even when trying to re-link tables so it doesn't even seem related to the append query anymore. I would really appreciate some help

Thanks
 
The SQL statement is fine (assuming identical table structures), and you are
now getting confirmation that the problem is elsewhere.

You got the Jet service pack too?

Is there a network problem?

Has the server name, share name, path, filename or assigned drive letter
changed? Are you able to open both tables in the Database window?

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

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

AC said:
I have installed the SPs and the problem persists. The error message is:
Click to expand...
Runtime error '3001' invalid argument
That is all the info Access provides. The code is a simple append query:

DBEngine(0)(0).Execute "insert into tblbillingsreporttemp select * from
Click to expand...
tblbillingsreport", dbFailOnError
After this bug occurs I get the same error message even when trying to
Click to expand...
re-link tables so it doesn't even seem related to the append query anymore.
I would really appreciate some help.
 
Yes. both SPs were installed. There is no network involved. None of the information has changed and yes I am able to open both tables in the db window. Are there any new bugs recenlty discovered that give this message? THanks again
 
AC, have just done some more research on this.
Does your table have a field of type Number, and in the lower pane the Field
Size is "Decimal"?

If so, try changing the field type to Double.

This article indicates that there is a problem with exporting the Decimal
type:
ACC2000: "Invalid Argument" Error When You Export Data to a Text File
at:
http://support.microsoft.com/default.aspx?id=263946

This article also cites a problem, but this one was supposed to be fixed in
a service pack:
ACC2000: "Invalid Argument" When You Import, Copy, or Append Data to a Table
at
http://support.microsoft.com/default.aspx?id=302495

Please let us know if this is the issue.

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

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

ac said:
Yes. both SPs were installed. There is no network involved. None of the
Click to expand...
information has changed and yes I am able to open both tables in the db
window. Are there any new bugs recenlty discovered that give this message?
THanks again
 
I have the same problem since upgrading to Win XP
I had an acc97 db with linked tables using odbc driver to an external data base
That was on win 98 system and everything was ok
I had tryed the same with acc97-Win2K, acc97-WinXP, acc2000-Win2K and and everything was still fine
Now i have acc2000-WinXP
When trying to make a new linked table, i get the tables list from the connection with the odbc driver
and right after that i get an "invalid argument" error message
I have installed SR-1 (thank you fro the links) but there still the same problem
It seems that the only compination (as far as i know) is acc2000-WinXP
Is there any Win API call that changed to Win XP and so there this problem
 
Thomas, one if the items the JET 4 Service Pack 8 addresses is:
Invalid argument error message occurred when you tried to create
a linked table by using DAO code after the installation of Jet 4.0 SP7.

Locate msjet40.dll (typically in windows\system32). Right-click, and choose
Version. If it is not 4.0.8015.0, download Jet 4 SP8. Details:
http://support.microsoft.com/?id=829558

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

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

Thomas Apostolou said:
I have the same problem since upgrading to Win XP.
I had an acc97 db with linked tables using odbc driver to an external data base.
That was on win 98 system and everything was ok.
I had tryed the same with acc97-Win2K, acc97-WinXP, acc2000-Win2K and and everything was still fine.
Now i have acc2000-WinXP.
When trying to make a new linked table, i get the tables list from the
Click to expand...
connection with the odbc driver
 
Well Allen
thank you for replying
The case is that i get the same error ("invalid argument") both from the code AND the user interface
I have already installed JET 4 Service Pack 8 and the dll you reference is truelly the one i have
As i said before, the only combination that cases the problem is Access 2000 with WinXP
I keep on looking the internet community and if i find something i'll post it
If you do find a solution please post it
Regards
Thomas Apostolou
 
Back
Top