Access Junkie KB Articles

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

My apologies for not including bookmarks to jump down to the page areas, but Office Live currently does not support bookmarks.

Access/Office Service Pack 1

How to obtain the latest service pack for the 2007 Office suite
http://support.microsoft.com/kb/949585/en-us

Description of the 2007 Microsoft Office suite Service Pack 1:
http://support.microsoft.com/default.aspx?scid=kb;en-us;936982&sd=rss&spid=11265

You are prompted unexpectedly to restart the computer after you install a 2007 Office service pack or a 2007 Office update:
http://support.microsoft.com/default.aspx?scid=kb;en-us;942995&sd=rss&spid=11265

Error message when you try to open a compiled database file or a compiled project file in Access 2007: "This database is in an unrecognized format":
http://support.microsoft.com/default.aspx?scid=kb;en-us;946205&sd=rss&spid=11265

Description of Office 2003 Web Components Service Pack 1 for the 2007 Office system:
http://support.microsoft.com/default.aspx?scid=kb;en-us;937961&sd=rss&spid=11265

Issues that are fixed in Access 2007 by the 2007 Microsoft Office suites Service Pack 1:
http://support.microsoft.com/default.aspx?scid=kb;en-us;942378&sd=rss&spid=11265

You receive an error message when you try to apply any of the 2007 Office Service Pack 1 packages on a computer that is running Windows XP Service Pack 2:
http://support.microsoft.com/default.aspx?scid=kb;en-us;942101&sd=rss&spid=11265

Hot Fixes

Description of the Access 2007 hotfix update: March 31, 2008:
http://support.microsoft.com/kb/950488/en-us

Description of the Access 2007 hotfix package: March 22, 2008
http://support.microsoft.com/kb/950277/en-us

Description of the Access 2007 hotfix package: March 15, 2008:
http://support.microsoft.com/kb/949946/en-us

Description of the Access 2007 hotfix package: March 6, 2008

http://support.microsoft.com/kb/949404/en-us

Description of the Access 2007 hotfix package: February 26, 2008
http://support.microsoft.com/kb/941877/en-us

Description of the 2007 Office hotfix package: February 26, 2008
http://support.microsoft.com/kb/948950/en-us

Description of the Access 2007 hotfix package: January 28, 2008
http://support.microsoft.com/kb/943249/en-us

Description of the security update for the 2007 Office system and for the Compatibility Pack for the 2007 Office system: July 10, 2007:

http://support.microsoft.com/default.aspx?scid=kb;en-us;936514&sd=rss&spid=11265

Description of the Access 2007 hotfix package: June 24, 2007:
http://support.microsoft.com/default.aspx?scid=kb;en-us;939185&sd=rss&spid=11265

Description of the 2007 Office hotfix package: June 17, 2007:

http://support.microsoft.com/default.aspx?scid=kb;en-us;938888&sd=rss&spid=11265

Underlined Japanese characters print without the underline in Windows Vista: June 20, 2007:

http://support.microsoft.com/kb/936176/en-us

Description of the security update for the 2007 Office system: May 8, 2007:
http://support.microsoft.com/kb/934062/en-us

Access may stop responding when you open a remote database on Vista: May 3, 2007
http://support.microsoft.com/kb/935366/en-us

Description of the Access 2007 hotfix package: April 27, 2007:
http://support.microsoft.com/kb/936519/en-us

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.

Description of the Access 2007 hotfix package: April 11, 2007:
http://support.microsoft.com/kb/935875/en-us

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.

Description of the update for the 2007 Office programs: April 9, 2007:
http://support.microsoft.com/kb/932080/en-us

Description of the Access 2007 hotfix package: April 8, 2007
http://support.microsoft.com/kb/935521/en-us

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.

Table Design Issues

1. You may experience slow performance when you view records in a table that contains a lookup field in Access 2007:
http://support.microsoft.com/kb/918575/en-us

2. When you change the value of the Append Only property to No for a Memo field in a table, the column history for the Memo field is lost in Access 2007:
http://support.microsoft.com/kb/924678/en-us

3. The ID field is increment by one every time that you add a field to a new table in Datasheet view in Access 2007:
http://support.microsoft.com/kb/924741/en-us

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

5. A decimal value in a column is rounded up or down to an integer value in Access 2007:
http://support.microsoft.com/kb/920359/en-us

6. Records that do not match the filter criteria in an Access 2007 linked table may be returned when you use selection filtering or the "AutoFilter" menu:
http://support.microsoft.com/kb/924743/en-us

7. The filter criteria on a multivalued field are not displayed after a filter is applied in Access 2007:
http://support.microsoft.com/kb/926701/en-us

8. Error message when you try to add a new item value to a linked table in Access 2007: "Invalid argument":
http://support.microsoft.com/kb/926534/en-us

9. You may receive an error message when you try to insert a new record in a table that contains an Autonumber field in Access 2007:
http://support.microsoft.com/kb/884185/en-us

Query Issues

1. Error message when you run a query in Access 2007: "System Resource Exceeded" or "Query is too complex":
http://support.microsoft.com/kb/918814/en-us

2. A query may return corrupted data for Memo fields when you run the query against a SharePoint list in Access 2007:
http://support.microsoft.com/kb/918811/en-us

3. A new empty row is added to the One table when you add a row to the Many table of an updatable One-to-Many query in Access 2007:
http://support.microsoft.com/kb/928023/en-us

4. Update query or delete query may not succeed in Access if the query reads data from a linked-text file:
http://support.microsoft.com/kb/824159/en-us

5. Access 2007 stops responding when you design a query in Design view
http://support.microsoft.com/kb/949689/en-us

Form - Report Issues

1. The document tab order changes when you change the view of a form from Split Form view to Design view in Access 2007:
http://support.microsoft.com/kb/918813/en-us

2. The section height increases when you add a line control to the section in Access 2007:
http://support.microsoft.com/kb/932492/en-us

3. You cannot add to an image control an image file that has a .cdr, .cgm, .pct, or .wpg file name extension in Access 2007:
http://support.microsoft.com/kb/918810/en-us

4. The "Group On" option does not appear in the shortcut menu for lookup fields when you create a report in an .mdb file in
Access 2007:
http://support.microsoft.com/kb/918808/en-us

5. The status bar displays a flashing message or displays alternate messages when you apply a filter to a subreport in Access
2007: "Calculating," "Ready," or another status:
http://support.microsoft.com/kb/927152/en-us

6. A "MISSING: =[Argument]" object dependency is reported for a switchboard form in Access 2007:
http://support.microsoft.com/kb/926703/en-us

7. The field order in a form differs from the field order in a record source in Access 2007:
http://support.microsoft.com/kb/926957/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

9. The data in a report or in a form is not updated in Access 2007
http://support.microsoft.com/kb/918576/en-us

10. Access 2007 may close unexpectedly when you try to change the Control Source property for a control that is on a report or on a form in Layout view:
http://support.microsoft.com/kb/927536/en-us

11. The subform appears to be blank after you close a Filter by Form view without applying the filter in Access 2007:
http://support.microsoft.com/kb/926956/en-us

12. How to fill a list box or a combo box with database object names:
http://support.microsoft.com/kb/280372/en-us

13. Description of the expressions to count yes, no, and other responses in Access:
http://support.microsoft.com/kb/209505/en-us

14. You receive an error message when you run a query that includes a field name that begins with a double-byte Arabic number in Access 2007 or Access 2003:

http://support.microsoft.com/default.aspx?scid=kb;en-us;932994&sd=rss&spid=11265

15. A report does not open in Snapshot Viewer after you export the report to snapshot format in Access 2007:
http://support.microsoft.com:80/kb/928357/

Macro Issues

1. Error message when you run a macro that calls a VBA function in an Access 2007 database: "Action Failed Error Number: 2950":
http://support.microsoft.com/kb/931407/en-us

2. Error message when you run a macro to search for a file in an Office 2007 program: "Run-time error 5111":
http://support.microsoft.com/kb/920229/en-us

3. The Navigation Pane is not displayed when you use the NavigateTo action and then call the WindowUnhide RunCommand action in Access 2007:
http://support.microsoft.com/kb/924680/en-us

Coding/DAO/Modules

1. Error message when you create a DAO workspace in a module in Access 2007: "Runtime error 3633":
http://support.microsoft.com/kb/928025/en-us

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

3. Error message when you try to run the FileSearch function in Access 2007: "You entered an expression that has an invalid reference to the property FileSearch":
http://support.microsoft.com/kb/935402/en-us

4. How to use the Command Dialog API in a database in Access 2003 or Access 2007:
http://support.microsoft.com/kb/888695/en-us

Navigation Issues

1. The title bar does not display the name or the caption of the current object when Access 2007 is set to SDI mode:
http://support.microsoft.com/kb/924742/en-us

2. Location of the toolbar file for the Quick Access Toolbar for the 2007 Microsoft Office programs:
http://support.microsoft.com/kb/926805/en-us

3. Screen reader applications read attachment data type fields as "G" in Access 2007:
http://support.microsoft.com/kb/924740/en-us

4. You can select the options in all sections of the Microsoft Office Security Options dialog box only one time if the dialog box contains two or more sections in Access 2007:
http://support.microsoft.com/kb/918580/en-us

5. The Undo list is cleared when you click "Enable Content" in Access 2007:
http://support.microsoft.com/kb/922076/en-us

6. How to access workbooks that contain menu and toolbar commands for the 2007 Office programs through Office Offline:
http://support.microsoft.com/kb/928027/en-us

7. Another button on the Ribbon may become active when you use a keyboard shortcut that uses the ALT key in 2007 Office programs :
http://support.microsoft.com/kb/926363/en-us

8. KeyTips do not appear when you press the ALT key in a 2007 Office program:
http://support.microsoft.com/kb/926364/en-us

9. Narrator does not read a Help topic when you press CTRL+SHIFT+SPACEBAR in a 2007 Office program:
http://support.microsoft.com/kb/926800/en-us

10. Text is missing in the description of the Enable Customer Experience Improvement Program setting in the Office Customization Tool in the 2007 Office system:
http://support.microsoft.com/kb/931400/en-us

11. The Search text box continues to appear in an Access 2007 database after you click to clear the "Show Search Bar" check box:
http://support.microsoft.com/kb/928300/en-us

Import - Export Issues

1. A report does not open in Snapshot Viewer after you export the report to snapshot fomat in Access 2007:

http://support.microsoft.com/kb/928357/en-us

2. You cannot change, add, or delete data in tables that are linked to an Excel workbook in Office Access 2007, Office Access 2003, or Access 2002:
http://support.microsoft.com/kb/904953/en-us

3. Your XML data may appear to incorrectly import when you try to import that data to Microsoft Office Access 2003 or Microsoft Office Access 2007:
http://support.microsoft.com/kb/887035/en-us

4. You cannot specify the table in an Access 2007 database into which you want to import an XML file:
http://support.microsoft.com/kb/918579/en-us

5. Error message when you try to programmatically export a Microsoft Graph object in Access 2007: "Run-time error 1004: Application-defined or object-defined error":
http://support.microsoft.com/kb/926429/en-us

6. Access causes an error when you export fields with data type single or double to Oracle:
http://support.microsoft.com/kb/301915/en-us

7. Error message when you try to export an Access 2007 table that contains more than 65,000 rows to an Excel workbook: "You selected more records than can be copied":
http://support.microsoft.com/kb/924681/en-us

8. You cannot export a report to an Excel format in Access 2007:
http://support.microsoft.com/kb/934833/en-us

Installation - Uninstall Issues

1. The Web Datasheet Component in Access 2007 is not completely uninstalled:
http://support.microsoft.com/kb/926709/en-us

2. Error message when you try to run Access 2007: "Can't find the database you specified":
http://support.microsoft.com/kb/926527/en-us

3. How to register or unregister ActiveX controls in Access 2007:
http://support.microsoft.com/kb/918574/en-us

4. Error message when you try to open a wizard in Access 2007: "This feature isn’t installed, or has been disabled":
http://support.microsoft.com/kb/924738/en-us

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

6. You are prompted to upgrade or customize an earlier version of Office when you try to install a 2007 Office suite or program:
http://support.microsoft.com/kb/927157/en-us

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

8. You receive a message when you try to start a 2007 Office program: "Your beta software has expired":
http://support.microsoft.com/kb/924613/en-us

9. Description of the Local Install Source feature in 2007 Office programs:
http://support.microsoft.com/kb/924616/en-us

10. An earlier version of an Office program may not be removed when you install a 2007 Office program:
http://support.microsoft.com/kb/926799/en-us

11. Chained commands do not run after the installation of a 2007 Office suite or program fails:
http://support.microsoft.com/kb/928467/en-us

12. How to change the company name and user name in 2007 Office programs:
http://support.microsoft.com/kb/924461/en-us

13. The "Full Name" and "Organization" information is automatically populated when you install 2007 Office programs:
http://support.microsoft.com/kb/924612/en-us

14. 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-us

15. How to install and to repair 2007 Office features:
http://support.microsoft.com/kb/924611/en-us

16. An East Asian language or a Complex Script language may be unavailable on the Languages tab in the Setup program of a 2007 Office suite or program:
http://support.microsoft.com/kb/926706/en-us

17. 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-us

18. Error message when you try to install the original release version of a 2007 Office suite or program: "Setup is unable to proceed":
http://support.microsoft.com/kb/927222/en-us

19. The installation state of a shared Office component in an installed 2007 Office program is not reflected in the Setup program of a second installed 2007 Office program:
http://support.microsoft.com/kb/926531/en-us

20. Setup program crashes when you try to install a 2007 Office suite on a 64-bit version of Windows Server 2003:
http://support.microsoft.com/kb/927476/en-us

21. How to change the product key for Office XP, for Office 2003, and for 2007 Office programs and suites:
http://support.microsoft.com/kb/895456/en-us

22. How to use the repair process in the 2007 Office programs:
http://support.microsoft.com/kb/924614/en-us

23. How to troubleshoot problems that you may experience when you try to activate a 2007 Office product:
http://support.microsoft.com/kb/919895/en-us

24. 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-us

25. No progress occurs in the "Installation Progress" dialog box when you install the 2007 Office system or a stand-alone 2007 Office product:

http://support.microsoft.com/kb/937680/en-us

26. Error message when you try to install an Access 2003 add-in for all users by using the Add-In Manager on a Windows Vista-based computer: "There was an error adding to the registry." (Also applies to Access 2007 I believe):

http://support.microsoft.com/default.aspx?scid=kb;en-us;938809&sd=rss&spid=11265

27. When you view any 2007 Office system Service Pack 1 update under "Add or Remove Programs" in Control Panel, the title of the update contains garbage characters:

http://support.microsoft.com/default.aspx?scid=kb;en-us;943081&sd=rss&spid=11265

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

29. Security-related Group Policy settings in the 2007 Office system do not work as expected:

http://support.microsoft.com/kb/946621/en-us

30. Error message when you try to install the Access 2007 Runtime: "Access 2007 Runtime: Another version of this product is already installed":
http://support.microsoft.com/kb/951182/en-us

Conversion Issues

1. Cannot open or convert an Access 97 or Access 2000 database in Access 2002, in Access 2003, or in Access 2007:
http://support.microsoft.com/kb/310937/en-us

2. You may receive an error message when you convert a database from an earlier version of Access to Access 2002, to Access 2003, or to Access 2007:
http://support.microsoft.com/kb/324350/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

4. Some of the programs and tools from an earlier Office suite are still installed after you upgrade to a 2007 Office suite:
http://support.microsoft.com/kb/924620/en-us

5. Shortcuts from an earlier version of Office still appear on the Start menu after you upgrade to a 2007 Office program or suite:
http://support.microsoft.com/kb/924746/en-us

6. The Access Replication Wizard COM add-in may appear as #401 in Access 2007:
http://support.microsoft.com/kb/928024/en-us

7. Some Office 2003 proofing tools may not behave as expected in 2007 Office program:
http://support.microsoft.com/kb/922383/en-us

8. Error message when you convert a database file from an earlier version of Access into an Access 2007 file: "Run-time error '13': Type mismatch":
http://support.microsoft.com/kb/927678/en-us

ADP - SQL Server Issues

1. You receive the "SQL Server does not exist or access denied" error message when you specify a nonexistent server name in the ADP connection information:
http://support.microsoft.com/kb/275118/en-us

2. Form or report that is bound to a stored procedure or a function does not apply the WHERE condition:
http://support.microsoft.com/kb/275089/en-us

Data Collection Issues

1. You cannot process a data collection e-mail reply when the query that the e-mail was based on contains an Access 2007-defined
function:
http://support.microsoft.com/kb/918584/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-us

2. Error message when you try to add an existing Windows SharePoint Services list to an Access 2007 database: "You do not have the necessary permissions to use the '' object":
http://support.microsoft.com/kb/924739/en-us

3. The data of the primary key column is not in the Data View of a SharePoint list when you export a table in Access 2007:
http://support.microsoft.com/kb/926524/en-us

4. 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-us

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

6. Tables display ID numbers when you import a Windows SharePoint Services list that contains a multivalue lookup column in Access 2007:
http://support.microsoft.com/kb/918809/en-us

7. Error message when you try to open a linked SharePoint table in Access 2007: "The Microsoft Office Access database engine could not find the object":
http://support.microsoft.com/kb/926526/en-us

8. The data in a SharePoint list differs from the data in an Access 2007 table when you export the table from Access 2007 to a SharePoint list:
http://support.microsoft.com/kb/926710/en-us

Security Issues

1. How to use the Workgroup Administrator utility in Access 2007:
http://support.microsoft.com/kb/918583/en-us

2. You are not prompted to save a password when you link to an encrypted Access 2007 database:
http://support.microsoft.com/kb/926802/en-us

3. You cannot open the front-end database when the back-end database is encrypted by using a password in Access 2007:
http://support.microsoft.com/kb/926533/en-us

4. How to disable hyperlink warning messages in 2007 Office programs:
http://support.microsoft.com/kb/925757/en-us

5. How to use SetOption to disable warning messages in an Access Application:
http://support.microsoft.com/kb/229802/en-us

6. You are prompted for a username and for a password even though you do not turn on security or set up security in Access:
http://support.microsoft.com/kb/888734/en-us

7. Access may stop responding when you try to create an MDE or ACCDE file, or an ADE file:
http://support.microsoft.com/kb/814858/en-us

Misc

1. You receive an error message when you try to open an Access 2007 database file that is stored in an Access 2007 OLE Object field:
http://support.microsoft.com/kb/924737/en-us

2. The change is not applied until you reopen the database when you change a setting in Access 2007:
http://support.microsoft.com/kb/919743/en-us

3. Help content may not appear as expected in 2007 Office programs:
http://support.microsoft.com/kb/926426/en-us

4. The parent database is disabled and you do not receive a notification message when you add a reference to a different database in Access 2007:
http://support.microsoft.com/kb/920275/en-us

5. Error message when two different users try to change the same record in a Microsoft Access 2007 database: "Could not update; currently locked":
http://support.microsoft.com/kb/918578/en-us

6. Slow performance on linked tables in Access 2002, in Office Access 2003, and in Office 2007:
http://support.microsoft.com/kb/275085/en-us

7. How to determine which version of a 2007 Office product is installed:
http://support.microsoft.com/kb/928116/en-us

8. How to clear the list of recently used files in 2007 Office programs:
http://support.microsoft.com/kb/926535/en-us

9. The words "Friendster," "Klum," "Nazr," "Obama," and "Racicot" are not recognized when you check the spelling of English-language text in the 2007 Office programs:
http://support.microsoft.com/kb/933699/en-us

10. How to use the Alert ID feature in the 2007 Office programs when you search for a warning or an error message in the Microsoft Knowledge Base:
http://support.microsoft.com/kb/928723/en-us

11. Error message when you try to split a database by using the Database Splitter in Microsoft Office Access 2007: "Could not lock file":
http://support.microsoft.com/kb/918812/en-us

12. How to start MSBackup.exe from Microsoft Access:
http://support.microsoft.com/kb/302891/en-us

13. Fonts in a 2007 Office program may not appear as clear as expected:
http://support.microsoft.com/kb/926705/en-us

14. The 2007 Office spelling checker incorrectly flags words that use initial capitalization after you accept a French spelling reform-related suggestion:
http://support.microsoft.com/kb/929356/en-us

15. How to manage templates in 2007 Office programs:
http://support.microsoft.com/kb/924460/en-us

16. The Access 2007 Developer Extensions command is missing from the Microsoft Office Button in Access 2007:

http://support.microsoft.com/kb/937998/en-us

17. How to create legacy Office files in the 2007 Office system:

http://support.microsoft.com/kb/935787/en-us

18. How to determine the version of an installed 2007 Office language pack:

http://support.microsoft.com/kb/945598/en-us

Access Junkie - MVP Alumni - SDET XAS