invalid argument - access 2003

J

jacob

I created a query and I was trying to save the query, I kept getting a
message "invalid argument" and the query will not save. What can I do in
order to save the query.
 
G

ghetto_banjo

Please copy/paste the SQL view of the query so people can get a better
idea of what you are doing.
 
J

jacob

Having looked at similar queries and replies on this site. I decided to use
Tools>Database Utilities>Compact and Repair Database. This action reduces the
size of the database from 2G ti 1.7G and the error has disappeared.

ghetto_banjo thank you for your response. I will paste the SQL if I come
accross this error again in future. As an amatuer on access I am sure it will
happen again.

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invalid Argument on Access 2003 1
We try to save msg in got the error in outlook 2021/office 365 0
Shell command produces a "Run-time error '5': Invalid procedure call or argumen 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Append Crosstab Query to Existing Table 0
Add additional information to excel form after original data entry 0
Outlook Filters 0

Top