access database issues with office SP3

  • Thread starter MES via AccessMonster.com
  • Start date
M

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
 
J

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
 
M

MES via AccessMonster.com

Thanks a lot - that worked!



Jeanette said:
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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top