If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access crashes when query is saved or when opening design view
I have an update query ("main query") that is based on a number of other
update queries. The queries itself run fine. When trying to open the main query in design view or when trying to save the main query, Access2002 crashes. Rebooting, using Compact and Repair tool won't help, the issue seems hardware independent. Any advise where I should start looking? Thanks so much in advance..... JK |
#2
|
|||
|
|||
Sounds like the Name AutoCorrect bug.
From the database window, click Tools | Options | General tab, and deselect the Name AutoCorrect option. See Allen Browne's site for more details: http://allenbrowne.com/bug-03.html -- Ken Snell MS ACCESS MVP "jkochchs" wrote in message ... I have an update query ("main query") that is based on a number of other update queries. The queries itself run fine. When trying to open the main query in design view or when trying to save the main query, Access2002 crashes. Rebooting, using Compact and Repair tool won't help, the issue seems hardware independent. Any advise where I should start looking? Thanks so much in advance..... JK |
#3
|
|||
|
|||
Ken,
Thanks so much for this. interestingly enough, all autocorrect options had already been unchecked. After checking them, the query would not even run (which it did before). Unchecking them again, old status. Rebooting, starting everything again, surprise - it works! Go figure. Certainly a new element to the Autocorrect bug, or at least one I wasn't familiar with. Thanks again, you had me in the right direction..... JK "Ken Snell [MVP]" wrote: Sounds like the Name AutoCorrect bug. From the database window, click Tools | Options | General tab, and deselect the Name AutoCorrect option. See Allen Browne's site for more details: http://allenbrowne.com/bug-03.html -- Ken Snell MS ACCESS MVP "jkochchs" wrote in message ... I have an update query ("main query") that is based on a number of other update queries. The queries itself run fine. When trying to open the main query in design view or when trying to save the main query, Access2002 crashes. Rebooting, using Compact and Repair tool won't help, the issue seems hardware independent. Any advise where I should start looking? Thanks so much in advance..... JK |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
WORD XP mail-merge FAILS using ACCESS Query | SueMackay | Mailmerge | 1 | November 23rd, 2004 02:03 PM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |