Microsoft Access Query Invalid Argument Error
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 16:02:48 GMT by s_wx1126 (squid/3.5.20)
on Access Server without losing any data Perform Easy Trim Operation and Restore Databases in MS Access How to recover corrupt Databases on Access Server without losing any data How to Troubleshoot database corruption issues of MS Access Archives August 2014 April 2013 January 2013 October 2012 September 2012 July 2012 March 2012 December 2011 October 2011 August 2011 July 2011 August 2010 June 2010 May 2010 April 2010 March 2010 February 2010 January 2010 December 2009 September 2009 Resolving the - Invalid argument - error message in Access August 30th, 2011 | Author : Colin Paul Let’s consider a real life scenario wherein when you try to run an append 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 query or import data in a large MS Access database file, you get to face the following error message: “Invalid argument” Now let’s try to understand the root cause behind the occurrence of the aforementioned error message. The primary reason behind the occurrence of the aforementioned error message is that the Access database file nears 2 GB in size. Now that we have come to know about the cause behind the occurrence http://www.repairaccessdatabase.org/blog/resolving-the-invalid-argument-error-message-in-access/ of the aforementioned error message, let’s focus on the resolution part. In order to resolve the aforementioned error message, you must try to reduce the Access database file size. You can reduce the size of the Access database file in the below-mentioned two ways; Method 1: Use the Compact and Repair utility to reduce the size of Access database file. Method 2: Split the Access database file. Let’s first of all see as to how using the Compact and Repair utility, you can reduce the size of the Access database file. Start MS Access. Click Tools -> Database Utilities -> Compact and Repair Database. Select the Access database file which you want to compact in the “Database to compact from” dialog box. Enter a name for the compacted database in the “Compact Database Info” dialog box. Click the Save button. By performing the aforementioned steps, the Access database file would be compacted and its size reduced. The second method is to split the Access database file. Start MS Access. Open the problematic Access database file. Click Tools -> Database Utilities -> Database Splitter. In the Database Splitter dialog box, click Split Database. Enter a new name for the split Access file. Click the Split button. Click the Ok button. By performing the aforementioned steps, the Acc
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 http://www.dbforums.com/showthread.php?788883-Make-Table-Query-Invalid-Argument-Error 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 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 invalid argument Table query and I keep getting an Invalid Argument Error. This query ran fine a couple of months ago and now it's 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 microsoft access query 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....the only way I fixed my db....was to create a new db and import all of the tables, forms, queries, etc over to the new db. The size of my db went from 2 gigs to 37 megs. It's working fine now. Reply With Quote Quick Navigation Microsoft Access Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft SQL Server MySQL Oracle Pervasive.SQL PostgreSQL Sybase Other Data Access, Manipulation & Batch Languages ASP Crystal Reports Delphi, C etc JAVA Perl and the DBI PHP ANSI SQL Unix Shell Scripts Visual Basic PC based Database Applications Brilliant Dat