Access 2007 Knowledge Base Articles
Listed below are Knowledge Base articles that pertain to Access 2007. This list most likely does not include all KB articles concerning Access 2007, so be sure to check Microsoft's site if you do not find what you need here.
These articles are divided up into the following categories:
Access/Office Service Pack 2
Access/Office Service Pack 1
Hot Fixes
Table Design Issues
Query Issues
Form - Report Issues
Macro Issues
Coding/DAO/Modules
Navigation Issues
Import - Export Issues
Installation - Uninstall Issues
Conversion Issues
ADP - SQL Server Issues
Data Collection Issues
Windows SharePoint Services Issues
Security Issues
Misc
Access/Office Service Pack 2
Access/Office Service Pack 1
Issues that this hotfix package fixes:
This hotfix fixes the following issues that are not previously documented in a Microsoft Knowledge Base article:
• In Access 2007, you create a form by specifying the following property values:
Property Value
Modal Yes
Pop Up Yes
Auto Resize No
Then, you update the record source of the form. When you open the form by using a macro, the form opens in a small reduced mode.
• When you export a report to an .rft file in Access 2007, the export process is very slow compared to the same process in Access 2003.
• You create a macro by specifying the RunMacro action in Access 2007. You specify the Repeat Expression parameter of the RunMacro action to run a second macro at least two times. The second macro contains the StopMacro action. When you run the macro and the second macro stops running because of the StopMacro action, the macro also stops running, even if the expression evaluates to True. However, in Access 2003, the macro stops for the current iteration, and then continues to run until the expression evaluates to False.
• You have a text file that contains a column of date values that are not delimited. When you try to link to the text file or import the column from Access 2007, you encounter the following problems:• If you link to the text file by specifying the column as the Date/Time data type, the column values are displayed as #Num! in Access 2007.
• If you import the column by specifying the column as the Date/Time data type, the column values are not imported. In the ImportErrors table, you receive the following error message on the Error column:
Type Conversion Failure.
• Consider the following scenario. You create a form in Access 2007. You also create two subforms that are bound to queries or to stored procedures in Microsoft SQL Server. Additionally, Access 2007 populates data into the subforms by using parameter values. The first subform also sets the parameter value of the second subform. You update the first subform. In this scenario, the second subform does not update.
Note: This problem does not occur in Access 2003.
• You create some linked tables in an Access 2007 database. Additionally, you create a form and add controls that display data from the linked tables. When you operate on these controls, you experience very slow performance compared to Access 2003.
Note: This problem does not occur if you use imported tables.
Issues fixed in this package:
In Access 2007, you create a query that does not contain parameter. When you export the query to a Microsoft Office Excel Worksheet, the Enter Parameter Value dialog box opens.
• When you open a chart object in Access 2007 on a computer that is running Windows Vista or Windows Server 2008, you see a blank chart.
• After you upgrade Access 2003 to Access 2007, operations on existing forms have slow performance.
• You cannot use the SetValue macro in the click events of a Button control to set the Locked property of a Check Box control in Access 2007.
• You have a printer that has the staple feature. When you print an object in multiple copies in Access 2007, all these copies are stapled as one unit. However, you expect that each copy is stapled individually.
ADP Performance:
When you try to run a Microsoft Access project (.adp) in Access 2007, the project may run slowly. Or, the project may take longer than expected to respond to actions that are performed on the project.
Sub form short-cut menu:
In Access 2007, you open a Microsoft Office Access 2003 database that contains a custom shortcut menu for a subform. Then, you right-click the subform. When you do this, the default shortcut menu is displayed instead of the custom shortcut menu.
DAO synchronize a replicated db:
When you try to use Data Access Object (DAO) code to synchronize a replicated Access 2007 database, you receive the following error message:
Run-time error '3251':
Operation is not supported for this type of object.
4. Error message in Access 2007 when you try to open a table or a query in design mode in a database that is from an earlier version of Access: "The expression you entered refers to an object that is closed or doesn't exist":
http://support.microsoft.com/kb/926700/en-us
8. You cannot select any options in an Option Group control that is on a Rectangle control after you set the Back Style property to Normal for the Rectangle control and for the Option Group control in Access 2007:
http://support.microsoft.com/kb/926713/en-us
Coding/DAO/Modules Issues
2. Error message when you compile a module or when you run a procedure in Access 2007: "Your Microsoft Office Access database or
project contains a missing or broken reference to the file":
http://support.microsoft.com/kb/921504/en-us
Installation - Uninstall Issues
5. Error message when you try to start a 2007 Office program that was preinstalled on the computer: "You do not have a valid Microsoft Office 2007 license to use this application":
http://support.microsoft.com/kb/932122/en-us7. Error message when you try to install the 2007 Office programs after you remove a prerelease version of the 2007 Office programs: "Error 1923: Service 'Office Source Engine' (ose) could not be installed":
http://support.microsoft.com/kb/926704/en-us14. Error message after you remove the beta release version of a 2007 Office suite or program and then try to install the original release version of a 2007 Office suite or program: "Setup is unable to proceed":
http://support.microsoft.com/kb/928218/en-us17. Installation fails, and you receive an error message when you try to install a 2007 Office suite or a 2007 Office program by double-clicking an .msi file: "Error 1713" or "MSI Error 41":
http://support.microsoft.com/kb/926279/en-us24. Help content does not appear when you click "Help" during the setup of a 2007 Office program on a computer that is running a 64-bit version of Windows XP or of Windows Vista:
http://support.microsoft.com/kb/926707/en-us28. An alternative installation source is not entered in the Windows registry as expected when you modify the SOURCELIST element in the Config.xml file in the 2007 Office system:
http://support.microsoft.com/kb/948309/en-us
3. You receive a "You are trying to open a read-only database" error message when you open a database that was created in an earlier version of Access in Access 2002, Access 2003 or Access 2007:
http://support.microsoft.com/kb/324666/en-us
Windows SharePoint Services Issues
1. Error message when you try to use data from an Excel 2007 workbook or from an Access 2007 database to create a new list in
Windows SharePoint Services 3.0: "An unexpected error has occurred":
http://support.microsoft.com/kb/923591/en-us4. Error messages when you try to use Access 2007 to open a runtime mode database file in a Windows SharePoint Services 3.0 document library: "Microsoft Office Access cannot open this file":
http://support.microsoft.com/kb/926803/en-us5. When you open a SharePoint list on the Windows SharePoint Services Web site in Internet Explorer, either the primary key field is blank, or the whole list is blank in Access 2007:
http://support.microsoft.com/kb/926702/en-us