473,847 Members | 2,426 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access Crashes When Rt Click Build in Query Design View

I'm running Access 2003, modifying a query that has over 45 fields. When I
right click on the field name in Query Design View, and then click Build,
Access crashes before the Build window appears. It doesn't happen every time,
and using the Zoom window works fine. It appears that it only happens when I
want to modify an existing expression. This continues to happen even after
the database is repaired and reopened. Anyone have any suggestions?

--
Message posted via http://www.accessmonster.com

Apr 27 '07 #1
3 7777
Not sure what's causing the problem, but here's a sequence that addresses a
number of issues.

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair
or in Access 2007:
Office Button | Manage | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\m saccess.exe" /decompile
"c:\MyPath\MyDa tabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code),
and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

7. Open your query in SQL View.
Copy the query statement out to (say) Notepad.
Close. Then delete the query.
Compact again.
Create a new query.
Paste the query statement from Notepad into SQL View.
Switch to Design view, and tidy it up.

BTW, after setting a property, *always* press Enter before you do anything
else. Do not leave the cursor in the same property and try to test the query
or close the properties box, or ...

Let us know how you went.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"mnjkahn via AccessMonster.c om" <u27308@uwewrot e in message
news:7156d89e81 930@uwe...
I'm running Access 2003, modifying a query that has over 45 fields. When
I
right click on the field name in Query Design View, and then click Build,
Access crashes before the Build window appears. It doesn't happen every
time,
and using the Zoom window works fine. It appears that it only happens
when I
want to modify an existing expression. This continues to happen even
after
the database is repaired and reopened. Anyone have any suggestions?
Apr 28 '07 #2
Sorry, Allen, but it didn't work. I thought you had something there for a
moment. When I checked the references I noticed that the ADO library was
Version 2.1. Since I was using Access 2003, and working with an Access 2002-
2003 format database, I changed the reference to 2.5. It worked a few times,
then crashed just like it always had. Now, all I have to do is click Build
on a field, modify it or just select and copy, close the Build, hit enter,
then click on another field and then Build, and I get a crash every time.
And it will happen on more than one query in the database. I have even
created a new database, copied over the linked tables and queries, and had it
crash on the Build.
The query pulls data through 3 queries with data originating from 3 tables
linked to Excel spreadsheets, one of which contains over 75,000 records. I
wouldn't think that either the size, or the fact that I'm using linked Excel
spreadsheets would make a difference, at least it hasn't under Access 2002.
However, at this point, I'm at a loss to explain it.

Here's a little more info, for what its worth:
MS Access 2003(11.6566.81 22) SP2
References:
Visual Basic for Applications
Microsoft Access 11.0 Object Library
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.5 Library
OLE Automation

Allen Browne wrote:
>Not sure what's causing the problem, but here's a sequence that addresses a
number of issues.

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair
or in Access 2007:
Office Button | Manage | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\m saccess.exe" /decompile
"c:\MyPath\MyDa tabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code),
and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

7. Open your query in SQL View.
Copy the query statement out to (say) Notepad.
Close. Then delete the query.
Compact again.
Create a new query.
Paste the query statement from Notepad into SQL View.
Switch to Design view, and tidy it up.

BTW, after setting a property, *always* press Enter before you do anything
else. Do not leave the cursor in the same property and try to test the query
or close the properties box, or ...

Let us know how you went.
>I'm running Access 2003, modifying a query that has over 45 fields. When
I
[quoted text clipped - 6 lines]
>after
the database is repaired and reopened. Anyone have any suggestions?
--
Message posted via http://www.accessmonster.com

May 1 '07 #3
Well, I'm not sure what else to suggest.

Since you disabled Name AutoCorrect and decompiled and compact/repaired and
fixed references and now have fully compiled code and then recreated the
query, I'm not sure what alternatives might help.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"mnjkahn via AccessMonster.c om" <u27308@uwewrot e in message
news:718915f9d0 99a@uwe...
Sorry, Allen, but it didn't work. I thought you had something there for a
moment. When I checked the references I noticed that the ADO library was
Version 2.1. Since I was using Access 2003, and working with an Access
2002-
2003 format database, I changed the reference to 2.5. It worked a few
times,
then crashed just like it always had. Now, all I have to do is click
Build
on a field, modify it or just select and copy, close the Build, hit enter,
then click on another field and then Build, and I get a crash every time.
And it will happen on more than one query in the database. I have even
created a new database, copied over the linked tables and queries, and had
it
crash on the Build.
The query pulls data through 3 queries with data originating from 3 tables
linked to Excel spreadsheets, one of which contains over 75,000 records.
I
wouldn't think that either the size, or the fact that I'm using linked
Excel
spreadsheets would make a difference, at least it hasn't under Access
2002.
However, at this point, I'm at a loss to explain it.

Here's a little more info, for what its worth:
MS Access 2003(11.6566.81 22) SP2
References:
Visual Basic for Applications
Microsoft Access 11.0 Object Library
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.5 Library
OLE Automation

Allen Browne wrote:
>>Not sure what's causing the problem, but here's a sequence that addresses
a
number of issues.

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair
or in Access 2007:
Office Button | Manage | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\m saccess.exe" /decompile
"c:\MyPath\MyDa tabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code),
and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

7. Open your query in SQL View.
Copy the query statement out to (say) Notepad.
Close. Then delete the query.
Compact again.
Create a new query.
Paste the query statement from Notepad into SQL View.
Switch to Design view, and tidy it up.

BTW, after setting a property, *always* press Enter before you do anything
else. Do not leave the cursor in the same property and try to test the
query
or close the properties box, or ...

Let us know how you went.
>>I'm running Access 2003, modifying a query that has over 45 fields.
When
I
[quoted text clipped - 6 lines]
>>after
the database is repaired and reopened. Anyone have any suggestions?
May 2 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2204
by: Alicia | last post by:
If I wanted to create a table by hand create table temp( etc, where do I do it in access?
15
3619
by: Pres | last post by:
I am not an experienced programmer. I do have a question regarding workday calculations. I have 3 fields. CURDATE, NUMDAYS, CALCDATE After entering the first two fields, normally the current date and for example 10 (10 day period) I need the CALCDATE to pass me the calculated date taking into account workdays and holidays. In other words, the 10th business day. How is this done? Thanks for any help...
2
19162
by: Ray | last post by:
Stop me if you've heard this, but I am running Access 2002 and all of a sudden, if I design a particular form (it's been working fine for ages), Access crashes rather than open it in design view. Interestingly, it doesn't crash if I run the app and open it in form view! Just if I attempt to design it. If I compact/repair, it allows me to design the form once. On any subsequent attempts to view in design mode, though, it crashes before...
0
1877
by: jphelan | last post by:
I have a subform that works fine until you import it into a new database when it crashes if you try to open it in either disign or form view. The form, "Attendees_Subform" in my application was pattern after the same form used in the MS template, "Event Management.mdb" application that is downloaded from the MS Template Gallery on their website. I narrowed down the problem to the Control Source in the, "Attendees_Subform using the...
6
2811
by: fumanchu | last post by:
I've got to let end users (really just one person) load billing batch files into a third party app table. They need to specify the billing cycle name, the batch name, and the input file name and then I can use these values to execute a SQL Server stored procedure to load them into the batch table from the input file (the stored procedure uses Dynamic SQL to Bulk Insert the file to a temp table then processes it into the final table.) My...
13
4011
by: royaltiger | last post by:
I am trying to copy the inventory database in Building Access Applications by John L Viescas but when i try to run the database i get an error in the orders form when i click on the allocate button "Unexpected Error":3251 operation is not supported for this type of object.The demo cd has two databases, one is called inventory and the other just has the tables for the design called inventory data. When you run inventory the database works...
17
4429
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting there, but is there a way they can find out if that application was put there from a CD or email or created at work? Hint: It's not on a client/server database, just native jet database mdb created on Access 2003 (default 2000)...
3
2904
by: Mike | last post by:
Hi, Im trying to create a crosstab query with fewer than 255 headings (about 50), but it crashes when I try to save after writing the heading names in the query property "column headings". My list is pretty long, but far from having 255 entries. I specify which columns I want so that it doesn't give me an error message because a field has no valid data attached to it.
8
6737
by: babyangel43 | last post by:
Hello, I have a query set up in Access. I run it monthly, changing "date of test". I would like this query to be merged with a Word document so that the cover letter is created in Word, the fields from Access are automatically filled into the Word document. The query could be anywhere from 0-5000 names, one cover letter per name. AND to this cover letter for each applicant, there has to be attached a two page document. How in the world can...
0
9879
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9727
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10981
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10643
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10330
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9477
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7050
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4521
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4113
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.