What causes "invalid argument" error in previously stable queries.

#1 March 10th, 2005, 05:23 PM

I have an Access database that has been constantly in use for years. Suddenly
it has begun giving 'Invalid Argument' errors on various established queries,
and even on new ones. Can anyone help me figure out why this might be
happening, and how to fix it?

#2 March 10th, 2005, 05:31 PM

Most common causes would be:
- calculated field or criterion mis-interpreted. See:
http://allenbrowne.com/ser-45.html
or
- Name AutoCorrect problem. See:
http://allenbrowne.com/bug-03.html
or
- corruption of the database. See:
http://allenbrowne.com/ser-47.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Reynolds47" wrote in message
...
I have an Access database that has been constantly in use for years.
Suddenly
it has begun giving 'Invalid Argument' errors on various established
queries,
and even on new ones. Can anyone help me figure out why this might be
happening, and how to fix it?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Invalid Argument Problem	JohnB	General Discussion	0	February 18th, 2005 03:44 PM
Invalid Argument Error	ChuckW	Running & Setting Up Queries	3	January 4th, 2005 03:49 PM
Invalid Argument on saving query	brenda	New Users	4	October 4th, 2004 03:37 PM
Invalid argument. (Error 3001)	Frank Sullivan	General Discussion	1	September 16th, 2004 12:26 AM
invalid argument	kathy	Running & Setting Up Queries	1	June 22nd, 2004 04:52 PM