Solved

Access 2000 or 2003

Posted on 2012-04-02
6
214 Views
Last Modified: 2012-06-03
I have a lot of select qry's I just ran them all last week with no issue.  Nothing has changed in regards to the talbes or the data in the tables?  When I run them today and I try to make a table from them or simply just save them, I am getting this error?  How can I fix this or find out what is causing this error.  

Invalid argument. (Error 3001)
You tried to perform an operation that involves a routine in a DLL, and one of the arguments to the routine is invalid. Check your entry to make sure you have specified the correct arguments, and then try the operation again.

This error also occurs when you attempt to use mutually exclusive constants in an argument to a method, such as specifying both dbConsistent and dbInconsistent in the options argument to the OpenRecordset method.
0
Comment
Question by:mishlce
6 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
Comment Utility
Have you checked your VB references?

Open the VB editor window and select Tools -> References.

If any of those items are missing, make a note of which ones.

Then uncheck them click OK.

Then locate them in the listbox, and reselect them.
0
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
Make a backup and try compact/repairing your database.

Check the tables in question for any corrupted looking data.

Try the same queries on a backup copy of your data - taken from before this error started occurring.
0
 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
Typically when something like that happens, it as the others have said or the data has changed in some way (ie. a NULL).

Check any calls your making in that query to procedures.

Jim.
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
<mutually exclusive constants in an argument to a method>
?

Can you post the SQL and/or code you are using...?
0
 

Accepted Solution

by:
mishlce earned 0 total points
Comment Utility
Database was over its size limit so was giving me this error.  It was at 2.0 MB I split it cleaned it out compacted and repaired and then it worked fine.
0
 

Author Closing Comment

by:mishlce
Comment Utility
Figured it out on own after looking at the size of my database
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now