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
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"sdg8481" wrote:
[Quoted Text] > 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
|