Access 2003 Invalid Argument Error
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Fri, 30 Sep 2016 00:50:40 GMT by s_hv987 (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
Invalidargumentexception
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 11.2 © 2003-2016 SmarterTools Inc. By using this site, you are accepting cookies to store user state and login information. Management Interface × forgotPassLbl Cancel Send 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
this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you http://www.dbforums.com/showthread.php?788883-Make-Table-Query-Invalid-Argument-Error 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. Results 1 to 3 of 3 Thread: Make Table Query - Invalid Argument Error??? Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid invalid argument Mode Switch to Threaded Mode 05-19-03,07:23 #1 cdakjat View Profile View Forum Posts Registered User Join Date Dec 2002 Location Alaska Posts 19 Unanswered: Make Table Query - Invalid Argument Error??? I'm attempting to run a Make Table query and I keep getting an Invalid Argument Error. This query ran fine a couple of months ago and now it's access invalid argument giving me fits. I tried to compact & repair the database and the database gives me an error (after a long wait). Whats weird is I can have the Make Table query open in design view and do a right click and select Datasheet view and the query works. I even tried to copy/paste the data from the Datasheet view into a unpopluated table...and it fails. I get the same Invalid Argument error. Any suggestions on what I might do to fix this problem? Thanks... Reply With Quote 06-17-03,11:47 #2 texasalynn View Profile View Forum Posts Registered User Join Date Jun 2002 Location Houston, TX Posts 116 I'm getting a similar problem. I have a feeling that the maximum limits are causing the problem. I saw a message a while back about the limits and mine is 2GB. I'm stumped on how to fix. So I will be happy if someone knows the answer texasalynn Reply With Quote 06-22-03,13:07 #3 cdakjat View Profile View Forum Posts Registered User Join Date Dec 2002 Location Alaska Posts 19 Yeah....t