Access 2002 (Access XP) 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 2002 (Access XP) that have been released in April 2018. The list is daily updated.

• 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
• 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
• 867838 Office XP document in a SharePoint Team Services from Microsoft document library opens as read-only in Internet Explorer Q867838 KB867838 April 23, 2018
• 837827 You receive a "Setup cannot update the file" error message when you install Office XP SP3 Q837827 KB837827 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
• 300688 How to disable the Close button on the Application window and the Exit command on the File menu Q300688 KB300688 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
• 907836 You receive an "out of memory" error message in Access 2003 and Access 2002 when you use grouped controls Q907836 KB907836 April 22, 2018
• 304581 How to simulate a progress bar in a form without using an ActiveX control in Access 2002 Q304581 KB304581 April 22, 2018
• 299974 Using Microsoft Jet with IIS Q299974 KB299974 April 22, 2018
• 295234 Compacting Access file resets NTFS permissions Q295234 KB295234 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
• 285866 Description of DLookup() usage, examples, and troubleshooting Q285866 KB285866 April 22, 2018
• 283698 "Understanding Relational Database Design" document is available in Download Center Q283698 KB283698 April 22, 2018
• 282977 Microsoft Access 2000, Microsoft Access 2002, and Microsoft Office Access 2003 Replication FAQ is available in Microsoft Download Center Q282977 KB282977 April 22, 2018
• 282364 ACC2002: Zero Values Are Not Allowed in Print Margin Settings in Page Setup Q282364 KB282364 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
• 230125 How to use dBASE data with Access and Jet Q230125 KB230125 April 22, 2018
• 209126 Information about query performance in an Access database Q209126 KB209126 April 22, 2018
• 925082 The icon is blank when you insert an object or a file into a document, presentation, spreadsheet, or other Microsoft Office file Q925082 KB925082 April 21, 2018
• 908475 You cannot embed an Adobe OpenType font in a document in an Office program Q908475 KB908475 April 20, 2018
• 825738 "System.Data.OleDb.OleDbException" error when you run an ASP.NET Web application Q825738 KB825738 April 20, 2018
• 289508 How to view error signatures if an Office program experiences a serious error and quits Q289508 KB289508 April 20, 2018
• 282085 Description of task panes in Office programs Q282085 KB282085 April 20, 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
• 886634 You cannot import the data from a comma-delimited text file by using the Import Text Wizard in Office Access 2003, in Access 2002, or in Access 2000 Q886634 KB886634 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
• 292582 You receive an invalid character error message when you install Office XP and Office 2003 Q292582 KB292582 April 19, 2018
• 291245 When you export date fields to text, the time format is included Abstract Q291245 KB291245 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
• 287485 "Object variable or With block variable not set" error message when you use Delete or UpdateBatch methods Q287485 KB287485 April 19, 2018
• 286335 List of reserved words in Access 2002 and in later versions of Access Q286335 KB286335 April 19, 2018
• 283881 When you import files, export files, or link files in Access 2002 or in Access 2003, some file types are missing, or you may receive a “Could not find installable ISAM” error message Q283881 KB283881 April 19, 2018
• 283874 How to find a record using ADO and Jet OLE DB provider Q283874 KB283874 April 19, 2018
• 281998 How to bind Microsoft Access forms to ADO recordsets Q281998 KB281998 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
• 253580 How to connect to a remote Access database from Active Server Pages Q253580 KB253580 April 19, 2018
• 209874 How to recover tables deleted from a database in Access 2000, Access 2002, or Access 2003 Q209874 KB209874 April 19, 2018
• 209215 How to reset the page number on a group level in an Access report Q209215 KB209215 April 19, 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
• 837150 You may receive error messages when you install an Access 2002 runtime deployment package on a computer that is running Windows XP SP2, Windows Server 2003, or Windows Vista Q837150 KB837150 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
• 826214 How to customize the My Places bar in both the Open and the Save As dialog boxes in Office Q826214 KB826214 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
• 328320 How to create a dynamic crosstab report in Access 2002 Q328320 KB328320 April 18, 2018
• 325671 Description of Office XP Service Pack 2 (SP2) Q325671 KB325671 April 18, 2018
• 319317 How to automate the process of selecting the printer for a report in Microsoft Access Q319317 KB319317 April 18, 2018
• 316126 How to use Visual C# to automate a running instance of an Office program Q316126 KB316126 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
• 304259 How to filter records in an Access database Q304259 KB304259 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
• 299373 Introduction to .ldb files Q299373 KB299373 April 18, 2018
• 295334 Jet compact utility is available in download center Q295334 KB295334 April 18, 2018
• 294552 Error message in Access: "Microsoft Access couldn't print your object" Q294552 KB294552 April 18, 2018
• 294202 How to enumerate selected form records in Access 2003 and in Access 2002 Q294202 KB294202 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
• 290052 How to make a replicated database a regular database in Access 2002 Q290052 KB290052 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
• 287642 How to simulate drag-and-drop capabilities in Access 2002 Q287642 KB287642 April 18, 2018
• 286345 You receive a "There is no object in this control" error message when converting Access 2002 database to Access 97 Q286345 KB286345 April 18, 2018
• 286222 How to optimize Microsoft Access when using ODBC data sources Q286222 KB286222 April 18, 2018
• 286153 You may receive a "There isn't enough disk space or memory" error message when you perform an operation on an Access table Q286153 KB286153 April 18, 2018
• 286126 You may receive the "Run-time error -2147467259" error message when you open a form by using Automation in Visual Basic .NET Q286126 KB286126 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
• 275561 Description of the new features that are included in Microsoft Jet 4.0 Q275561 KB275561 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
• 230126 How to use Paradox data with Access and Jet Q230126 KB230126 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
• 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
• 891636 You receive an "Access denied" error message, and the program unexpectedly quits when you try to open or save a file in an Office program Q891636 KB891636 April 17, 2018
• 886549 You receive an "Error 1606" error message when you try to install or remove a Microsoft program Q886549 KB886549 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
• 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
• 291556 You receive a "Too Many Fields Defined" error message when you save a table in Access 2002 Q291556 KB291556 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
• 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
• 816610 "Content Within This Application Coming from the Web Site Listed Below Is Being Blocked by Internet Explorer Enhanced Security Configuration" Message When You Try to Create a Data Access Page in Microsoft Access Q816610 KB816610 April 16, 2018
• 326039 Error message when you open a Office file that has a long folder name Q326039 KB326039 April 16, 2018
• 308459 How To Connect an HTML Page to a Microsoft Access Database Q308459 KB308459 April 16, 2018