Invalid Argument Error Ms Access
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Wed, 19 Oct 2016 03:02:02 GMT by s_wx1080 (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
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring http://stackoverflow.com/questions/22008829/run-time-error-3001-invalid-argument-when-creating-a-table-in-access-vba developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Run-time error '3001': Invalid Argument when creating a table in Access VBA up vote 1 down vote favorite 1 When creating a table in Access VBA using the following code: Set tbl invalid argument = dbs.CreateTableDef("" & strTableName & "") I get the following error: Run-time error '3001': Invalid Argument. What causes this? vba ms-access access-vba ms-access-2010 share|improve this question asked Feb 25 '14 at 8:45 BFWebAdmin 2,12763167 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted The name of the table you're trying to create (in the above example expressed as strTableName) is not valid - it's probably either null or too long. The names of Access invalid argument error 2010 tables can be no longer than 64 characters. If strTableName is not null and has fewer than 64 characters, the above code will work perfectly. share|improve this answer edited Feb 26 '14 at 14:57 answered Feb 25 '14 at 8:45 BFWebAdmin 2,12763167 1 Or strTableName could be Null –4dmonster Feb 25 '14 at 9:52 @4dmonster - Yes, good point - in short, anything that creates an invalid table name would generate this error. –BFWebAdmin Feb 25 '14 at 10:08 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged vba ms-access access-vba ms-access-2010 or ask your own question. asked 2 years ago viewed 6076 times active 2 years ago Blog Stack Overflow Podcast #91 - Can You Stump Nick Craver? Related 0How to create a comment box with time and date stamp in Access1Run Time Error 3464: Data Type Mismatch in criteria expression0MS Access 2010 VBA runtime error 3075 (searching with apostrophes)3append query in VBA (run-time error 3067)1Creating Login form on Access using VBA1Getting undefined variable error when using msoEncodingUTF8 in VBA0Microsoft Access VBA Insert