access database issues with office SP3

[MES via AccessMonster.com]

I have a database that I maintain with several forms, tables, queries, macros,
code, etc. that I maintain to keep track of employee education records for
the education dept. in a hospital. I created the database in Access 2003 SP2.
Our tech staff has begun to upgrade PC's here to Office SP3, and I am now
finding issues in my database as a result of this. For example, I have a
report that upon opening launches a form with a dropdown list to choose and
employee - this report shows that employee's record. With SP3, when I launch
that form, the dropdown where the employee names are listed (linked to the
Employee table) does not have any records in it, where with SP2 this drop-
down is populated with the names from the Employee table.

Has anyone had any experience with this? Is there any way to upgrade to SP3
while at the same time maintaining the integrity of the database?

Thanks in advance for any assistance.

MES

 

[Beetle]

This is a known issue with SP3. See this link;

http://support.microsoft.com/kb/945674

 

[Jeanette Cunningham]

Mes,
there is a hot fix available.

"Combo box controls and list box controls display no value or
incorrect values in Access 2003 after you install Office 2003 Service
Pack 3." And a few more problems SP3 introduced.

Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007 - 945674

http://support.microsoft.com/kb/945674

If the field to which the combo box is bound has a Format property setting
for the field in the table, then yes, this is a bug that has been reported
by many ACCESS users during past weeks. It apparently is a bug in Office
2003 SP3, which was released by MS a short time ago. MS is aware of the
bug and is working on how to fix it.

In the meantime, the "complete workaround" is to remove the Format
property's value from the field's properties in the table's design view

Jeanette Cunningham -- Melbourne Victoria Australia

 

[MES via AccessMonster.com]

Thanks a lot - that worked!

Mes,
there is a hot fix available.

"Combo box controls and list box controls display no value or
incorrect values in Access 2003 after you install Office 2003 Service
Pack 3." And a few more problems SP3 introduced.

Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007 - 945674

http://support.microsoft.com/kb/945674

If the field to which the combo box is bound has a Format property setting
for the field in the table, then yes, this is a bug that has been reported

[quoted text clipped - 4 lines]

In the meantime, the "complete workaround" is to remove the Format
property's value from the field's properties in the table's design view

Jeanette Cunningham -- Melbourne Victoria Australia

I have a database that I maintain with several forms, tables, queries,
macros,

[quoted text clipped - 18 lines]

MES