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 - 13 May 2008 18:24 GMT
This is a known issue with SP3. See this link;
http://support.microsoft.com/kb/945674

Signature
_________
Sean Bailey
> 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
[quoted text clipped - 13 lines]
>
> MES
Jeanette Cunningham - 14 May 2008 00:24 GMT
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
MES - 14 May 2008 13:17 GMT
Thanks a lot - that worked!
>Mes,
>there is a hot fix available.
[quoted text clipped - 21 lines]
>>
>> MES