|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 4th, 2009, 10:09 PM
posted to microsoft.public.access
|
|||
|
|||
Invalid Argument
I am getting a message "Invalid Argument" when I run an append query. Both
tables have the same settings. The table I am appending to is empty. I have run this same append query many times before without an issue. Does anyone have a suggestion of how I might trouble shoot the issue? -- Matt Campbell mattc (at) saunatec [dot] com Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200905/1 
|
|
#2
May 4th, 2009, 10:48 PM
posted to microsoft.public.access
|
|||
|
|||
|
Invalid Argument
"mattc66 via AccessMonster.com" u16013@uwe a écrit dans le message de groupe de discussion : 95976dfbc2122@uwe... I am getting a message "Invalid Argument" when I run an append query. Both tables have the same settings. The table I am appending to is empty. I have run this same append query many times before without an issue. Does anyone have a suggestion of how I might trouble shoot the issue? -- Matt Campbell mattc (at) saunatec [dot] com Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200905/1 i you MEN CHALOP
|
|
#3
May 4th, 2009, 11:28 PM
posted to microsoft.public.access
|
|||
|
|||
|
Invalid Argument
Note sure what you are saying.. Seems a little foreign?
admin wrote: "mattc66 via AccessMonster.com" u16013@uwe a écrit dans le message de groupe de discussion : 95976dfbc2122@uwe... I am getting a message "Invalid Argument" when I run an append query. Both tables have the same settings. The table I am appending to is empty. I have run this same append query many times before without an issue. Does anyone have a suggestion of how I might trouble shoot the issue? -- Matt Campbell mattc (at) saunatec [dot] com Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200905/1
|
|
#4
May 5th, 2009, 03:52 AM
posted to microsoft.public.access
|
|||
|
|||
|
Invalid Argument
On Mon, 04 May 2009 21:09:50 GMT, "mattc66 via AccessMonster.com" u16013@uwe
wrote: I am getting a message "Invalid Argument" when I run an append query. Both tables have the same settings. The table I am appending to is empty. I have run this same append query many times before without an issue. Does anyone have a suggestion of how I might trouble shoot the issue? Correct the error in the query. If you would like help doing so please open it in SQL view and post it here. Also indicate what version you're using, and if you're running the query from code, post the code (Invalid Argument sounds more like a VBA or function-call error rather than a query error). -- John W. Vinson [MVP]
|
|
#5
May 5th, 2009, 06:03 AM
posted to microsoft.public.access
|
|||
|
|||
|
Invalid Argument
"mattc66 via AccessMonster.com" u16013@uwe wrote:
I am getting a message "Invalid Argument" when I run an append query. Both tables have the same settings. The table I am appending to is empty. I have run this same append query many times before without an issue. Does anyone have a suggestion of how I might trouble shoot the issue? How large is the MDB to which you are appending? If it's either 1 or 2 Gb depending on if A97 or A2000 and newer you have exceeded the file size allowed by Access/Jet. You could try compacting it but it may be too late. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ Granite Fleet Manager http://www.granitefleet.com/
|
|
#6
May 5th, 2009, 04:29 PM
posted to microsoft.public.access
|
|||
|
|||
|
Invalid Argument
You are correct - I found that it was too large. I was able to compact the
Database. It is a backend database. I will clean it up now. Thanks Tony Toews [MVP] wrote: I am getting a message "Invalid Argument" when I run an append query. Both tables have the same settings. The table I am appending to is empty. I have run this same append query many times before without an issue. Does anyone have a suggestion of how I might trouble shoot the issue? How large is the MDB to which you are appending? If it's either 1 or 2 Gb depending on if A97 or A2000 and newer you have exceeded the file size allowed by Access/Jet. You could try compacting it but it may be too late. Tony -- Matt Campbell mattc (at) saunatec [dot] com Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200905/1
|
|
#7
May 5th, 2009, 05:29 PM
posted to microsoft.public.access
|
|||
|
|||
|
Invalid Argument
On Mon, 04 May 2009 23:03:00 -0600, "Tony Toews [MVP]"
wrote: How large is the MDB to which you are appending? If it's either 1 or 2 Gb depending on if A97 or A2000 and newer you have exceeded the file size allowed by Access/Jet. Oh, good catch, Tony!! I knew that Access gave wierd and offtopic error messages when this happens but I didn't realize that this was one of them. Filed away for future reference! -- John W. Vinson [MVP]
|
|
#8
May 6th, 2009, 01:55 AM
posted to microsoft.public.access
|
|||
|
|||
|
Invalid Argument
John W. Vinson wrote:
How large is the MDB to which you are appending? If it's either 1 or 2 Gb depending on if A97 or A2000 and newer you have exceeded the file size allowed by Access/Jet. Oh, good catch, Tony!! I knew that Access gave wierd and offtopic error messages when this happens but I didn't realize that this was one of them. Filed away for future reference! Yeah, I'm trying to recall all of them myself. Or is this the only applicable message? Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ Granite Fleet Manager http://www.granitefleet.com/
|
|
#9
May 6th, 2009, 03:21 AM
posted to microsoft.public.access
|
|||
|
|||
|
Invalid Argument
John W. Vinson wrote:
How large is the MDB to which you are appending? If it's either 1 or 2 Gb depending on if A97 or A2000 and newer you have exceeded the file size allowed by Access/Jet. Oh, good catch, Tony!! I knew that Access gave wierd and offtopic error messages when this happens but I didn't realize that this was one of them. Filed away for future reference! I decided I wanted to see if MS had given this message a better name in A2007 ACCDE/ACE. Sure takes a while to get to 2 Gb. Tony -- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ Granite Fleet Manager http://www.granitefleet.com/
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
