Saving a Query

[Guest]

I am trying to run a query from a 900MB table. I have successfully ran the
query (about 4 million records), but when I try to save it, an error message
appears stating "invalid argument". I have saved a similiar query just like
before. Why will it not allow me to save this one? Any advice is
appreicated.

 

[Lachlan Mullen]

Blake,

Your database is too large. Microsoft access corrupts databases onve
they get near 1GB. There are some things you can try, but I apologize
if I seem a little doom-and-gloomy.

1) Compact and Repair (Tools>Datebase Utilities>Compact and Repair)
This will keep your database from getting that big. Unfortunattely,
with a database already that size, it may not actually work. Which
brings me to 2...

2) Start a new database, and import all your tables out of the corrupt
database into a new one. If you have to, break up the origional across
a couple databases to keep it smaller. Several smaller databases will
actually be faster than one large one.

Hope that helps.

Lach

 

[Guest]

Does the cursor go to any particlar part of the query when in design view and
you try to save? That might give you a clue what it thinks is wrong.

Go to design view and click on menu VIEW - SQL View. Highlight the SQL
statement, copy, and paste into a Word document for safekeeping.

In design view delete a part of the query and try to save until you find the
offending element.

Paste the full SQL back in and in design view try deleting the last element
removed that allowed saving. If it save then you know what you have to fix.