Access 2003 database inconsistent behaviour between Vista and XP

[CJ]

Hi Groupies:

I'm not sure which newsgroup this question belongs to, sorry.

I have an Access 2003 database that was built on my Vista laptop. This
laptop also has Access 2007 installed but that version has not been used at
all to work with this database. My other computer has Windows XP and only
has Access 2003 installed.

In a couple of forms I have combo boxes that are used for searches. On my
Vista machine, these searches work fine, on my XP machine, the searches
work, but no data is "visible" when you push the down arrow. The list still
shows the correct number of rows as if the data was there, but no words show
up so you have to guess at what you are selecting.

The query behind the search boxes works fine and if you try the query by
itself all of the data shows up properly.

Not realizing what was going on, I spent a couple of hours trying to fix the
searches on my XP machine. I changed formatting, rebuilt the query,
everything I could think of. There was no way that I could make this thing
work on XP yet no problems on Vista.

What is the deal????
Any insight?......Anybody.......

 

[Mark L. Ferguson]

The 'common controls' dll for that in Access 07 is probably different from
the one in 03. I would locate the comctl32.dll used by Access 07, and put it
in the path for your search dialog in XP (not system32, but the Access .exe
folder.) You might also accomplish this by installing the Runtime files for
Access 07.
Access 2007 Download: Access Runtime:
http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&DisplayLang=en
--
Was this helpful? Then click the Ratings button. Voting helps the web
interface.
http://www.microsoft.com/wn3/locales/help/help_en-us.htm#RateAPostAsAnswer
Mark L. Ferguson
..

 

[George Nicholson]

Check Microsoft/Office Update. I bet your XP machine has Office 2003 SP3
installed but not the hotfix (and your Vista machine has either both or
neither).

What you describe was a problem created by SP3 and subsequently "fixed".
http://support.microsoft.com/kb/945674/en-us

 

[CJ]

Fantastic, that was it!

I had SP3 on both machines but neither had the HotFix. I don't have updates
auto installed but I don't recall seeing anything about this fix from MS.
Or, there may have been so many that I quit paying attention to them.

Have a great weekend.

 

[pcbins]

I need this hotfix also. I have downloaded it and extracted the files. Now
what? How do i install this hotfix?

Fantastic, that was it!

I had SP3 on both machines but neither had the HotFix. I don't have updates
auto installed but I don't recall seeing anything about this fix from MS.
Or, there may have been so many that I quit paying attention to them.

Have a great weekend.

 

[Bob Larson]

It should be an exe file which you just run.

--

Thanks,

Bob Larson
Access MVP
Administrator, Access World Forums
Utter Access VIP

Free Access Tutorials and Resources: http://www.btabdevelopment.com

 

[pcbins]

The link below leads to a download of: office2003-kb945674-glb.exe
When I run this file, I get a popup window asking where to extract the files
to.
Where am i supposed to extract these files to? And what do I do with these
files once they are extracted?
The files extracted are:
BasingOnecomboBoxOnAnother.exe
FrmSampl.exe
MSACCESS.msp
MSACCESS_readme.txt
Nwind.exe
OnTimeandHowMuchHasElapsed.exe
QrySampl.exe
RptSampl.exe
Summingreprots.exe
UsingParameterswithQueriesandReports.exe

Please don't waste my time with answers like "It should be an exe file which
you just run."

If you have to use terms like "should be" or "I think" or "Maybe", then you
are wasting my time.

It should be an exe file which you just run.

--

Thanks,

Bob Larson
Access MVP
Administrator, Access World Forums
Utter Access VIP

Free Access Tutorials and Resources: http://www.btabdevelopment.com

I need this hotfix also. I have downloaded it and extracted the files. Now
what? How do i install this hotfix?

 

[Bob Larson]

Okay, if you're going to be nasty then I will too -

Open the MSACCESS_readme.txt file and find all the instruction you will
need. Sheesh!

 

[pcbins]

OMG... you mean open the readme file ! WOW... your wisdom is so humbling...
unfortunately THAT WAS ONE OF THE FIRST THINGS I TRIED.

NEXT?

Okay, if you're going to be nasty then I will too -

Open the MSACCESS_readme.txt file and find all the instruction you will
need. Sheesh!

The link below leads to a download of: office2003-kb945674-glb.exe
When I run this file, I get a popup window asking where to extract the
files
to.
Where am i supposed to extract these files to? And what do I do with these
files once they are extracted?
The files extracted are:
BasingOnecomboBoxOnAnother.exe
FrmSampl.exe
MSACCESS.msp
MSACCESS_readme.txt
Nwind.exe
OnTimeandHowMuchHasElapsed.exe
QrySampl.exe
RptSampl.exe
Summingreprots.exe
UsingParameterswithQueriesandReports.exe

Please don't waste my time with answers like "It should be an exe file
which
you just run."

If you have to use terms like "should be" or "I think" or "Maybe", then
you
are wasting my time.