Microsoft Access 2003 Invalid Argument Error
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 13:46:47 GMT by s_wx1206 (squid/3.5.20)
6.1 - Error messages related to SQL or Access Problem: I have been using PROMODAG Reports for months without any problem and I now obtain various 'Invalid argument' error messages when attempting to import data, or run reports. What is happening? Explanation: You are using an Access database, and Microsoft set the size limitation of *.mdb files to 2 GB. Please make sure that you are not about to reach that physical limit; in that case, the database may be trying to expand beyond 2 GB due to temporary http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_winother/got-pop-up-error-invalid-argument-when-using/18d8553d-a1c1-4881-93bc-3040f7d6f729 tables created by PROMODAG Reports while it generates reports. See also: http://support.microsoft.com/kb/835416 Solution: Please attempt to delete a few data imports (if this is still possible)as follows: Go to File > Import Message Tracking Data, select your Exchange server in the right pane, then click the Server Properties button. A new window opens. In the Message Trackingtab, select the most recent http://portal.promodag.com/kb/a10182/access-database-i-receive-various-invalid-argument-error-messages-when-attempting.aspx tracking filein the list. Click the Delete button. If it works, delete the next one... Once you have cleared 5 or 6 of those data imports, go to File > Database Properties and try to compact the database. Should you need to purge more records, use the Tools > Purge Message Tracking Data option as it is explained in this article: How to manually purge data from your database. See also: Access database: What can I do if the size of my database reaches 1.9 to 2 GB?. Article ID: 10182, Created: December 22, 2009 at 6:36 PM, Modified: May 25, 2015 at 3:28 PM Add Feedback Was this article helpful? Yes No Thanks for your feedback... Share this articlePrint Help Desk Software powered by SmarterTrack 12.2 © 2003-2016 SmarterTools Inc. By using this site, you are accepting cookies to store user state and login information. Management Interface × forgotPassLbl Username Cancel Reset Email × Please log in below Username Password Remember Me Close Login × Not Logged In You must be logged in to perform this action. Ok
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login https://www.experts-exchange.com/questions/27872480/Invalid-Argument-Error-Microsoft-Access-2003-SP3.html Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Invalid Argument Error Microsoft Access 2003 SP3 Want to Advertise Here? Solved Invalid Argument Error Microsoft Access 2003 SP3 Posted on 2012-09-20 MS Access MS SQL Server 2008 Query Syntax 3 Verified Solutions 13 Comments 628 Views Last Modified: 2013-01-30 For about three days, I have been trying to make one simple, make table, query run properly. The invalid argument query seems to run right up until few seconds or so and then it errors out with the following error message: Invalid Argument Once it errors out, I cannot save the query. I get the same error message. I must save the query first and then run. I have ported this query to three different servers and the result is the same. Two servers are local and one is the other at our provider in Charlotte, NC (Titan microsoft access 2003 Technologies). Titan is the administrator of our JD Edwards ERP system. All of the servers are using Microsoft Access 2003 SP3. I suspect that the problem could be related to the fact that the result of this query will be a table with about 3 1/2 million records. Am I just asking too much of Microsoft access? My query: SELECT PRODDTA_F0911.* INTO [tblF0911(GDS-4160-09202012-02)] FROM PRODDTA_F0911 WHERE (((PRODDTA_F0911.GLAID)="00638625") AND ((PRODDTA_F0911.GLSBLT)="W")); I have also attempted to run the query using Microsoft SQL Server 2008 Management Studio and I cannot seem to get it to create a table. I can display the 3.5MM records but that is too many to past into an Excel file or table. SELECT PRODDTA.F0911.* INTO [tblF0911(GDS-4160-09202012-02)] FROM PRODDTA.F0911 WHERE (((PRODDTA.F0911.GLAID)='00638625') AND ((PRODDTA.F0911.GLSBLT)='W')); Ideas? 0 Question by:Tom Winslow Facebook Twitter LinkedIn Google LVL 4 Best Solution byrshq Hi Please see this link maybe help http://support.microsoft.com/kb/835416 Go to Solution 13 Comments LVL 22 Overall: Level 22 MS Access 21 Query Syntax 8 MS SQL Server 2008 4 Message Active today Expert Comment by:Kelvin Sparks2012-09-20 Does the select statement (without the into part return the records correctly - and can you scroll to the end of the 3.5M records (y=the only way to know that it has run correctly to the end)? That is a lot, but no an unmanageable number of records for Access, and it will depand how wide (how