Access 2007 articles, fixes and updates - April 2018

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Access 2007 that have been released in April 2018. The list is daily updated.

• 949404 Description of the Access 2007 hotfix package: March 6, 2008 Q949404 KB949404 April 23, 2018
• 935370 Issues that you may encounter when you open or are using a Microsoft Office Access database on a computer that is running Windows Vista Q935370 KB935370 April 23, 2018
• 924678 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 Q924678 KB924678 April 23, 2018
• 888634 You receive the "The database is in an unexpected state" error message when you try to open a database in Access 2000 or a later version of Access Q888634 KB888634 April 23, 2018
• 824271 Description of troubleshooting corruption in an Office Access 2003 database Q824271 KB824271 April 23, 2018
• 300693 How to dynamically set the input parameters of a report at run time in an ADP Q300693 KB300693 April 23, 2018
• 286828 How to implement Query by Form (QBF) in an Access project Q286828 KB286828 April 23, 2018
• 284286 How to reset changes to the Application.Printer object Q284286 KB284286 April 23, 2018
• 283228 Exclusive lock is required for saving design changes to Access objects in Access Q283228 KB283228 April 23, 2018
• 283200 How Access projects (ADPs) use the DefaultMaxRecords setting and the T-SQL Set Rowcount statement Q283200 KB283200 April 23, 2018
• 209571 Error message when you try to update a record on a form in an Access database: "This Recordset is not." Q209571 KB209571 April 23, 2018
• 924738 Error message when you try to open a wizard in Access 2007: "This feature isn’t installed, or has been disabled" Q924738 KB924738 April 22, 2018
• 923718 How to troubleshoot a failed installation of the Beta 2 Technical Refresh update for 2007 Microsoft Office suites Q923718 KB923718 April 22, 2018
• 835413 Missing clips appear with the title Dglxasset.aspx when you search for clips in Office Q835413 KB835413 April 22, 2018
• 287685 How to concatenate fields in a text box to remove blank lines Q287685 KB287685 April 22, 2018
• 287661 Description of hints for printing mailing labels Q287661 KB287661 April 22, 2018
• 275089 Form or report that is bound to a stored procedure or a function does not apply the WHERE condition Q275089 KB275089 April 22, 2018
• 239930 How to obtain built-in constant values for an Office application Q239930 KB239930 April 22, 2018
• 926946 Error message when you try to install a 2007 Office update package: "The installation of this package failed" Q926946 KB926946 April 21, 2018
• 2184729 ACC: “Setup is configuring Access” message is received each time Access is launched Q2184729 KB2184729 April 20, 2018
• 951339 Error message when you try to open the Office Customization Tool: "Files necessary to run the Office Customization Tool were not found" Q951339 KB951339 April 20, 2018
• 937680 No progress occurs in the "Installation Progress" dialog box when you install the 2007 Office system or a stand-alone 2007 Office product Q937680 KB937680 April 20, 2018
• 927476 Setup program crashes when you try to install a 2007 Office suite on a 64-bit version of Windows Server 2003 Q927476 KB927476 April 20, 2018
• 924461 How to change the company name and user name in 2007 Office programs Q924461 KB924461 April 20, 2018
• 289508 How to view error signatures if an Office program experiences a serious error and quits Q289508 KB289508 April 20, 2018
• 957570 The Microsoft OLE DB Provider for Jet and the Microsoft Access ODBC driver are available in 32-bit versions only Q957570 KB957570 April 19, 2018
• 934833 Unless you install the Office 2007 suite Service Pack 2, you cannot export a report to an Excel format in Access 2007 Q934833 KB934833 April 19, 2018
• 918578 Error message when two different users try to change the same record in a Microsoft Access 2007 database: "Could not update; currently locked" Q918578 KB918578 April 19, 2018
• 888635 You receive a "No current record" error message when you try to print or preview a report, and then you move between pages of the report in Access Q888635 KB888635 April 19, 2018
• 824278 You must use an exclusive lock to save design changes to database objects in Access 2003 Q824278 KB824278 April 19, 2018
• 306881 How to programmatically change the connection of a Microsoft Access project Q306881 KB306881 April 19, 2018
• 301915 Access causes an error when you export fields with data type single or double to Oracle Q301915 KB301915 April 19, 2018
• 297373 Logon errors occur when you connect to a SQL Server database from a Microsoft Access project Q297373 KB297373 April 19, 2018
• 290178 How to create a query that has parameters to evaluate complex criteria in Microsoft Access Q290178 KB290178 April 19, 2018
• 289670 How to synchronize two combo boxes on a form in Microsoft Access Q289670 KB289670 April 19, 2018
• 289659 Error updating a field when you add a new record to a form Q289659 KB289659 April 19, 2018
• 286335 List of reserved words in Access 2002 and in later versions of Access Q286335 KB286335 April 19, 2018
• 283874 How to find a record using ADO and Jet OLE DB provider Q283874 KB283874 April 19, 2018
• 275068 Column format on a Microsoft Excel worksheet is lost or changed when you import or link data from Excel Q275068 KB275068 April 19, 2018
• 209849 How to loop through the references to view their properties in Microsoft Access Q209849 KB209849 April 19, 2018
• 209215 How to reset the page number on a group level in an Access report Q209215 KB209215 April 19, 2018
• 2591039 Technical details about the 2007 Office system SP3 releases Q2591039 KB2591039 April 18, 2018
• 936982 Description of the 2007 Microsoft Office suite Service Pack 1 Q936982 KB936982 April 18, 2018
• 935402 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" Q935402 KB935402 April 18, 2018
• 932492 The section height increases when you add a line control to the section in Access 2007 Q932492 KB932492 April 18, 2018
• 928516 Description of product code GUIDs in 2007 Office suites and programs Q928516 KB928516 April 18, 2018
• 926705 Fonts in a 2007 Office program may not appear as clear as expected Q926705 KB926705 April 18, 2018
• 924681 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" Q924681 KB924681 April 18, 2018
• 924617 How administrators can use Office policy templates together with the Group Policy settings of Windows Q924617 KB924617 April 18, 2018
• 924284 How to enable the Memory Diagnostic test for 2007 Office products on a Windows Server-based computer Q924284 KB924284 April 18, 2018
• 918583 How to use the Workgroup Administrator utility in Access 2007 Q918583 KB918583 April 18, 2018
• 918574 How to register or unregister ActiveX controls in Access 2007 Q918574 KB918574 April 18, 2018
• 891176 Slower performance in Access-based or Jet database-based programs after you upgrade from Windows NT 4.0 to Windows 2000 or to Windows XP Q891176 KB891176 April 18, 2018
• 888695 How to use the Common Dialog API in a database in Access 2003 or Access 2007 Q888695 KB888695 April 18, 2018
• 828958 Resources to help you activate a license in Microsoft Office programs Q828958 KB828958 April 18, 2018
• 826766 How to make a change to dates by using functions and operators in Access Q826766 KB826766 April 18, 2018
• 824264 You cannot connect directly to FoxPro databases in Access 2007 and in Access 2003 Q824264 KB824264 April 18, 2018
• 824255 How Access resolves Visual Basic for Applications references Q824255 KB824255 April 18, 2018
• 815282 How to convert data values of the Text data type to the proper case format in Microsoft Access Q815282 KB815282 April 18, 2018
• 812719 How to programmatically create a new column in an Access report Q812719 KB812719 April 18, 2018
• 319317 How to automate the process of selecting the printer for a report in Microsoft Access Q319317 KB319317 April 18, 2018
• 315041 Cannot access the Internet with ZoneAlarm or ZoneAlarm Pro installed after you upgrade to a later version of Office Q315041 KB315041 April 18, 2018
• 310937 Cannot open or convert an Access 97 or Access 2000 database in Access 2002, in Access 2003, or in Access 2007 Q310937 KB310937 April 18, 2018
• 308312 How to use Application roles with Access projects and SQL Server 2000 Desktop Edition Q308312 KB308312 April 18, 2018
• 304932 How to manually split a Access database in Microsoft Access Q304932 KB304932 April 18, 2018
• 304408 How to shut down a custom Access application remotely Q304408 KB304408 April 18, 2018
• 304323 How to use ADOX to create an SQL pass-through query in Access Q304323 KB304323 April 18, 2018
• 304302 How to build a dynamic query with values from a search form in Access 2007, in Access 2003, or in Access 2002 Q304302 KB304302 April 18, 2018
• 304104 How to programmatically apply conditional formatting settings to all form controls Q304104 KB304104 April 18, 2018
• 302525 Error message when you enter a large amount of text in a Memo field that contains an index in Access: "Run-time error '3709'" Q302525 KB302525 April 18, 2018
• 301595 No records are displayed when you merge data with Microsoft Word Q301595 KB301595 April 18, 2018
• 294552 Error message in Access: "Microsoft Access couldn't print your object" Q294552 KB294552 April 18, 2018
• 292799 How the Table Analyzer Wizard works Q292799 KB292799 April 18, 2018
• 292491 Office automation when multiple versions of Office are installed Q292491 KB292491 April 18, 2018
• 292461 How to use Visual Basic code to collate and to print two reports Q292461 KB292461 April 18, 2018
• 290623 How to attach an existing SQL Server 2000 Database to SQL Server 2000 Desktop Engine Q290623 KB290623 April 18, 2018
• 290190 How to create two functions to calculate age in months and in years in Microsoft Access Q290190 KB290190 April 18, 2018
• 289675 You cannot add records or delete records with the ADO AddNew method or with the Delete method Q289675 KB289675 April 18, 2018
• 289562 How to prevent database bloat after you use Data Access Objects (DAO) Q289562 KB289562 April 18, 2018
• 288631 Defragment and compact database to improve performance in Microsoft Access Q288631 KB288631 April 18, 2018
• 287756 AutoNumber field is not reset after you compact an Access database Q287756 KB287756 April 18, 2018
• 287668 How to use SQLConfigDataSource to create an Access system DSN Q287668 KB287668 April 18, 2018
• 286222 How to optimize Microsoft Access when using ODBC data sources Q286222 KB286222 April 18, 2018
• 285829 How to use data transformation services (DTS) to export data from a Microsoft Access database to an SQL Server database Q285829 KB285829 April 18, 2018
• 285329 You cannot import attribute-centric XML in Access Q285329 KB285329 April 18, 2018
• 278400 How to use form parameters in the RecordSource property in an Access project Q278400 KB278400 April 18, 2018
• 275118 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 Q275118 KB275118 April 18, 2018
• 266387 How to find and to list Access VBA procedures by using MFC Q266387 KB266387 April 18, 2018
• 258511 How to obtain the window handle for an Office Automation server Q258511 KB258511 April 18, 2018
• 238972 Using Visual C++ to automate Office Q238972 KB238972 April 18, 2018
• 229802 How to use SetOption to disable warning messages in an Access Application Q229802 KB229802 April 18, 2018
• 210166 How to create pop-up context-sensitive Help by using Windows API WinHelp() Q210166 KB210166 April 18, 2018
• 209505 Description of the expressions to count yes, no, and other responses in Access Q209505 KB209505 April 18, 2018
• 2458709 You cannot use the mouse wheel to scroll through records in an Access 2007 or Access 2010 form Q2458709 KB2458709 April 17, 2018
• 954326 MS08-052: Description of the security update for GDI+ for the 2007 Office system: September 9, 2008 Q954326 KB954326 April 17, 2018
• 952216 The "Send To OneNote 2007" printer is missing in the Print dialog box in a 2007 Office program Q952216 KB952216 April 17, 2018
• 947318 MS09-043: Description of the security update for Office 2003 Web Components for the 2007 Office system: August 11, 2009 Q947318 KB947318 April 17, 2018
• 934062 Description of the security update for the 2007 Office system: May 8, 2007 Q934062 KB934062 April 17, 2018
• 932994 You receive an error message when you run a query in Microsoft Access because of a double-byte Arabic number Q932994 KB932994 April 17, 2018
• 928116 How to determine which version of a 2007 Office product is installed Q928116 KB928116 April 17, 2018
• 926279 Installation fails, and you receive an error message when you try to install a 2007 Office suite or program, or an Office 2010 suite or program by double-clicking an .msi file: "Error 1713" or "MSI Error 41" Q926279 KB926279 April 17, 2018
• 925757 How to enable or disable hyperlink warning messages in 2007 Office programs and in Office 2010 programs Q925757 KB925757 April 17, 2018
• 924614 How to use the repair process in the 2007 Office programs Q924614 KB924614 April 17, 2018
• 924611 How to install the individual 2007 Office features or to repair the installed 2007 Office programs Q924611 KB924611 April 17, 2018
• 924460 How to manage templates in 2007 Office programs and in 2010 Office programs Q924460 KB924460 April 17, 2018
• 920359 A decimal value in a column is rounded up or down to an integer value in Access 2007 Q920359 KB920359 April 17, 2018
• 919895 How to troubleshoot problems that you may experience when you try to activate a 2007 Office suite Q919895 KB919895 April 17, 2018
• 912203 Description of the command-line switches that are supported by a software installation package, an update package, or a hotfix package that was created by using Microsoft Self-Extractor Q912203 KB912203 April 17, 2018
• 903771 Information about the ability to uninstall Office updates Q903771 KB903771 April 17, 2018
• 896950 Error message when you run a query in Access: "The field is too small to accept the amount of data you attempted to add" Q896950 KB896950 April 17, 2018
• 895456 How to change the product key for Office XP, for Office 2003, and for the 2007 Office system Q895456 KB895456 April 17, 2018
• 892490 How to create a DSN-less connection to SQL Server for linked tables in Access Q892490 KB892490 April 17, 2018
• 884202 You must accept the Office End User License Agreement every time that you start an Office program Q884202 KB884202 April 17, 2018
• 884185 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 or in Access 2003 Q884185 KB884185 April 17, 2018
• 834008 You cannot send a document as an e-mail message from an Office 2003 or Office 2007 program Q834008 KB834008 April 17, 2018
• 830335 Microsoft Update and Windows Update offer updates for Office programs that you do not have installed Q830335 KB830335 April 17, 2018
• 827423 How to retrieve the selected items in a multiple selection List Box as a comma-delimited string in Microsoft Access Q827423 KB827423 April 17, 2018
• 826765 How to enforce or disable the startup options in an Access database project Q826765 KB826765 April 17, 2018
• 826763 Error message when you use special characters in Access databases Q826763 KB826763 April 17, 2018
• 826137 You may receive the "Can't find the database you specified" error message when you open an Access database by using a shortcut Q826137 KB826137 April 17, 2018
• 822924 Description of Office features that are intended to enable collaboration and that are not intended to increase security Q822924 KB822924 April 17, 2018
• 817411 Error message when you run a procedure in Access: "Ambiguous name detected" Q817411 KB817411 April 17, 2018
• 815281 "File sharing lock count exceeded…" error message during large transaction processing Q815281 KB815281 April 17, 2018
• 812718 How to reset an AutoNumber field value in Access Q812718 KB812718 April 17, 2018
• 325233 HOW TO: Hide the Combo Box Drop-Down Arrow on a Form in Microsoft Access Q325233 KB325233 April 17, 2018
• 313937 Microsoft Office stops responding when you try to open or save a file Q313937 KB313937 April 17, 2018
• 304473 How to edit records in related tables in a Microsoft Access database Q304473 KB304473 April 17, 2018
• 304466 How to define relationships between tables in an Access database Q304466 KB304466 April 17, 2018
• 304462 How to add lookup fields in a Microsoft Access table Q304462 KB304462 April 17, 2018
• 304458 How to create a crosstab query with multiple value fields Q304458 KB304458 April 17, 2018
• 304428 How to use the query by form (QBF) technique in Microsoft Access Q304428 KB304428 April 17, 2018
• 304356 How to modify query properties in Microsoft Access Q304356 KB304356 April 17, 2018
• 303968 How to create an SQL pass-through query in Access Q303968 KB303968 April 17, 2018
• 303134 "Enter Parameter Value" dialog box appears when you run a query, a form, or a report Q303134 KB303134 April 17, 2018
• 295824 You may receive an "A problem occurred while Microsoft Access was communicating with the OLE Server" error message when you try to embed or link a Word document in Access Q295824 KB295824 April 17, 2018
• 292634 How to use a query to filter unique data in Access Q292634 KB292634 April 17, 2018
• 290228 "Cannot connect to the FTP server" error message when you access an FTP site in Office Q290228 KB290228 April 17, 2018
• 290142 How to open documents from FTP site and save documents to FTP site with Office programs. Q290142 KB290142 April 17, 2018
• 290136 How to create a running totals query in Microsoft Access Q290136 KB290136 April 17, 2018
• 289681 You may receive a "file already in use" error message when you try to open an Access database that is located on a server Q289681 KB289681 April 17, 2018
• 288902 GetObject and CreateObject behavior of Office automation servers Q288902 KB288902 April 17, 2018
• 287696 Error message when you use Access: "The Microsoft Jet database engine cannot find the input table or query '<name>'" or "The record source '<name>' specified on this form or report does not exist" Q287696 KB287696 April 17, 2018
• 287658 How to move to a specific record from a Combo Box selection in Microsoft Access Q287658 KB287658 April 17, 2018
• 286238 Sample expressions to extract portion of a text string in Access Q286238 KB286238 April 17, 2018
• 285822 How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access Q285822 KB285822 April 17, 2018
• 285820 How to display images from a folder in a form, a report, or a data access page Q285820 KB285820 April 17, 2018
• 283806 Visual Basic for Applications (VBA) functions break in a database with missing references Q283806 KB283806 April 17, 2018
• 283788 ACCESS: "Microsoft Access Was Unable to Create an MDE, ACCDE, or ADE Database" Error Message with a Database That You Cannot Compile Q283788 KB283788 April 17, 2018
• 281670 How to force a new line in a MsgBox message in Access Q281670 KB281670 April 17, 2018
• 210604 Functions for calculating and for displaying Date/Time values in Access Q210604 KB210604 April 17, 2018
• 210276 How to store, calculate, and compare Date/Time data in Microsoft Access Q210276 KB210276 April 17, 2018
• 826208 How to edit the Windows registry to clear the list of most recently used files in Office Q826208 KB826208 April 16, 2018
• 2212418 Access: File association errors opening databases by double clicking Q2212418 KB2212418 April 12, 2018