Access 2000 articles, fixes and updates

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

263084 How to work with the Outlook E-mail Security Update in an Access database Q263084 KB263084 January 25, 2021
180841 How to use common Data Definition Language (DDL) SQL statements for the Jet database engine Q180841 KB180841 October 1, 2020
234788 How to find the installation path of an Office application Q234788 KB234788 May 27, 2019
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
306204 How to troubleshoot corruption in a Microsoft Access database Q306204 KB306204 April 19, 2018
253580 How to connect to a remote Access database from Active Server Pages Q253580 KB253580 April 19, 2018
241141 How to install Access 97 and Access 2000 on the same computer Q241141 KB241141 April 19, 2018
209948 How to use Automation to send a Microsoft Outlook message using Access 2000 Q209948 KB209948 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
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
208714 How to create a running totals query in Access 2000 Q208714 KB208714 April 19, 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
319317 How to automate the process of selecting the printer for a report in Microsoft Access Q319317 KB319317 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
230126 How to use Paradox data with Access and Jet Q230126 KB230126 April 18, 2018
210166 How to create pop-up context-sensitive Help by using Windows API WinHelp() Q210166 KB210166 April 18, 2018
210100 How to display an image from a folder in a form or in a report in Access 2000 Q210100 KB210100 April 18, 2018
209976 How to use automation to run Word 2000 mail merge from Access 2000 Q209976 KB209976 April 18, 2018
209953 How to use the OpenDatabase method to open password-protected databases in Access 2000 Q209953 KB209953 April 18, 2018
209898 How to use TreeView control Drag-and-Drop capabilities in Access 2000 Q209898 KB209898 April 18, 2018
209137 How to troubleshoot and repair a damaged Jet 4.0 database in Access 2000 Q209137 KB209137 April 18, 2018
198571 How to call Excel functions from within Access 2000 Q198571 KB198571 April 18, 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
812718 How to reset an AutoNumber field value in Access Q812718 KB812718 April 17, 2018
210276 How to store, calculate, and compare Date/Time data in Microsoft Access Q210276 KB210276 April 17, 2018
310803 How to resolve reference issues in an Access database Q310803 KB310803 June 20, 2017
210362 HOW TO: Use the Attributes Property for TableDef Objects in Microsoft Access Q210362 KB210362 January 7, 2017
209502 How to store SQL database login IDs and passwords locally Q209502 KB209502 January 7, 2017
328828 How to troubleshoot errors that may occur when you update data in Access queries and in Access forms Q328828 KB328828 October 1, 2015
205041 How to customize the Places Bar in Office 2000 Q205041 KB205041 January 14, 2015
815278 How To Troubleshoot the User Authentication Dialog Box While Opening a Non-Secure Database Q815278 KB815278 January 10, 2015
197893 HOW TO: Use Visual FoxPro DBC Files in Microsoft Access 2000 Q197893 KB197893 December 24, 2014
284273 How to deploy Office 2000 over a network Q284273 KB284273 December 23, 2014
274680 How to use MFC to retrieve a list of macro names in an Office document Q274680 KB274680 December 23, 2014
252613 How to remove all components of Office 2000 CD2 in Windows 2000 Q252613 KB252613 December 23, 2014
243788 How to install Office 2000 CD2 on Windows Terminal Server Q243788 KB243788 December 23, 2014
300216 How to keep a Jet 4.0 database in top working condition in Access 2000 Q300216 KB300216 June 22, 2014
262584 How to install Office 2000 to Windows NT 4.0 Terminal Server Q262584 KB262584 November 2, 2013
318816 How to use Application roles with Access projects and SQL Server 2000 Desktop Engine Q318816 KB318816 October 26, 2013
296179 How to share a database in a dual-version environment Q296179 KB296179 October 26, 2013
288947 How to find information about designing a database in Access 2000 Q288947 KB288947 October 26, 2013
245226 How to troubleshoot the issues with Office 2000 installation from a CD Q245226 KB245226 October 26, 2013
234301 HOW TO: Look Up Values in a Data Access Page in Access 2000 Q234301 KB234301 October 26, 2013
210613 How to find the location or locations of a file in Microsoft Access Q210613 KB210613 October 26, 2013
210326 HOW TO: Create an AfterUndo Form Event in Access 2000 Q210326 KB210326 October 26, 2013
210154 HOW TO: Change the Owner of a New Table in Access 2000 Q210154 KB210154 October 26, 2013
210024 HOW TO: Use Automation to Set Microsoft Graph Trend Lines in Access 2000 Q210024 KB210024 October 26, 2013
207664 HOW TO: Repeat Report Records a Specified Number of Times in Access 2000 Q207664 KB207664 October 26, 2013
199304 How to find a record using ADO and Jet OLE DB provider in Access 2000 Q199304 KB199304 October 26, 2013
197219 HOW TO: Query Records Within Range of Each Other in Access 2000 Q197219 KB197219 October 26, 2013
304355 HOW TO: Convert a Select Query to an Action Query in Access 2000 Q304355 KB304355 October 25, 2013
302502 How to start Microsoft backup from Access 2000 and Access 2002 Q302502 KB302502 October 25, 2013
259224 HOW TO: Determine the User Name in a Data Access Page in an Access 2000 Project Q259224 KB259224 October 25, 2013
240293 How to deploy an Access 2000 project that includes the Microsoft Data Engine Q240293 KB240293 October 25, 2013
218621 HOW TO: Have List Box Respond to Entire String You Type in Access 2000 Q218621 KB218621 October 25, 2013
210334 HOW TO: Automatically Detect If a Form Is Being Edited in Access 2000 Q210334 KB210334 October 25, 2013
210021 HOW TO: Use Automation to Change a Graph Chart Type in Access 2000 Q210021 KB210021 October 25, 2013
209876 HOW TO: Determine When a Shelled Process Ends in Access 2000 Q209876 KB209876 October 25, 2013
208596 How Windows regional settings affect Microsoft Access 2000 Q208596 KB208596 October 25, 2013
207593 HOW TO: Print Randomly Selected Records in Access 2000 Q207593 KB207593 October 25, 2013
203370 HOW TO: Completely Remove Access 2000 from Your Computer Q203370 KB203370 October 25, 2013
198756 HOW TO: Use Connection Control to Prevent User Log On at Run Time in Access 2000 Q198756 KB198756 October 25, 2013
198461 HOW TO: Animate the Office Assistant in Access 2000 Q198461 KB198461 October 25, 2013
319481 HOW TO: Use Sample Automation Code to Transfer Tables to a Secured Access 2000 MDB File Q319481 KB319481 October 24, 2013
304321 How to use DDL to change the data type of a field Q304321 KB304321 October 24, 2013
304313 HOW TO: Remove the Control Box (System Menu) from a Report Preview Window in Access 2000 Q304313 KB304313 October 24, 2013
224333 How to track successful deletions on bound ADP forms in Access 2000 Q224333 KB224333 October 20, 2013
217132 Help incorrectly states Memo column cannot be sorted on Q217132 KB217132 October 14, 2013
203107 HOW TO: Use the TotalType Property of a Control on a Data Access Page in Access 2000 Q203107 KB203107 October 11, 2013
193006 How to reset personal menus in Office XP and Office 2000 programs Q193006 KB193006 September 3, 2013
239114 How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine Q239114 KB239114 July 12, 2013
209207 How to use command-line switches in Microsoft Access Q209207 KB209207 July 12, 2013
302751 How to remove the Office 2000 Service Release SR-1/SR-1a update Q302751 KB302751 October 24, 2012
871146 How to troubleshoot general printing problems in Windows 2000 when you are using Office products Q871146 KB871146 October 12, 2012
325017 How to use Access 2000 Upsizing Wizard Q325017 KB325017 August 10, 2012
221190 How to use the Office 2000 Clipboard Q221190 KB221190 February 17, 2012
870622 How to troubleshoot problems that you may experience when you try to print to a local printer by using Office programs in Windows XP Q870622 KB870622 September 18, 2011
841779 How to reset the page number and the total page count for each group in a Microsoft Access report Q841779 KB841779 September 17, 2011
304165 How to download and install an update to an administrative installation of Office 2000 Q304165 KB304165 February 9, 2011
210297 How to detect User Idle Time or Inactivity in Access 2000 Q210297 KB210297 April 28, 2009
888696 How to print a check box without borders on a pre-printed form in Access Q888696 KB888696 October 30, 2008
318881 How to use a recordset to send Outlook e-mail to multiple recipients in Microsoft Access Q318881 KB318881 October 30, 2008
291264 How to refresh links in a runtime application in Microsoft Access Q291264 KB291264 October 30, 2008
289580 How to determine which user has opened a database exclusively in Access Q289580 KB289580 October 30, 2008
210236 How to fill a record with data from a previous record automatically in Access 2000 and 2002 and Office Access 2003 Q210236 KB210236 October 30, 2008
870968 How to troubleshoot general printing problems in Windows Server 2003 when you use Office products Q870968 KB870968 October 29, 2008
198687 How to install real mode CD-ROM drive drivers in Windows 98 Q198687 KB198687 May 29, 2008
177512 How to select a compatible printer driver for your printer How to select a compatible printer driver for your printer when you use Office 97, Office 2000, or Office XP Q177512 KB177512 April 29, 2008
210581 How to use code to derive a statistical median Q210581 KB210581 December 12, 2007
208502 How to enumerate selected form records in Access 2000 Q208502 KB208502 November 7, 2007
266134 How to find Office 2000 updates Q266134 KB266134 October 3, 2007
288367 How to configure Office applications to run under a specific user account Q288367 KB288367 August 23, 2007
208840 How to use code to change a report's printer in Access 2000 Q208840 KB208840 August 17, 2007
216399 How to convert between ASCII and EBCDIC character codes Q216399 KB216399 July 20, 2007
237957 How to use an Office 2000 Setup log file to troubleshoot Office Setup problems Q237957 KB237957 July 19, 2007
288368 How to configure Office applications for automation from a COM+/MTS package Q288368 KB288368 July 2, 2007
233499 How to change the company name and user name in the About <program name> window after you install Office 2000 Q233499 KB233499 May 7, 2007
288366 How to configure Office applications to run under the interactive user account Q288366 KB288366 March 28, 2007
245025 How to obtain and install the Office 2000 SR-1/SR-1a Update Q245025 KB245025 March 22, 2007
240216 How Office 2000 manages templates Q240216 KB240216 March 22, 2007
255782 How To Use ADO and ADOX to Modify the Base Query of an Access QueryDef Object in Visual Basic Q255782 KB255782 February 12, 2007
246255 How To Use a SQL Server 7.0 Distributed Query with a Linked Server to Secured Access Databases Q246255 KB246255 February 12, 2007
314598 How to retrieve a lost or hidden Database window in Microsoft Access Q314598 KB314598 January 31, 2007
313454 How to clear the Most Recently Used list (MRU) list in Office programs Q313454 KB313454 January 31, 2007
296067 How to use msiexec.exe and the globally unique identifier (GUID) of the product to remove suite or stand-alone Office 2000 programs Q296067 KB296067 January 31, 2007
290359 How to remove leading space for values converted to strings Q290359 KB290359 January 31, 2007
287484 How to download and install an administrative update available for the Access 2000 and SQL Server 2000 Readiness Update Q287484 KB287484 January 31, 2007
279299 How to troubleshoot the installation of Office 2000 SP2 by using the log file Q279299 KB279299 January 29, 2007
264625 How to install or repair individual features of Office 2000 Q264625 KB264625 January 27, 2007
261997 How To Obtain the Window Handle for an Office Automation Server with MFC Q261997 KB261997 January 27, 2007
247771 How to recover data from a damaged database table or a corrupted database table in Access 2000, Access 2002 or Access 2003 Q247771 KB247771 January 27, 2007
247684 How to remove Office 2000 CD2 Q247684 KB247684 January 25, 2007
238251 How to Install Windows Messaging After You Remove Outlook 2000 or Office 2000 from Windows 95 Q238251 KB238251 January 24, 2007
238228 How to build an Office 2000 COM add-in in Visual Basic Q238228 KB238228 January 24, 2007
238122 How to install Office 2000 or Office XP on a computer that is running Windows Millennium Edition, Windows 95, or Windows 98 with User Profiles and without User Profiles Q238122 KB238122 January 24, 2007
219423 How to remove the Office 2000 CD1 Q219423 KB219423 January 24, 2007
201735 How to create USysRegInfo table for installing add-ins in Microsoft Access Q201735 KB201735 January 23, 2007
200378 How to install Windows 98 to a new folder to troubleshoot problems in Office 2000 Q200378 KB200378 January 23, 2007
192919 How To Automate a Secured Access Database Using Visual Basic Q192919 KB192919 January 23, 2007
310744 How To Dismiss a Dialog Box Displayed by an Office Application by Using Visual C++ .NET and MFC Q310744 KB310744 January 17, 2007
307292 How To: Dismiss a Dialog Box Displayed by an Office Application with Visual Basic .NET Q307292 KB307292 January 17, 2007
259971 How To Dismiss a Dialog Box Displayed by an Office Application with Visual Basic Q259971 KB259971 January 17, 2007
907349 How to troubleshoot video issues in Office programs Q907349 KB907349 December 7, 2006
889588 How to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients Q889588 KB889588 October 30, 2006
302087 How to run Office 2000 from a network server Q302087 KB302087 October 13, 2006
231801 HOW TO: Skip Used Mailing Labels and Print Duplicates in Access 2000 Q231801 KB231801 October 11, 2006
231797 How to fax from Microsoft Access by using the SendObject command in Access 2000 Q231797 KB231797 October 11, 2006
210600 HOW TO: Use a Button to Hide and Display a Subform in Access Q210600 KB210600 October 11, 2006
210596 HOW TO: Use the DeleteControl and DeleteReportControl Statements, and the CreateGroupLevel() Function in Access 2000 Q210596 KB210596 October 11, 2006
210537 HOW TO: Sample Function to Remove Alpha Characters from a Numeric Field in Access 2000 Q210537 KB210537 October 11, 2006
210448 HOW TO: Find the Number of Days in a Month in Access 2000 Q210448 KB210448 October 11, 2006
210285 HOW TO: Set Subreport's RecordSource Property at Run Time in Access 2000 Q210285 KB210285 October 11, 2006
210271 How to send the current record to Word 2000 with automation Q210271 KB210271 October 11, 2006
210249 HOW TO: Get the Fiscal Year or Month of a Particular Date in Access 2000 Q210249 KB210249 October 11, 2006
210185 HOW TO: Convert Short Time Format to Different Formats in Access 2000 Q210185 KB210185 October 11, 2006
210179 HOW TO: Use Optional Arguments in Access 2000 Q210179 KB210179 October 11, 2006
210132 HOW TO: Use Automation to Print Microsoft Access Reports in Access 2000 Q210132 KB210132 October 11, 2006
210030 HOW TO: Use Automation to Print a Microsoft Word Document using Access 2000 Q210030 KB210030 October 11, 2006
210001 How to programmatically create a Schema.ini file in Access 2000 Q210001 KB210001 October 11, 2006
209974 How to create command bars by using Visual Basic code in Access 2000 Q209974 KB209974 October 11, 2006
209960 How to create sample Visual Basic for Applications code that uses Automation to create a PowerPoint 2000 presentation in Access 2000 Q209960 KB209960 October 11, 2006
202116 HOW TO: Create a Parameterized Jet Stored Procedure using DDL in Access 2000 Q202116 KB202116 October 11, 2006
197592 How to create an audit trail of record changes in a form in Access 2000 Q197592 KB197592 October 11, 2006
251326 How to determine the user name in a data access page in a Microsoft Access 2000 database (MDB) Q251326 KB251326 July 3, 2006
264080 How to deploy data access pages over the Internet Q264080 KB264080 April 10, 2006
237575 How to revert to the Access 97 ODBC driver if MDAC 2.1 overwrites the Access 97 ODBC driver with the Access 2000 ODBC driver Q237575 KB237575 January 6, 2006
255275 How to determine the version of your Office 2000 program Q255275 KB255275 December 20, 2005
222101 How to find and use Office object model documentation Q222101 KB222101 November 22, 2005
303066 How to use the Common Dialog API in an Access database Q303066 KB303066 July 5, 2005
210290 How to add '(all)' to a combo box or a list box control in an Access 2000 application Q210290 KB210290 June 23, 2005
210242 How to implement Query by Form (QBF) with dynamic QueryDef in Access 2000 Q210242 KB210242 June 23, 2005
210064 HOW TO: Determine If a Date Falls on a Weekend or on a Holiday in Access 2000 Q210064 KB210064 June 23, 2005
210032 HOW TO: Use Automation to Find a Location in a Word Document in Access 2000 Q210032 KB210032 June 23, 2005
209891 How to fill a Treeview control recursively in Access 2000 Q209891 KB209891 June 23, 2005
209862 How to relink back-end tables with the common dialog control in Access 2000 Q209862 KB209862 June 23, 2005
202176 HOW TO: Transpose Data in a Table or Query in Access 2000 Q202176 KB202176 June 23, 2005
198755 How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access 2000 Q198755 KB198755 June 23, 2005
210111 How to use Access 2000 as an Automation Server Q210111 KB210111 March 4, 2005
282010 How to find information about Microsoft Jet 4.0 Service Pack 7 Q282010 KB282010 November 16, 2004
209726 HOW TO: Import Spreadsheets from MS Works for Windows in Access 2000 Q209726 KB209726 November 16, 2004
197894 How to import a Works database file into Access 2000 database Q197894 KB197894 November 16, 2004
243842 How to create a Data Access Page linked to Access database in a FrontPage Web Q243842 KB243842 September 28, 2004
239482 How to configure Jet 4.0 to prevent unsafe functions from running in Access 2000 and Access 2002 Q239482 KB239482 August 10, 2004
304361 HOW TO: Create a Select Query in Microsoft Access 2000 Q304361 KB304361 August 9, 2004
304353 How to create a parameter query in Access 2000 Q304353 KB304353 August 9, 2004
304348 HOW TO: Create a Crosstab Query in Microsoft Access 2000 Q304348 KB304348 August 9, 2004
209183 How to delete duplicate records from a table in Access 2000 Q209183 KB209183 July 29, 2004
275262 How to retrieve Exchange and Outlook data with the Jet 4.0 OLE DB provider in Access 2000 Q275262 KB275262 July 28, 2004
235422 How to open a password-protected database through Automation in Access 2000 Q235422 KB235422 July 28, 2004
209645 How to use the Query by Form (QBF) technique in Access 2000 Q209645 KB209645 July 28, 2004
209099 How to refer to a control on a subform or subreport in Access 2000 Q209099 KB209099 July 28, 2004
323202 HOW TO: Change the Values in a Hyperlink Field from an HTTP Address to a MAILTO Address in Microsoft Access 2000 Q323202 KB323202 July 16, 2004
240794 How to Determine the Path for an Office Application Q240794 KB240794 July 15, 2004
209172 HOW TO: Use the ControlSource Property to Store Calculated Values in Access 2000 Q209172 KB209172 July 15, 2004
247985 How To Find the Path and Version of an Office Application from Visual C++ Q247985 KB247985 June 30, 2004
207660 HOW TO: Create a Custom Paper Size in Windows NT 4.0 using Access 2000 Q207660 KB207660 June 30, 2004
214183 HOW TO: Use Mail Merge with an Access Parameter Query in Word 2000 Q214183 KB214183 June 29, 2004
208200 HOW TO: Edit Data in a Hyperlink Field in a Table in Access 2000 Q208200 KB208200 June 29, 2004
207744 HOW TO: Change the Caption of a Control on a Data Access Page in Access 2000 Q207744 KB207744 June 29, 2004
209116 HOW TO: Base Subforms on SQL Pass-Through Queries in Access 2000 Q209116 KB209116 June 28, 2004
207875 HOW TO: Change or Disable the Office Assistant in Access 2000 Q207875 KB207875 June 28, 2004
207636 HOW TO: Create a Chart That Does Not Summarize Data in Access 2000 Q207636 KB207636 June 28, 2004
207672 HOW TO: Open Microsoft Access 2000 to a Specific Form by Using a Shortcut Q207672 KB207672 June 24, 2004
209095 HOW TO: Select Controls on Subform with SetFocus Method in Access 2000 Q209095 KB209095 December 12, 2002

Access 2000 articles, fixes and updates - letter H