SQL Query help

[Guest]

Hi,

I have a Make table query that was designed through the SQL builder of MS
Access queries, however now i need to make alterations to the query but
everytime i try and open it in design view it crashes on me, causing the
database to not respond. Therefore, is ther any back way i can open the query
in SQL design view without having to open it via the normal design view.

Hope you can help.

Thanks

 

[Guest]

At times like this, nothing beats a good backup. In fact make a complete
backup of your database now and put it away for safe keeping. What you are
experiencing certainly sounds like a corrupt database problem.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp