Access 2002 (Access XP) articles, fixes and updates

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Access 2002 (Access XP) starts with letter A that have been released. The list is daily updated.

891775 Access exports long integer numbers as double data type with decimal places in dBase IV (.dbf) format Q891775 KB891775 August 20, 2020
316675 An unhandled exception may occur when you try to connect to an Access database from an ASP.NET worker process Q316675 KB316675 June 10, 2019
950929 Activate Windows 7 or Windows 8.1 - Windows Help Q950929 KB950929 September 4, 2018
282364 ACC2002: Zero Values Are Not Allowed in Print Margin Settings in Page Setup Q282364 KB282364 April 22, 2018
301915 Access causes an error when you export fields with data type single or double to Oracle Q301915 KB301915 April 19, 2018
287756 AutoNumber field is not reset after you compact an Access database Q287756 KB287756 April 18, 2018
927417 A table field appears incorrectly in Datasheet view when you add the field by using the Microsoft DAO Object Library and you set the OrdinalPosition property in Access Q927417 KB927417 December 9, 2015
209912 ACCESS: How to Reference Classes That Exist in Multiple Libraries Q209912 KB209912 January 17, 2015
210174 ACCESS: How to Index an Existing Field with Data Access Objects (DAOs) Q210174 KB210174 January 14, 2015
208842 ACCESS: Linked SQL Server Table Cannot Be Updated Q208842 KB208842 January 14, 2015
210588 ACCESS: How to Parse Comma-Separated Text into Multiple Fields Q210588 KB210588 January 11, 2015
330903 An Office program stops responding, and you receive an error message that references the Hpbafd32.dll file Q330903 KB330903 January 10, 2015
833854 A document that is opened from a hyperlink in Internet Explorer opens slowly in Office XP programs Q833854 KB833854 December 28, 2014
824181 Access may stop responding when you preview a report Q824181 KB824181 December 26, 2014
302968 ACCESS: Query of ODBC Linked Data Returns Unexpected Results Q302968 KB302968 December 26, 2014
318989 A collation conflict error occurs when you open an Access Project table or view Q318989 KB318989 December 24, 2014
282315 Access appears to hang when you preview or print an object in PivotTable view Q282315 KB282315 December 23, 2014
259602 An Access Snapshots (*.snp) object looks distorted when you insert the object in PowerPoint Q259602 KB259602 December 23, 2014
827041 ADO help is not displayed when you reference the ADO 2.7 or later Object Library Q827041 KB827041 February 27, 2014
816677 Animations do not work in Access 2002 Help running on Windows Server 2003 Q816677 KB816677 February 27, 2014
811120 Access may cause an error when you open or delete or compact linked tables Q811120 KB811120 November 2, 2013
322900 ACCESS: How to Populate Text Boxes with Multicolumn Combo Box Selections Q322900 KB322900 November 2, 2013
319017 ACC2002: How to Use the Find Unmatched Query Wizard Q319017 KB319017 November 2, 2013
210340 ACCESS: How to Display Line Numbers on Subform Records Q210340 KB210340 November 2, 2013
209807 ACCESS: Remote ODBC Tables Are Read-Only Without a Unique Index Q209807 KB209807 November 2, 2013
208408 ACCESS: Exporting to Text File Truncates to Two Decimals Places Q208408 KB208408 November 2, 2013
827983 Access 2002 post-Service Pack 3 hotfix package: May 7, 2004 Q827983 KB827983 November 1, 2013
289895 ACC2002: BeforeUpdate and AfterUpdate Properties Are Not Working Q289895 KB289895 November 1, 2013
282344 ACC2002: Project Table Property with Invalid Setting Is Not Specified in Error Message Q282344 KB282344 November 1, 2013
889491 A project stops responding when you select a check box on a form that is based on an ActiveX Data Objects recordset in Access 2002 Q889491 KB889491 October 27, 2013
917415 Access 2002 exits when you create or try to modify an in-line function when the Access 2002 project is connected to a SQL Server 2005 database Q917415 KB917415 October 26, 2013
827972 Access 2002 Post-Service Pack 2 Hotfix Package: September 12, 2003 Q827972 KB827972 October 26, 2013
826764 Access Help Incorrectly Lists the Maximum Value of the TimerInterval Property as 65,535 Milliseconds Q826764 KB826764 October 26, 2013
823337 Availability of the Access 2002 Post-Service Pack 2 Hotfix Package: July 14, 2003 Q823337 KB823337 October 26, 2013
815279 A snapshot that is created in Access 2002 may appear blank in Snapshot Viewer when used with the operating system Microsoft Windows 98 Q815279 KB815279 October 26, 2013
329883 Access 2002 SnapShot object does not appear as expected when you insert it into a document Q329883 KB329883 October 26, 2013
321850 ACC2002: You Cannot Open a Partial Replica File That Is Created in the Access 2002 Format Q321850 KB321850 October 26, 2013
319491 Access quits unexpectedly when you run a query in Access 2002 Q319491 KB319491 October 26, 2013
300926 ACC2002: How to Optimize PivotTable List Performance in Microsoft Access Q300926 KB300926 October 26, 2013
299022 ACC2002: How to Select the Page Working with Data Access Pages Q299022 KB299022 October 26, 2013
295252 ACC2002: Subform Combo Box Displays Incorrect Data in an Access Project Q295252 KB295252 October 26, 2013
295223 ACC2002: "Column Names in Each View or Function Must Be Unique..." Error Message When You Save a Query in an Access Project Q295223 KB295223 October 26, 2013
292791 ACC2002: Cannot Use ADOX Views Collection with SQL Server Q292791 KB292791 October 26, 2013
292302 ACC2002: Can't Use /Pwd Option with Password-Protected Database Q292302 KB292302 October 26, 2013
287520 ACC2002: Problems Binding List Box Recordset in Datasheet View Q287520 KB287520 October 26, 2013
287473 ACC2002: Run-Time Error Message When You Programmatically Set PaperSize Property Q287473 KB287473 October 26, 2013
287444 ACC2002: "Microsoft Access Can't Open the File" Error When You Rest the Mouse Pointer over a Report Name Q287444 KB287444 October 26, 2013
287022 Access shuts down unexpectedly after programmatically exporting Microsoft Graph object Q287022 KB287022 October 26, 2013
286224 ACC2002: No Option to Import, Link, or Export to the FoxPro File Type Q286224 KB286224 October 26, 2013
282383 ACC2002: FindFirst that uses LIKE behaves differently in DAO snapshots and DAO dynasets Q282383 KB282383 October 26, 2013
282375 ACC2002: Microsoft Paint Cannot Be Found in the Current Path During Change Icon Operation Q282375 KB282375 October 26, 2013
282368 ACC2002: MSysAccessObjects Table Exists in Access 2002 File Format Q282368 KB282368 October 26, 2013
282358 ACC2002: Combo Box or List Box Recordset Is Lost When You Switch Form Views Q282358 KB282358 October 26, 2013
275090 ACC2002: @@IDENTITY Returns Incorrect Identity Column Value Q275090 KB275090 October 26, 2013
969404 An application that uses a complex Excel 2002 solution crashes after you apply the security update that is described in Knowledge Base article 944423 Q969404 KB969404 October 25, 2013
304583 ACC2002: How to Graphically Display Percent of Total on a Report Q304583 KB304583 October 25, 2013
298645 ACC2002: Microsoft Product Support Guidelines for Microsoft Access Q298645 KB298645 October 25, 2013
282263 ACC2002: Ignored MaxScanRows Setting May Cause Improper Data Types in Linked Tables Q282263 KB282263 October 25, 2013
322676 ACC2002: Update Query Still Modifies Records After You Cancel the Query Q322676 KB322676 October 24, 2013
319487 ACC2002: How to Recover a Deleted or Missing AutoFormat Style Q319487 KB319487 October 24, 2013
318809 ACC2002: Error Message: Microsoft Access Is Unable to Start the Lookup Wizard Q318809 KB318809 October 24, 2013
317123 ACC2002: Objects in Database Appear Underlined Q317123 KB317123 October 24, 2013
314413 ACC2002: Font List Is Displayed Incorrectly in Label Wizard Dialog Box Q314413 KB314413 October 24, 2013
313298 ACC2002: Error Starting Query Designer from the RecordSource Property of an Access Project (ADP) Report Q313298 KB313298 October 24, 2013
312281 ACC2002: Microsoft Access Project Disconnects from SQL Server Shortly After It Opens Q312281 KB312281 October 24, 2013
311114 ACC2002: Expression Builder Causes Error with Strings That Are More Than 1,023 Characters Long Q311114 KB311114 October 24, 2013
311050 ACC2002: Microsoft Access Quits When You Scroll Through a Text Box on a Subform Q311050 KB311050 October 24, 2013
310824 ACC2002: Error Message: Application Roles Can Only Be Activated at the Ad Hoc Level Q310824 KB310824 October 24, 2013
310492 ACC2002: PivotTable or PivotChart View Is Missing When You Save a Form as a Report Q310492 KB310492 October 24, 2013
310264 ACC2002: Decimal Field Is Truncated When You View an Object in PivotTable and PivotChart View Q310264 KB310264 October 24, 2013
307925 ACC2002: You Cannot Update a View in a Microsoft Access Project Q307925 KB307925 October 24, 2013
307771 ACC2002: Microsoft Access Newsgroups Available on the Internet Q307771 KB307771 October 24, 2013
307490 Authoring MOM Reports With Access 2002 Is Not Recommended Q307490 KB307490 October 24, 2013
307253 ACC2002: How to Print a Line Number for Each Record on a Data Access Page Q307253 KB307253 October 24, 2013
306250 ACC2002: Setting ANSI 92 Compatibility in a Database Does Not Allow DISTINCT Keyword in Aggregate Functions Q306250 KB306250 October 24, 2013
306176 ACC2002: A Chart Displays Incorrect Values for Some Records Q306176 KB306176 October 24, 2013
306148 ACC2002: How to Navigate to a Particular Record on a Data Access Page Q306148 KB306148 October 24, 2013
304898 ACC2002: Chart Intermittently Displays Sample Data Q304898 KB304898 October 24, 2013
304724 ACC2002: How to Return an ADO Recordset from a RecordsetDef on a Data Access Page Q304724 KB304724 October 24, 2013
304527 ACC2002: List Box Border Style Is Still Visible When You Set It to Transparent Q304527 KB304527 October 24, 2013
304524 ACC2002: Report Auto List Members Shows Generic Control Object List Q304524 KB304524 October 24, 2013
304523 ACC2002: Filter By Form Does Not Filter Data That Has Commas in It Q304523 KB304523 October 24, 2013
304522 ACC2002: Cannot Switch to Data Entry Mode on a Form If a WHERE Clause Is Used to Open the Form Q304522 KB304522 October 24, 2013
304469 ACC2002: How to View and Edit Relationships in a Microsoft Access Database Q304469 KB304469 October 24, 2013
304390 ACC2002: How to Create a Query That Returns Records Based on a Range of Letters in a Text Field Q304390 KB304390 October 24, 2013
304322 ACC2002: How to use ADOX to Import Relationships Q304322 KB304322 October 24, 2013
304320 ACC2002: How to Use Data Access Pages to Store and Display HTML Tags Q304320 KB304320 October 24, 2013
304276 ACC2002: Working with Subdatasheets in Microsoft Access Q304276 KB304276 October 24, 2013
304251 ACC2002: How to Programmatically Determine Whether the Current File Is an MDE or and ADE File Q304251 KB304251 October 24, 2013
304249 ACC2002: "Sorting and Grouping" Dialog Box Has Been Replaced with the "Group Level Properties" Dialog Box for Data Access Pages Q304249 KB304249 October 24, 2013
304235 ACC2002: How to Determine If a Page Is Open in Access or Internet Explorer Q304235 KB304235 October 24, 2013
304178 ACC2002: How to Create a PivotChart View That Is Bound to Combo Boxes Q304178 KB304178 October 24, 2013
304172 ACC2002: How to Use the "Live Data" Option When You Export to XML Q304172 KB304172 October 24, 2013
304171 ACC2002: How to Programmatically Rotate a Chart in PivotChart View Q304171 KB304171 October 24, 2013
304167 ACC2002: How to Create a PivotChart View That Does Not Summarize Data Q304167 KB304167 October 24, 2013
304092 ACC2002: The Database Window Is Displayed When a Database Is Opened from the Most Recently Used File List Even After You Clear the "Display Database Window" Check Box Q304092 KB304092 October 24, 2013
302784 ACC2002: Access Quits Unexpectedly When You Try to Open the Visual Basic Environment from a Database Object Q302784 KB302784 October 24, 2013
302673 ACC2002: No Primary Key on a Copied or an Imported Table in an Access Project Q302673 KB302673 October 24, 2013
301436 ACC2002: "Query Could Not Be Processed..." Error with Calculated Total in PivotTable List Q301436 KB301436 October 24, 2013
301379 ACC2002: PivotTable List Displays "No Totals" or "No Details" in Data Area Q301379 KB301379 October 24, 2013
299019 ACC2002: How to Repeat Subreport Header at the Top of a Page Q299019 KB299019 October 24, 2013
294407 "Access 2002 Upsizing Tools" white paper is available in Download Center Q294407 KB294407 October 24, 2013
288251 ACC2002: "#ERROR" Message When You Reference Subreport Controls Q288251 KB288251 October 24, 2013
287448 Access 2002 runtime is the default file association for.mdb database files and for.adp project files Q287448 KB287448 October 24, 2013
282328 ACC2002: #Name Appears in Linked Table When Decimal Field Has Identity Set to Yes Q282328 KB282328 October 24, 2013
299257 ACC2002: Breakpoints Are Ignored in Visual Basic for Applications Code Q299257 KB299257 October 23, 2013
299042 ACC2002: Subform in PivotTable or PivotChart View Is Printed in Datasheet View Q299042 KB299042 October 23, 2013
299026 ACC2002: Page Header That Spans Full Width of Multi-Column Report Q299026 KB299026 October 23, 2013
299025 ACC2002: How to Specify a Custom Starting-Page Number for a Report Q299025 KB299025 October 23, 2013
299018 ACC2002: How to Programmatically Create a New Data Access Page Q299018 KB299018 October 23, 2013
299015 ACC2002: How to Edit the Text of Controls on a Data Access Page Q299015 KB299015 October 23, 2013
299009 ACC2002: Data Access Page Ignores Underlying Table's Input Mask Q299009 KB299009 October 23, 2013
298877 ACC2002: Parameter Dialog Box Appears When You Run a Pasted Query Q298877 KB298877 October 23, 2013
298605 ACC2002: AutoCorrect Does Not Capitalize the First Word of the First Sentence Q298605 KB298605 October 23, 2013
298046 ACC2002: Setting Form RecordSource Property Resets PivotTable and PivotChart Views Q298046 KB298046 October 23, 2013
296625 ACC2002: View That Is Created from a Linked Server Is Not Updateable in an Access Project Q296625 KB296625 October 23, 2013
296572 ACC2002: Conversion Errors When You Import Dates That Have Different Formats Q296572 KB296572 October 23, 2013
296491 ACC2002: Access Crashes When You Set IsFilterOn Property in DataPageComplete Event Q296491 KB296491 October 23, 2013
296049 ACC2002: OpenForm and OpenReport WHERE Clauses Are Ignored When You Use Server Filter Q296049 KB296049 October 23, 2013
296048 ACC2002: Server Filter By Form Incorrectly Converts Date Criteria Q296048 KB296048 October 23, 2013
295819 ACC2002: Files That Were Not Created by Data Source Control Can Be Overwritten Q295819 KB295819 October 23, 2013
295698 ACC2002: Incorrect Records Are Selected When the Criterion Is a Date and the Short Date Format Is d/M/yy Q295698 KB295698 October 23, 2013
295619 ACC2002: Nz Method of the Data Source Control Does Not Function as Expected Q295619 KB295619 October 23, 2013
295468 ACC2002: ExportXML Method of the Data Source Control Is Incorrectly Documented in Help Q295468 KB295468 October 23, 2013
295277 ACC2002: Access Quits When Running a SQL Query Q295277 KB295277 October 23, 2013
295276 ACC2002: Access Quits Unexpectedly When You Resize a Control While Holding Down the SHIFT Key Q295276 KB295276 October 23, 2013
295273 ACC2002: Subform in PivotTable or PivotChart View Prepares Data Twice If the Main Form Is Sorted or Filtered Q295273 KB295273 October 23, 2013
295271 ACC2002: Text That You Paste into the Search Text Box of the Task Pane Is Placed on a Data Access Page Q295271 KB295271 October 23, 2013
295270 ACC2002: Access Quits When Previewing Report Created from Form Q295270 KB295270 October 23, 2013
295269 ACC2002: Access Quits When You Are Saving a Data Access Page or Viewing It in Page View Q295269 KB295269 October 23, 2013
295268 Access 2002 quits after you use Access 2000 to recompile code Q295268 KB295268 October 23, 2013
295265 ACC2002: Combo Box Wizard Unexpectedly Reports No Valid Fields Q295265 KB295265 October 23, 2013
295263 ACC2002: Field List May Be Blank If RecordSource Property of a Form in an Access Project Is Set to an SQL Select Statement Q295263 KB295263 October 23, 2013
295261 ACC2002: Cannot Sort Text, Ntext, and Image Data Types in an Access Project (.adp) Q295261 KB295261 October 23, 2013
295258 ACC2002: Access Quits When It Tries to Open the Theme Dialog Box on a Converted Data Access Page If the Theme Is Not Installed Q295258 KB295258 October 23, 2013
295257 ACC2002: Access Quits When You Set the ControlSource Property on a Data Access Page Q295257 KB295257 October 23, 2013
295254 ACC2002: Cannot Bind a List Box to a Boolean Field on a Data Access Page Q295254 KB295254 October 23, 2013
295253 ACC2002: Unable to Convert an Enabled Workgroup Information File After Adding Users Q295253 KB295253 October 23, 2013
295251 ACC2002: Access Crashes When You Sort a Table That Has a Subdatasheet Q295251 KB295251 October 23, 2013
295250 ACC2002: Error Inserting Row into Multi-Table View or Function Q295250 KB295250 October 23, 2013
295249 ACC2002: Microsoft Access Hangs After You Change the Relationship for a Data Access Page Q295249 KB295249 October 23, 2013
295247 ACC2002: Error When You Use Filter by Selection on a Data Access Page Q295247 KB295247 October 23, 2013
295246 ACC2002: Error When You Click a Navigation Button Command on the Record Navigation Toolbar Shortcut Menu in a Data Access Page Q295246 KB295246 October 23, 2013
295242 ACC2002: Microsoft Access Quits When You Programmatically Switch Views on Open Tables or Queries Q295242 KB295242 October 23, 2013
295240 ACC2002: Continuous Alerts in an Access Project File When You Close a Table in Which You Made Design Changes to a Subdatasheet Q295240 KB295240 October 23, 2013
295238 ACC2002: Can't Expand Table Node in the Field List of a Data Access Page Q295238 KB295238 October 23, 2013
295236 ACC2002: Source Object of a Subform Is Set to a Table Name Instead of to a Form Name in an Access Project Q295236 KB295236 October 23, 2013
295235 ACC2002: The Upsizing Wizard Does Not Upsize Nested Queries If Base Queries Are Upsized as Functions Q295235 KB295235 October 23, 2013
295232 ACC2002: Access Quits When You Sort a Table While Renaming a Column Q295232 KB295232 October 23, 2013
295230 ACC2002: Filter Toolbar Disappears When You Use the Advanced Filter/Sort Feature Q295230 KB295230 October 23, 2013
295228 ACC2002: Cannot Add Control While Code Is Running Behind Form Q295228 KB295228 October 23, 2013
295227 ACC2002: Make-Table Dialog Box Does Not Accept Fully Qualified Three-Part Names Q295227 KB295227 October 23, 2013
295226 ACC2002: Resource Leak When You Use the Query Designer in an Access Project (ADP) Q295226 KB295226 October 23, 2013
295220 ACC2002: Date Grouping Not Preserved and Year Value Not Displayed Correctly in PivotTable and PivotChart Views Q295220 KB295220 October 23, 2013
295219 ACC2002: No Records Are Displayed in a Subform That Is Based on a SQL Server Table Q295219 KB295219 October 23, 2013
295218 ACC2002: Cannot Select Table in "Select Database and Table" of Data Connection Wizard Q295218 KB295218 October 23, 2013
295217 ACC2002: Access Quits When You Switch from Print Preview to Design View and then to Datasheet View Q295217 KB295217 October 23, 2013
295215 ACC2002: Presentation Is Not Applied to XML Exported with Embedded Schema Q295215 KB295215 October 23, 2013
295214 ACC2002: Misleading Error Message When You Click an Access Project (.adp) That Has Been Renamed, Moved, or Deleted in the Task Pane Q295214 KB295214 October 23, 2013
295212 ACC2002: Changing the Data Type of Any Field in a Table Resets the PivotTable View Q295212 KB295212 October 23, 2013
295211 ACC2002: "Incorrect Syntax near 'COLLATE'" Error Message When You Import Tables into a Microsoft Access Project Q295211 KB295211 October 23, 2013
295209 ACC2002: Access Quits After You Change the Case of a Parameter in a Stored Procedure or a Function Q295209 KB295209 October 23, 2013
295206 ACC2002: System Crash or Hang When You Drag an Unrelated Child Table into a Parent Section of a Data Access Page Q295206 KB295206 October 23, 2013
295205 ACC2002: Error Importing Table into Access Project Connected to SQL Server 6.5 Q295205 KB295205 October 23, 2013
295203 ACC2002: A Parameterized Stored Procedure Returns No Output Columns If You First Open It in Design View Q295203 KB295203 October 23, 2013
295201 ACC2002: Error Message When You Try to Copy and Paste a Table That Has a Timestamp Field Q295201 KB295201 October 23, 2013
295197 ACC2002: Help Is Not Called When You Press F1 for the OnUndo Property Q295197 KB295197 October 23, 2013
295191 ACC2002: Microsoft Access Quits If You Set the ADO Recordset Property Twice in the OnOpen Event of a Report Q295191 KB295191 October 23, 2013
295187 ACC2002: Tables Copied and Pasted in a Microsoft Access Database or Project Do Not Retain Permissions Q295187 KB295187 October 23, 2013
295186 ACC2002: It Takes a Long Time for the Oracle 8i Table List to Appear Q295186 KB295186 October 23, 2013
295184 ACC2002: Control OnUndo Event Does Not Fire as Expected Q295184 KB295184 October 23, 2013
295176 ACC2002: RepaintObject Command Removes Objects from an Unsaved Data Access Page Q295176 KB295176 October 23, 2013
295173 ACC2002: Synchronization Fails When System Date Is Greater Than 2038 Q295173 KB295173 October 23, 2013
295171 ACC2002: Infinite Loop After You Cancel Demand Install of Vbe6.dll Q295171 KB295171 October 23, 2013
295169 ACC2002: Write Conflicts Are Not Reported in Text or Image Data Type Fields in a Microsoft Access Project Q295169 KB295169 October 23, 2013
295060 ACC2002: Connection Property of the DSCEventInfo Object Does Not Work Q295060 KB295060 October 23, 2013
294547 ACC2002: Error Message: Errors Were Encountered During the Save Operation Q294547 KB294547 October 23, 2013
294398 ACC2002: Tables Not Upsized When Query or Table Name Contains Apostrophe Q294398 KB294398 October 23, 2013
294228 ACC2002: "Command Not Available" Error on Converted Switchboard Form Q294228 KB294228 October 23, 2013
293657 ACC2002: #Deleted in a Linked Table That Has a Field of Type UniqueIdentifier Q293657 KB293657 October 23, 2013
293625 ACC2002: Unable to Cancel Apply Server Filter in an Access Project Q293625 KB293625 October 23, 2013
293361 ACC2002: Cannot Use Legacy Database Templates with Access 2002 Q293361 KB293361 October 23, 2013
293357 ACC2002: Error When You Save a Form or a Report as a Data Access Page Q293357 KB293357 October 23, 2013
293334 ACC2002: Event Topics, Property Topics, and Other Help Topics Related to Batch Transactions in Access 2002 Are Incorrect Q293334 KB293334 October 23, 2013
293148 ACC2002: Microsoft Access Project Form Displays #Name? in Print Preview Q293148 KB293148 October 23, 2013
292501 ACC2002: The Back Button Appears Dimmed in the Browser After You Click Hyperlink on a Data Access Page Q292501 KB292501 October 23, 2013
292050 ACC2002: Keeping Subreport or Text Box Data Together on a Page Q292050 KB292050 October 23, 2013
292047 ACC2002: Access May Choose an Unexpected Index as the Primary Key Q292047 KB292047 October 23, 2013
291958 ACC2002: Parameter Query Returns No Records with Replication ID Field Q291958 KB291958 October 23, 2013
291947 ACC2002: How to Open a Data Access Page in the Microsoft Script Editor Q291947 KB291947 October 23, 2013
291224 ACC2002: Unexpected Characters Appear in a Database That Was Converted from a Localized Version of an Earlier Version of Access Q291224 KB291224 October 23, 2013
291054 ACC2002: "#Error" Message When You Use TRIM() Function in a Form or a Report Q291054 KB291054 October 23, 2013
290587 ACC2002: Saving Import and Export Specifications Is Not Supported Q290587 KB290587 October 23, 2013
290421 "About MDE Files" help topic is incorrect in Access 2002 Q290421 KB290421 October 23, 2013
290313 ACC2002: Things You Should Consider When You Save Access Objects in XML Format Q290313 KB290313 October 23, 2013
290282 ACC2002: Warning in Label Wizard When You Use Three-Across Labels Q290282 KB290282 October 23, 2013
290173 ACC2002: Linked FoxPro Icon Appears Dimmed in a Converted Database Q290173 KB290173 October 23, 2013
290130 ACC2002: Finding Help Topics in Microsoft Access 2002 Q290130 KB290130 October 23, 2013
290081 ACC2002: Cannot Create a Data Access Page Connected to SQL Server 6.5 Q290081 KB290081 October 23, 2013
289908 ACC2002: Error on Report with Subform When You Use "Publish It with Microsoft Word" Command Q289908 KB289908 October 23, 2013
289611 ACC2002: Error Refreshing Text File with Linked Table Manager Q289611 KB289611 October 23, 2013
289525 ACC2002: Unexpected Characters Appear When You Convert Databases That Have Non-U.S. English Characters Q289525 KB289525 October 23, 2013
289282 ACC2002: Double-Clicking a Shortcut to an Access 2002 Database Object Starts an Earlier Version of Access Q289282 KB289282 October 23, 2013
288572 ACC2002: Exporting to Fixed-Width Text File Left-Aligns Numbers Q288572 KB288572 October 23, 2013
288441 ACC2002: How to Edit the Most Recently Used Template List Q288441 KB288441 October 23, 2013
288374 ACC2002: Problems Using Requery and Refresh Methods During Pivot Events Q288374 KB288374 October 23, 2013
288276 Access quits when binding a form to an ADO recordset using Jet in Access 2002 Q288276 KB288276 October 23, 2013
287674 ACC2002: "ODBC Call Failed" Error Message Exporting to FoxPro Q287674 KB287674 October 23, 2013
287603 ACC2002: Saving Objects in a Large Database Is Slower Than in Earlier Versions Q287603 KB287603 October 23, 2013
287494 ACC2002: When You Paste Table Structure in ADP, Extended Properties Are Not Included in New Table Q287494 KB287494 October 23, 2013
287493 ACC2002: Access Quits Unexpectedly When You Set Listbox Recordset Q287493 KB287493 October 23, 2013
287492 ACC2002: Subform in PivotChart or PivotTable View Extends Past Right Margin of the Page Q287492 KB287492 October 23, 2013
287490 ACC2002: Default Value for Datetime Column Appears as 12/30/1899 Q287490 KB287490 October 23, 2013
287488 ACC2002: Removing Validation Text Causes a Record That Cannot Be Committed When the Constraint Is Violated Q287488 KB287488 October 23, 2013
287487 ACC2002: Upsizing Wizard Fails to Upsize Form References in WHERE Clause Q287487 KB287487 October 23, 2013
287478 ACC2002: Combo Box Value Is Blank After You Set Recordset Property Q287478 KB287478 October 23, 2013
287476 ACC2002: Can't Expand a Table's Subdatasheet Q287476 KB287476 October 23, 2013
287475 ACC2002: Text in the Expression Builder Is Not Wrapped as Expected Q287475 KB287475 October 23, 2013
287474 ACC2002: You Receive Save Message After You Change PivotTable Window Width Q287474 KB287474 October 23, 2013
287471 ACC2002: "Action" Stored Procedures Appear in Page Wizard Q287471 KB287471 October 23, 2013
287469 ACC2002: Filter By Form Command Applied to Datasheet View Does Not Affect PivotTable or PivotChart View Q287469 KB287469 October 23, 2013
287468 ACC2002: Shortcut Menu for Subform PivotTable Does Not Show All Items Q287468 KB287468 October 23, 2013
287466 ACC2002: Euro Currency Symbol Does Not Appear in Tables Exported to XML Q287466 KB287466 October 23, 2013
287465 ACC2002: Report Wizard Uses Wrong Caption (Standard) for Calculated Percentages Q287465 KB287465 October 23, 2013
287463 ACC2002: Empty Result Set When You Run a Scalar Function Before You Close It Q287463 KB287463 October 23, 2013
287462 ACC2002: Stored Procedure Is Not Found When Run from Editor Q287462 KB287462 October 23, 2013
287461 ACC2002: Tooltips Are Incorrect in the Export XML Dialog Box Q287461 KB287461 October 23, 2013
287460 ACC2002: Cannot Import Data After You Add Database to Visual SourceSafe Q287460 KB287460 October 23, 2013
287459 ACC2002: "Specified Index Does Not Exist" Error Message When You Set ADO Recordset Index Q287459 KB287459 October 23, 2013
287458 ACC2002: Cannot Undo Typing After a Subform Is Switched from Form View to Datasheet View Q287458 KB287458 October 23, 2013
287454 ACC2002: At Sign in RecordSource Property Causes Error Message Q287454 KB287454 October 23, 2013
287450 ACC2002: Access Quits Unexpectedly When Manipulating Forms and Subforms with OLE Objects Q287450 KB287450 October 23, 2013
287449 ACC2002: InputParameter Property Cannot Perform Lookup to Visual Basic for Applications Function Q287449 KB287449 October 23, 2013
287446 ACC2002: Error Message: Start Position Is Before the Beginning or Past the End of the Rowset. No Rows Were Returned Q287446 KB287446 October 23, 2013
287445 ACC2002: Cannot Bind a Grouped Report That Was Saved as a Data Access Page to XML Q287445 KB287445 October 23, 2013
287441 ACC2002: "Can Grow" Property of PivotTable Subforms Is Ignored on Reports Q287441 KB287441 October 23, 2013
287434 ACC2002: Manually Set IsHyperlink Property to Yes When You Add a Hyperlink Field to a Form Q287434 KB287434 October 23, 2013
287431 ACC2002: Filter By Selection Help Text Includes Misleading Instructions Q287431 KB287431 October 23, 2013
287429 ACC2002: Action Query Does Not Affect All Valid Records in an Access Project Q287429 KB287429 October 23, 2013
287415 ACC2002: Unable to Transfer a SQL Server Database That Is Connected to an Access Project Q287415 KB287415 October 23, 2013
287106 ACC2002: Cannot Set Form Data Properties During Pivot Events Q287106 KB287106 October 23, 2013
287063 ACC2002: Can't Find Data Type Conversion Functions in VBA Help Q287063 KB287063 October 23, 2013
286600 ACC2002: PivotChart Subform Is Printed Outside of Margins and Is Repeated on Second Page Q286600 KB286600 October 23, 2013
286595 ACC2002: Error When You Run RecordExit Function or Sub Procedure Q286595 KB286595 October 23, 2013
286591 ACC2002: RecordExit Event in Employees Form Does Not Work Q286591 KB286591 October 23, 2013
286477 ACC2002: RecordExit Event Unavailable in Microsoft Access 2002 Q286477 KB286477 October 23, 2013
286453 ACC2002: How to Force Access to Display Dates with Four-Digit Years Q286453 KB286453 October 23, 2013
286333 ACC2002: General Number Format Ignores Decimal Number Setting Q286333 KB286333 October 23, 2013
286242 ACC2002: Unable to Use FindFirst to Retrieve Value with Apostrophe Q286242 KB286242 October 23, 2013
285848 ACC2002: PivotChart Series Formatting Is Lost in Linked Subforms Q285848 KB285848 October 23, 2013
285356 ACC2002: Imported Data Access Page Retains Original Data Source Q285356 KB285356 October 23, 2013
285330 ACC2002: Cannot Create Group Above a Section on a Data Access Page Q285330 KB285330 October 23, 2013
285162 ACC2002: How to Use Server Filters on Data Access Pages Without a Web Server Q285162 KB285162 October 23, 2013
284960 ACC2002: Requery Method Does Not Rebind Page to XML Data File Q284960 KB284960 October 23, 2013
284904 ACC2002: Access Quits Unexpectedly When You Click the Edit Menu in Design View of a Data Access Page Q284904 KB284904 October 23, 2013
283854 ACC2002: Microsoft Access Help for XML Support Is Incorrect Q283854 KB283854 October 23, 2013
283853 ACC2002: A Data Access Page That Is Created from an Unsaved Form or Report Is Unbound Q283853 KB283853 October 23, 2013
283203 ACC2002: Data Access Page That Contains Embedded XML May Open Slowly Q283203 KB283203 October 23, 2013
282803 ACC2002: TextAlign Property Does Not Apply to List Box Control Q282803 KB282803 October 21, 2013
282399 ACC2002: Access Menu Bar Does Not Have Focus When You Start Access Q282399 KB282399 October 21, 2013
282398 ACC2002: No Effect When You Programmatically Set ANSI-92 Mode Q282398 KB282398 October 21, 2013
282397 ActiveX Data Objects 2.1 is referenced by default instead of ActiveX Data Objects 2.5 in Access 2002 Q282397 KB282397 October 21, 2013
282392 ACC2002: Pivot Toolbars Do Not Appear for Subform Q282392 KB282392 October 21, 2013
282391 ACC2002: Unable to Update Table with Values from Another Table Q282391 KB282391 October 21, 2013
282390 ACC2002: "Server Error 134" Error Message When You Attempt to Upsize Your Database Q282390 KB282390 October 21, 2013
282389 ACC2002: Identity Increment Values Greater Than One Are Not Calculated Until the New Record Is Saved Q282389 KB282389 October 21, 2013
282388 ACC2002: OutputTo Macro Action or Method Creates an Incomplete Data Access Page Q282388 KB282388 October 21, 2013
282387 ACC2002: Some Fields Do Not Appear in the PivotTable or PivotChart Field List of Forms Q282387 KB282387 October 21, 2013
282386 ACC2002: Shortcut Menu Is Not Available in the Expression Builder or Zoom Dialog Box Q282386 KB282386 October 21, 2013
282384 ACC2002: Unexpected Behavior with Images on Employees Form Q282384 KB282384 October 21, 2013
282382 ACC2002: Unexpected Error Occurs When Two Users Edit the Same Data in a Related Table Q282382 KB282382 October 21, 2013
282381 ACC2002: Reports Saved as Data Access Pages Are Missing Grand Totals Q282381 KB282381 October 21, 2013
282378 ACC2002: Cannot Change Title Bar Caption in PivotTables Q282378 KB282378 October 21, 2013
282377 ACC2002: Default Value Displayed as #Error in New Record Q282377 KB282377 October 21, 2013
282376 ACC2002: Pending Records Are Displayed Incorrectly in a Form Bound to a Batch Cursor Q282376 KB282376 October 21, 2013
282374 ACC2002: Functions Cause Scripting Errors When Forms or Reports Are Exported as XML Documents Q282374 KB282374 October 21, 2013
282373 ACC2002: Record Appears to Be Deleted from XML Data Page Without Warning Q282373 KB282373 October 21, 2013
282372 ACC2002: Lookup Field Is Not Updated When You Change the Lookup Display Column in a View Q282372 KB282372 October 21, 2013
282371 ACC2002: Datasheet View Unexpectedly Runs Stored Procedure Q282371 KB282371 October 21, 2013
282370 ACC2002: MaxRecButton Property Setting Does Not Affect Maximum Records Command on the Records Menu Q282370 KB282370 October 21, 2013
282367 ACC2002: Table Names Displayed Incorrectly in a Microsoft Access Project Q282367 KB282367 October 21, 2013
282365 ACC2002: Import Spreadsheet Wizard Does Not Preserve Long or Medium Date Formats Q282365 KB282365 October 21, 2013
282362 ACC2002: Data Access Page Does Not Display Default Values in New Records Q282362 KB282362 October 21, 2013
282361 ACC2002: PivotChart Toolbar Is Not Displayed on Data Access Page Q282361 KB282361 October 21, 2013
282360 ACC2002: "Enter Parameter Value" Dialog Box Displays Square Brackets Around Parameter "Name" Q282360 KB282360 October 21, 2013
282359 ACC2002: Stored Procedure Output Loses Euro Currency Symbol Format Q282359 KB282359 October 21, 2013
282355 ACC2002: Mismatched Data Types in Indexes Cause Access to Quit Unexpectedly Q282355 KB282355 October 21, 2013
282351 ACC2002: Pivot Views Are Not Preserved When You Import Tables from Access Projects Q282351 KB282351 October 21, 2013
282350 ACC2002: PivotChart and PivotTable Views Are Saved Automatically Q282350 KB282350 October 21, 2013
282348 ACC2002: Row Fix-Up Does Not Update Other Rows When Data on the Primary Side Is Edited Q282348 KB282348 October 21, 2013
282345 ACC2002: UseXMLData Property Is Ignored with Offline Data Access Page Q282345 KB282345 October 21, 2013
282343 ACC2002: Unable to Open Database from Windows Explorer If Access Dialog Box Is Open Q282343 KB282343 October 21, 2013
282342 ACC2002: Dictation Not Available in Design View of Server Objects in ADPs Q282342 KB282342 October 21, 2013
282341 ACC2002: "Out of Memory" Error Message in the Visual Basic Environment After You Open a Number of Modules Q282341 KB282341 October 21, 2013
282337 ACC2002: Argument Order Is Reversed When an Event Property Is a Function in Another Form's Class Module Q282337 KB282337 October 21, 2013
282327 ACC2002: Exported dBASE III File Cannot Be Opened in dBASE III Q282327 KB282327 October 21, 2013
282326 ACC2002: How to Create a Registry Key to Set Number of Times to Undo Operations or Commands Q282326 KB282326 October 21, 2013
282325 ACC2002: Sample Databases Submenu Is Unexpectedly Visible in Run-Time Mode Q282325 KB282325 October 21, 2013
282322 ACC2002: Name AutoCorrect Does Not Fix Changed Field Names in Union Query Q282322 KB282322 October 21, 2013
282320 ACC2002: Error Message: "Run-Time Error. Requested Conversion Is Not Supported" Q282320 KB282320 October 21, 2013
282316 ACC2002: Data in Replica Sets Does Not Match as Expected After Synchronization Q282316 KB282316 October 21, 2013
282264 ACC2002: PivotChart and PivotTable List Lose Formatting in Replicas Q282264 KB282264 October 21, 2013
281950 ACC2002: Database Unexpectedly Upsized to SQL Server Master Database Q281950 KB281950 October 21, 2013
281895 ACC2002: When You Change the XML Location from Embedded to Data File, the Embedded XML Remains Part of the Data Access Page Q281895 KB281895 October 21, 2013
281589 ACC2002: Error Message: "Could Not Find File..." When You Select One of the Sample Databases Q281589 KB281589 October 21, 2013
280571 ACC2002: TAB Key Does Not Move Focus to All Controls in a Wizard Q280571 KB280571 October 21, 2013
280557 ACC2002: Error When You Select an Option from the Office Links Menu Q280557 KB280557 October 21, 2013
279821 ACC2002: Default Parameter Is Automatically Applied to Stored Procedures Q279821 KB279821 October 21, 2013
279738 ACC2002: New Access 2002 Properties Not Persisted in Visual SourceSafe Q279738 KB279738 October 21, 2013
279443 ACC2002: No Color-Coded Text in SQL Text Editor Q279443 KB279443 October 21, 2013
278868 ACC2002: Query Criteria Text Changes to N'My Criteria' in an Access Project Q278868 KB278868 October 21, 2013
278867 ACC2002: Lookup Wizard Is Not Available in Access Projects (ADPs) Q278867 KB278867 October 21, 2013
275328 ACC2002: Error Importing XML Files into Microsoft Access Projects (ADPs) Q275328 KB275328 October 21, 2013
275121 ACC2002: Visual Basic for Applications Code Is Decompiled When It Is Opened in an Earlier Version of Microsoft Access Q275121 KB275121 October 21, 2013
275119 ACC2002: Data Access Page Connects to a Database on Which an Admin Password Has Been Set Without Prompting for a Password Q275119 KB275119 October 21, 2013
275116 ACC2002: A Parameter Prompt for a Memo Field Permits Only 255 Characters Q275116 KB275116 October 21, 2013
275115 ACC2002: View or Function Including TOP X or TOP X PERCENT Cannot Be Updated Q275115 KB275115 October 21, 2013
275113 ACC2002: "Record Is Deleted" Error After Synchronization Q275113 KB275113 October 21, 2013
275109 ACC2002: Thai Characters Are Not Displayed Correctly in Data Imported from Thai Database Q275109 KB275109 October 21, 2013
275106 ACC2002: Changes to a Form in PivotTable View or PivotChart View Are Not Saved in a Multi-user Environment Q275106 KB275106 October 21, 2013
275103 ACC2002: Arabic Letter "Alef" Becomes Disconnected from Words in Tables Q275103 KB275103 October 21, 2013
275093 ACC2002: Unable to Set the Recordset Label of the Navigation Bar in Browse Mode Q275093 KB275093 October 21, 2013
275092 ACC2002: Cannot Use TransferDatabase Action to Link in an Access Project Q275092 KB275092 October 21, 2013
275084 ACC2002: Using the "Create Table by Entering Data" Option Starts Primary Key Field at 22 Instead of at 1 Q275084 KB275084 October 21, 2013
275077 ACC2002: Computer Stops Responding When You Link to or Import from Outlook Address Book Q275077 KB275077 October 21, 2013
275074 ACC2002: Error Message: "Cannot Perform This Operation" When You Compact a Database by Using the ODBC Administrator Q275074 KB275074 October 21, 2013
275072 ACC2002: Get Latest Version or Check Out Fails with Recovered Microsoft Access Object Under Source Code Control Q275072 KB275072 October 21, 2013
275071 ACC2002: Data Access Pages Cannot Filter Records When Certain Words Are Used Q275071 KB275071 October 21, 2013
275070 ACC2002: Error When You Sort on a Column in a Crosstab Query Q275070 KB275070 October 21, 2013
275069 ACC2002: Date Is Displayed as a Number When You Import an Open Excel Workbook Q275069 KB275069 October 21, 2013
275066 ACC2002: Filter By Selection Does Not Handle Wildcard Characters Well Q275066 KB275066 October 21, 2013
275065 ACC2002: Selecting Visual FoxPro Database in Configure Connection Dialog Box Defaults to Free Table Directory Q275065 KB275065 October 21, 2013
275064 ACC2002: Trigger Returns an Error That User Has Deleted Record or Changed Primary Key Q275064 KB275064 October 21, 2013
275063 ACC2002: Name AutoCorrect Does Not Repair Certain Form or Report Property Settings Q275063 KB275063 October 21, 2013
275062 ACC2002: ADO EndOfRecordset Event Is Not Triggered with Form Recordsets Q275062 KB275062 October 21, 2013
275057 ACC2002: Trigger That Contains a User-Defined Error Message Cannot Be Raised Q275057 KB275057 October 21, 2013
274387 ACC2002: Drop-Down List on Data Access Page Does Not Stay in Sync with Recordset Q274387 KB274387 October 21, 2013
274378 ACC2002: Unexpected Underscore Character in a Data Access Page Name Q274378 KB274378 October 21, 2013
814858 Access may stop responding when you try to create an MDE or ACCDE file, or an ADE file Q814858 KB814858 September 30, 2011
827426 "An error occurred and this feature is no longer functioning properly" error message when you start Microsoft Script Editor Q827426 KB827426 September 17, 2011
295194 ADO help does not work if you reference ADO 2.6 object library in Access 2002 Q295194 KB295194 September 17, 2011
282366 ACC2002: Border on Data Access Page Is Not Affected by Special Effects Q282366 KB282366 September 17, 2011
226526 ACC: Error Message Using OutputTo to Output a Report to Another Format Q226526 KB226526 September 17, 2011
304226 A reactivation message appears when you start an Office XP program that was installed from an Enterprise edition Q304226 KB304226 September 13, 2011
202106 ACC2000: Changes That You Make to Referenced Projects Are Not Saved in Visual Basic Editor Q202106 KB202106 March 4, 2009
824165 ActiveX control that is contained in an Access form does not appear when the design-time license is not available Q824165 KB824165 October 30, 2008
302846 An "Application must be installed" error message occurs when you start an Office programs Q302846 KB302846 December 4, 2007
280649 Activate Product menu item remains after you activate the Office XP license Q280649 KB280649 December 4, 2007
321001 ACC2002: Error Message: The Text Is Too Long to Be Edited Q321001 KB321001 November 14, 2007
304701 ACC2002: How to Troubleshoot Corruption in a Microsoft Access Database Q304701 KB304701 May 7, 2007
302841 ACC2002: Hyperlink Text Changes to Question Marks When You Paste the Text into Other Office Programs Q302841 KB302841 January 31, 2007
291301 "ActiveX component can't create object" error message when you use Data Access Objects version 3.0 (DAO 3.0) Q291301 KB291301 January 31, 2007
290231 An Office XP program immediately quits on computers that are running the Windows NT 4.0, Windows 2000, or Windows XP operating systems Q290231 KB290231 January 31, 2007
164109 ACC: Where to Find Microsoft Access Information on the Web Q164109 KB164109 January 19, 2007
895618 An Office update does not appear to be installed after you install the update Q895618 KB895618 January 12, 2007
291162 AutoNumber field duplicates previous values after you compact and repair a database Q291162 KB291162 July 28, 2006
819780 Access 2003 or Access 2002 stops responding with an error message that references the Msaccess.exe file when you open a database file Q819780 KB819780 July 27, 2006
918957 A file does not open in the program that you expect when you try to open the file in Office Q918957 KB918957 May 24, 2006
904948 A document may take a longer time than expected to print or the print spool file may be larger in Office 2003 or in Office XP Q904948 KB904948 August 17, 2005
318096 A Chart on a report displays the incorrect data in Access 2002 Q318096 KB318096 June 23, 2005
304274 ACC2002: How to Programmatically Specify the Display Control for a Field Q304274 KB304274 June 23, 2005
304149 ACC2002: How to Bind a Microsoft Access PivotTable List to OLAP Data Sources Q304149 KB304149 June 23, 2005
304143 ACC2002: How to Programmatically Build a PivotChart View in an Access Form Q304143 KB304143 June 23, 2005
304085 ACC2002: How to Generate Random Dates Q304085 KB304085 June 23, 2005
285532 ACC2002: Reserved Error Calling ExportXML Method Q285532 KB285532 June 23, 2005
275111 ACC2002: You Are Prompted for Oracle Password Even If You Select "Save Password" Q275111 KB275111 January 26, 2005
282354 ACC2002: Database Diagram Design Pane Displays Boxes for Japanese Characters Q282354 KB282354 September 27, 2004
291546 Access displays #DELETED when you insert data with the same value into a non-unique Key column of a remote table Q291546 KB291546 August 11, 2004
821703 ACC2002: JET Commits a SQL Server Transaction Instead of Rolling the Transaction Back Q821703 KB821703 November 17, 2003
294907 ACC2002: Like "String*" Criteria Is Incorrect on Indexed (Duplicates OK) Fields That Have DBCS Characters Q294907 KB294907 November 17, 2003
826762 A Batch File or an Executable File in a Package Does Not Run at the End of the Package Installation Q826762 KB826762 November 6, 2003
287432 ACC2002: Parameter Prompt Appears Twice When You Run a Query Q287432 KB287432 November 6, 2003
287709 ACC2002: "Type Mismatch in Join Expression" Applying Filter By Form Q287709 KB287709 November 5, 2003
279150 ACC2002: Make-Table Query Does Not Format Yes/No or Bit Fields Correctly Q279150 KB279150 October 22, 2003
304180 ACC2002: How to Create a Pareto Chart That Uses a PivotChart View Q304180 KB304180 September 27, 2003
287417 ACC2002: Error with ANSI-92 Reserved Words When SQL Server Compatibility Syntax (ANSI 92) Is Enabled Q287417 KB287417 September 27, 2003
295229 ACC2002: Error Message: Operation Not Supported in Transactions Q295229 KB295229 September 26, 2003
287443 ACC2002: "Microsoft Access Failed to Create the Visual Basic Module" Error Message When You Try to Edit an Object in a Replica Q287443 KB287443 September 25, 2003
295222 ACC2002: Access Unexpectedly Quits When You Click in Filtered Group of a Data Access Page Q295222 KB295222 September 22, 2003
286584 ACC2002: ADO Filter Does Not Work with Fixed-Length Fields When You Use Microsoft Jet OLE DB Provider Q286584 KB286584 May 9, 2003

Access 2002 (Access XP) articles, fixes and updates - letter A