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
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