Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / May 2008

Tip: Looking for answers? Try searching our database.

access database issues with office SP3

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MES - 13 May 2008 16:48 GMT
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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.