added field to query in combo crashes application

[JK]

When I add a new field to a query contained in a combo box, my entire
application crashes (auto creates a backup.)

Has anyone had this problem?

It's a simple query with only one table (no joins.) There are 15 fields in
the combo box. Is there a limit to the number of fields you can add to a
combo?

Please help...

Access 2003 SP3

Thx.

 

[Allen Browne]

If you have not done so yet, apply this hotfix from Microsoft:
http://support.microsoft.com/kb/945674

What you describe is one of the bugs in A2003 SP3:
http://allenbrowne.com/bug-Access2003SP3.html

 

[JK]

Does this need to be installed on every computer that will use the .mde file
or just the developers PC?

Thx so much!

Jason

 

[JK]

That didn't solve the problem. The app. still crashed as soon as I add the
one additional field to my combo box. Very strange.

I downloaded the hotfix, and ran it. I was asked for a location to save the
files and I put them in the Microsoft Office folder in Program Files. The
website did not specify a specific location. Maybe I put them in the wrong
location?

I also didn't restart my computer - the website says you don't have to - but
I'll try that too.

Jason

 

[Douglas J. Steele]

It would need to be on each workstation.

 

[Douglas J. Steele]

If memory serves, you extract the files to a location, and then you have to
run the executable that's extracted.

 

[Allen Browne]

After ensuring the hotfix has been applied as Doug suggests, if it still
crashes you need to walk through each of the steps here:
http://allenbrowne.com/recover.html

If you are still stuck after that, post the SQL statement that fails (i.e.
with the extra field in it), along with these properties of the combo:
- Column Count
- Column Widths
- Bound Column
- Control Source
- Name

 

[JK]

Wow. I don't know what I would do without you guys. I manually ran the .msp
file and that fixed the problem.

I should have known better regarding the hot fix installation.

Much appreciated!