I am running a number of queries etc linked to sql tables (access 2003).
Everything runs fine but in the last couple of days when ever I try and save a query , even one which has not been modified in any way, i get a very simple error message which just says Invalid Argument.

The only thing of any signifcance I have done over the past week is to export the tables to XL so I can do a bit of work at home where I cant access the sql server.....

I am completely stuffed as to know where to start looking, anyone any ideas ?

Sorry to waste anyones time I should have tried a compact and repair before posting.

All sorted now

I keep getting invalid argument message even though I have compacted/repaired the database several times.... any ideas as to why?

Try going to the VBA window and selecting DEBUG > COMPILE and see where it takes you for an error if anything.

Also, you can try DECOMPILING (http://www.granite.ab.ca/access/decompile.htm)

Tried the VBA window - debug and everything was greyed out... unavailable.. so I am assuming its not that... I read about decompiling in the link you posted - looks kind of scary! :) I don't want to lose my database.. :confused:

looks kind of scary! :) I don't want to lose my database.. :confused:
Save a COPY of the file first. Then if anything dies you can just replace it with the copy you saved. ALWAYS backup before doing anything.