|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
05-09-2008
| #1 (permalink) |
| | Access 2003 database inconsistent behaviour between Vista and XP 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....... -- Thanks for taking the time! CJ --------------------------------------------------------- Know thyself, know thy limits....know thy newsgroups! |
My System Specs |
|
05-09-2008
| #2 (permalink) |
| | Re: Access 2003 database inconsistent behaviour between Vista and XP 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/i...splayLang%3den -- Was this helpful? Then click the Ratings button. Voting helps the web interface. http://www.microsoft.com/wn3/locales...eAPostAsAnswer Mark L. Ferguson .. "CJ" <private@xxxxxx> wrote in message news:20B7A98C-2758-4183-B504-EE43AA9132EC@xxxxxx Quote: > 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....... > > -- > Thanks for taking the time! > > CJ > --------------------------------------------------------- > Know thyself, know thy limits....know thy newsgroups! |
| My System Specs |
|
05-09-2008
| #3 (permalink) |
| | Re: Access 2003 database inconsistent behaviour between Vista and XP 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 -- HTH, George "Mark L. Ferguson" <MarkLFerguson@xxxxxx> wrote in message news:3A397E3E-0E8A-483C-8178-0313CC51363D@xxxxxx Quote: > 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/i...splayLang%3den > -- > Was this helpful? Then click the Ratings button. Voting helps the web > interface. > http://www.microsoft.com/wn3/locales...eAPostAsAnswer > Mark L. Ferguson > . > > "CJ" <private@xxxxxx> wrote in message > news:20B7A98C-2758-4183-B504-EE43AA9132EC@xxxxxx Quote: >> 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....... >> >> -- >> Thanks for taking the time! >> >> CJ >> --------------------------------------------------------- >> Know thyself, know thy limits....know thy newsgroups! |
| My System Specs |
|
05-09-2008
| #4 (permalink) |
| | Re: Access 2003 database inconsistent behaviour between Vista and XP 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. -- Thanks for taking the time! CJ --------------------------------------------------------- Know thyself, know thy limits....know thy newsgroups! "George Nicholson" <GeorgeNJunk@xxxxxx> wrote in message news:u8qLubfsIHA.5872@xxxxxx Quote: > > 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 > > -- > HTH, > George > > > "Mark L. Ferguson" <MarkLFerguson@xxxxxx> wrote in > message news:3A397E3E-0E8A-483C-8178-0313CC51363D@xxxxxx Quote: >> 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/i...splayLang%3den >> -- >> Was this helpful? Then click the Ratings button. Voting helps the web >> interface. >> http://www.microsoft.com/wn3/locales...eAPostAsAnswer >> Mark L. Ferguson >> . >> >> "CJ" <private@xxxxxx> wrote in message >> news:20B7A98C-2758-4183-B504-EE43AA9132EC@xxxxxx Quote: >>> 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....... >>> >>> -- >>> Thanks for taking the time! >>> >>> CJ >>> --------------------------------------------------------- >>> Know thyself, know thy limits....know thy newsgroups! > |
| My System Specs |
|
08-01-2008
| #5 (permalink) |
| | Re: Access 2003 database inconsistent behaviour between Vista and I need this hotfix also. I have downloaded it and extracted the files. Now what? How do i install this hotfix? "CJ" wrote: Quote: > 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. > -- > Thanks for taking the time! > > CJ > --------------------------------------------------------- > Know thyself, know thy limits....know thy newsgroups! > > "George Nicholson" <GeorgeNJunk@xxxxxx> wrote in message > news:u8qLubfsIHA.5872@xxxxxx Quote: > > > > 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 > > > > -- > > HTH, > > George > > > > > > "Mark L. Ferguson" <MarkLFerguson@xxxxxx> wrote in > > message news:3A397E3E-0E8A-483C-8178-0313CC51363D@xxxxxx Quote: > >> 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/i...splayLang%3den > >> -- > >> Was this helpful? Then click the Ratings button. Voting helps the web > >> interface. > >> http://www.microsoft.com/wn3/locales...eAPostAsAnswer > >> Mark L. Ferguson > >> . > >> > >> "CJ" <private@xxxxxx> wrote in message > >> news:20B7A98C-2758-4183-B504-EE43AA9132EC@xxxxxx > >>> 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....... > >>> > >>> -- > >>> Thanks for taking the time! > >>> > >>> CJ > >>> --------------------------------------------------------- > >>> Know thyself, know thy limits....know thy newsgroups! > >> > > |
| My System Specs |
|
08-02-2008
| #6 (permalink) |
| | Re: Access 2003 database inconsistent behaviour between Vista and 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" <pcbins@xxxxxx> wrote in message news:75E2F678-47ED-4423-A17F-28E44AD2DCB8@xxxxxx Quote: >I need this hotfix also. I have downloaded it and extracted the files. Now > what? How do i install this hotfix? > > "CJ" wrote: > Quote: >> 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. >> -- >> Thanks for taking the time! >> >> CJ >> --------------------------------------------------------- >> Know thyself, know thy limits....know thy newsgroups! >> >> "George Nicholson" <GeorgeNJunk@xxxxxx> wrote in message >> news:u8qLubfsIHA.5872@xxxxxx Quote: >> > >> > 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 >> > >> > -- >> > HTH, >> > George >> > >> > >> > "Mark L. Ferguson" <MarkLFerguson@xxxxxx> wrote in >> > message news:3A397E3E-0E8A-483C-8178-0313CC51363D@xxxxxx >> >> 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/i...splayLang%3den >> >> -- >> >> Was this helpful? Then click the Ratings button. Voting helps the web >> >> interface. >> >> http://www.microsoft.com/wn3/locales...eAPostAsAnswer >> >> Mark L. Ferguson >> >> . >> >> >> >> "CJ" <private@xxxxxx> wrote in message >> >> news:20B7A98C-2758-4183-B504-EE43AA9132EC@xxxxxx >> >>> 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....... >> >>> >> >>> -- >> >>> Thanks for taking the time! >> >>> >> >>> CJ >> >>> --------------------------------------------------------- >> >>> Know thyself, know thy limits....know thy newsgroups! >> >> >> > >> > |
| My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Inconsistent window behaviour | Live Mail | |||
| Vista not opening up Access 2003 database properly, works on XP/20 | Vista General | |||
| Synchronize Access 2003 database with Windows Mobile PDA? | Vista General | |||
| Inconsistent behaviour when using set-location with different providers | PowerShell | |||
| Seemingly inconsistent behaviour | PowerShell | |||
