All, using MS Access 2010. I have a database that when I try to run one particular query; MS stops working. It forces me to close and reopen. Sometimes it makes a backup and compacts the program. All other tables and queries are fine; just this one. I tried importing it from an older copy and still does the same thing. Any suggestions on what to do would be appreciated!
access stops working
- Thread starter slimjen1
- Start date
pr2-eugin
Super Moderator
- Local time
- Today, 12:22
- Joined
- Nov 30, 2011
- Messages
- 8,494
Divide and Conquer ! Normally it would be some error in the Expression/calculation in the Columns. If there are less data the column would say #Error. If the dataset is large, Access will struggle compiling the calculation, so it will simply give up.
Yup, this is pretty much what happened to me. I had very little data in my developement database, therefore the system wouldn't crash. It was only when I tried to run that query on my master database that it would start crapping out.
