If 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 to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Invalid Argument on saving query
I have was chuggin along pretty good yesterday, then all
of a sudden I am getting "Invalid Argument" anytime I try to save a query. Tried writing the SQL and using the query designer, tried different tables, different fields, anything. They query will run, but it will not save without the "Invalid Argument". Any thoughts? Thanks Brenda |
#2
|
|||
|
|||
Access 2002 SP2.
It happens when I try to save any query, even a query that use to work. -----Original Message----- I have was chuggin along pretty good yesterday, then all of a sudden I am getting "Invalid Argument" anytime I try to save a query. Tried writing the SQL and using the query designer, tried different tables, different fields, anything. They query will run, but it will not save without the "Invalid Argument". Any thoughts? Thanks Brenda . |
#3
|
|||
|
|||
My compact and repair is also giving me the invalid
argument almost instantly after clicking the button. -----Original Message----- I have was chuggin along pretty good yesterday, then all of a sudden I am getting "Invalid Argument" anytime I try to save a query. Tried writing the SQL and using the query designer, tried different tables, different fields, anything. They query will run, but it will not save without the "Invalid Argument". Any thoughts? Thanks Brenda . |
#4
|
|||
|
|||
I think there are corruptions in your database.
See Tony Toews' set of article: http://www.granite.ab.ca/access/corruptmdbs.htm -- HTH Van T. Dinh MVP (Access) wrote in message ... My compact and repair is also giving me the invalid argument almost instantly after clicking the button. -----Original Message----- I have was chuggin along pretty good yesterday, then all of a sudden I am getting "Invalid Argument" anytime I try to save a query. Tried writing the SQL and using the query designer, tried different tables, different fields, anything. They query will run, but it will not save without the "Invalid Argument". Any thoughts? Thanks Brenda . |
#5
|
|||
|
|||
I was past the 2gig database size. Thanks for the help.
"Van T. Dinh" wrote in message ... I think there are corruptions in your database. See Tony Toews' set of article: http://www.granite.ab.ca/access/corruptmdbs.htm -- HTH Van T. Dinh MVP (Access) wrote in message ... My compact and repair is also giving me the invalid argument almost instantly after clicking the button. -----Original Message----- I have was chuggin along pretty good yesterday, then all of a sudden I am getting "Invalid Argument" anytime I try to save a query. Tried writing the SQL and using the query designer, tried different tables, different fields, anything. They query will run, but it will not save without the "Invalid Argument". Any thoughts? Thanks Brenda . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Invalid argument. (Error 3001) | Frank Sullivan | General Discussion | 1 | September 16th, 2004 12:26 AM |
Show records from query 1 or query 2 depending | Running & Setting Up Queries | 1 | September 10th, 2004 12:35 AM | |
Invalid Argument | Mjohnson | Running & Setting Up Queries | 1 | September 4th, 2004 01:11 AM |
Invalid Argument - 3001 | M. Perry | General Discussion | 1 | August 17th, 2004 01:06 AM |