Solved

Access closes when saving a query.

Posted on 2011-02-14
13
268 Views
Last Modified: 2012-05-11
I'm trying to update a select query.  When I go to save the query, Access closes.  When I reopen the db and look at the query, my chgs are not saved.  Other queries work OK.  What could the issue be?
0
Comment
Question by:vsllc
  • 6
  • 5
  • 2
13 Comments
 
LVL 75
ID: 34890971
Try the basics

Compact & Repair the db

If not fix

Delete the query, do a Compact & Repair, then recreate the query

If no fix, Import all objects (except Linked tables) into a blank db.

0
 
LVL 11

Expert Comment

by:RgGray3
ID: 34891072
Do you get the same results when
     creating a NEW query
     Editing a different query  (in short 1 or 2 queries or ALL queries)

If it is just the one query...  copy the SQL to the clipboard and save it as a NEW query
if all queries...   the container is corrupt...   get them into a new container
 
0
 

Author Comment

by:vsllc
ID: 34891316
None of the three options worked.  Could it be it's too large?  It's a lot of code.
0
 
LVL 75
ID: 34891340
Can you upload the db ?

mx
0
 

Author Comment

by:vsllc
ID: 34891439
No.  I'm going to break it into 2 queries and see if that fixes it.  Is there generally a character limit on the queries?
0
 
LVL 75
ID: 34891482
From:
http://office.microsoft.com/en-us/access-help/access-2010-specifications-HA010341462.aspx


Query
Attribute       Maximum
Number of enforced relationships       32 per table, minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships*
Number of tables in a query       32*
Number of joins in a query       16*
Number of fields in a recordset       255
Recordset size       1 gigabyte
Sort limit       255 characters in one or more fields
Number of levels of nested queries       50*
Number of characters in a cell in the query design grid       1,024
Number of characters for a parameter in a parameter query       255
Number of AND operators in a WHERE or HAVING clause       99*
Number of characters in an SQL statement       Approximately 64,000*
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:vsllc
ID: 34891561
Interesting.  I'm using Access 2002.  Is this comparible?
0
 
LVL 75
ID: 34891574
Yes.
0
 

Accepted Solution

by:
vsllc earned 0 total points
ID: 34891718
OK.  This fixed it, but not sure what implications this solution will have on the db.  Any ideas?

http://www.pcreview.co.uk/forums/access-crashes-changing-and-saving-query-t1085623.html
0
 
LVL 11

Expert Comment

by:RgGray3
ID: 34891842
Seems to be specific to 2002...  interesting...  skiped from 97 to 2003...   I missed all the fun...

Don't know what if anything shutting down autocorrect will do to you.... but if it works...  your ahead of the game...
0
 
LVL 75
ID: 34892088
Guess I should have though of the Name Auto Correct issue.  I always turn if off.  

mx
0
 

Author Comment

by:vsllc
ID: 34892304
OK.  It works, I'm happy.  If something comes up I'll deal with it then!
0
 

Author Closing Comment

by:vsllc
ID: 34932159
This setting change fixed the issue.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now