| 20566 | You may receive an error message when you try to install or run an Office program: This patch package could not be opened or The installation source for the product is not available |
| 20567 | Description of the security update for Office XP, for Project 2002, and for Visio 2002: February 13, 2007 |
| 20568 | Description of the security update for Office XP, for Project 2002, and for Visio 2002: February 13, 2007 |
| 20569 | 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 |
| 20570 | Error message when you try to edit documents in Office XP or in Office 2003: This command is not available because the document is locked for editing |
| 20571 | You receive an out of memory error message in Access 2003 and Access 2002 when you use grouped controls |
| 20572 | 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 |
| 20573 | Users experience problems when they try to use Internet Explorer or a shortcut to open an Access database if the database is already opened by a user |
| 20574 | Description of the Jet 4.0 Database Engine post-837001 hotfix package: April 12, 2005 |
| 20575 | Description of the security update for Office XP: October 10, 2006 |
| 20576 | MS06-062: Vulnerabilities in Office could allow remote code execution |
| 20577 | The icon is blank when you insert an object or a file into a document, presentation, spreadsheet, or other Microsoft Office file |
| 20578 | Description of the Office XP post-Service Pack 3 hotfix package: August 17, 2006 |
| 20579 | Description of the Jet 4.0 Database Engine post-837001 hotfix package: May 11, 2006 |
| 20580 | Description of the security update for Office XP: August 8, 2006 |
| 20581 | MS06-047: Vulnerability in Microsoft Visual Basic for Applications could allow remote code execution |
| 20582 | Description of the security update for Office XP, for Project 2002, and for Visio 2002: August 8, 2006 |
| 20583 | How to change the source for a client computer from an updated administrative installation point to an Office XP original release version baseline source |
| 20584 | Description of the Access 2002 post-Service Pack 3 hotfix package for the Estonian version of Access 2002: June 6, 2006 |
| 20585 | Description of the security update for Office XP: July 11, 2006 |
| 20586 | Description of the security update for Office XP, the security update for Project 2002, and the security update for Visio 2002: July 11, 2006 |
| 20587 | A file does not open in the program that you expect when you try to open the file in Office |
| 20588 | The following events and properties are not available in Access 2002, even though these events and properties are documented in the Access 2002 Help system.... |
| 20589 | Discusses an error message that you receive in a stand-alone version of Access 2002. You receive the message when you install Microsoft Access 2002 as a stand-alone product on a computer that has Microsoft Office 2000 Small Business Edition... |
| 20590 | Describes the Access 2002 issue that is fixed in the Access 2002 post-Service Pack 3 hotfix package that is dated November 16, 2004. |
| 20591 | Describes the issues that are fixed in the Access 2002 post-Service Pack 3 hotfix package that is dated September 10, 2004. |
| 20592 | Discusses the references that you may have to set when you work with databases that you create in Access 2002. |
| 20593 | Lists the enhancements and behavior fixes that are addressed in Access 2002, it also provides an overview of some new features and design changes. Requires knowledge of the user interface on single-user computers. |
| 20594 | Describes the ActiveX controls that are supported in Access 2002. |
| 20595 | Error message when you use Office Genuine Advantage to validate Office 2003 or Office XP: Validation Incomplete or Error code: 0x8018103 |
| 20596 | Error message when you try to validate Office 2003 or Office XP by using Office Genuine Advantage: Unable to Validate or Error code: 0x8018111 |
| 20597 | Error message when you use Office Genuine Advantage to validate Office 2003 or Office XP: Validation Incomplete or Error code: 0x8018101 |
| 20598 | Error message when you use Office Genuine Advantage to validate Office 2003 or Office XP: Validation Incomplete or Error code: 0x8018110 |
| 20599 | Error message when you try to validate Office 2003 or Office XP by using Office Genuine Advantage: Validation Incomplete: No Office Products Detected or Error code: 0x8018109 |
| 20600 | Description of the Office XP post-Service Pack 3 hotfix package: March 31, 2006 |
| 20601 | Description of Access 2002 post-Service Pack 3 hotfix package: March 11, 2006 |
| 20602 | Description of Access 2002 post-Service Pack 3 hotfix package: March 15, 2006 |
| 20603 | You receive an error message when you start Visual Basic for Applications code in an Access database |
| 20604 | When you double-click Jetcopkg.exe to install the Microsoft Office 2000 ODBC Vulnerability Update, you are prompted to insert Microsoft Office 2000 Disc 2. When you insert the disc, you receive the following error message: Please insert the disk:... |
| 20605 | When you double-click Jetcopkg.exe to install the Microsoft Office 2000 ODBC Vulnerability Update, you are prompted to insert your Microsoft Office 2000 Premium CD. When you insert the disc, you receive the following error message: Please insert... |
| 20606 | When you attempt to run Microsoft Office Setup normally after previously running it in quiet mode, you may receive the following error message: Microsoft Office 2000 installation was not completed successfully. Click Continue to resume... |
| 20607 | During installation of Microsoft Office 2000, when you press the ENTER key and the Installing Microsoft Office 2000 dialog box is visible, the Exit Microsoft Office 2000 Setup confirmation box may appear. The Exit Microsoft Office 2000 Setup... |
| 20608 | When you upgrade to Office 2000 and you are prompted to remove previous versions of Office programs, more programs may be listed in the Microsoft Office 2000: Removing Previous Versions dialog box than are actually installed on your computer. The... |
| 20609 | When you run Setup for Microsoft Office, you may receive the following error message: Microsoft Office 2000 setup needs to replace some Windows system components. This requires administrator rights. Please log in as an administrator to complete... |
| 20610 | When installing Office, the UserName and CompanyName fields are filled in, even if you use a command line switch or transform(.mst) file to suppress these fields. This will occur when you attempt to set the UserName and CompanyName properties to... |
| 20611 | When you try to install Microsoft Office 2000, the following error message may appear: A newer version of DCOM95 had been installed. To override, you must uninstall the current version first. Your only option on the dialog box is to click OK .... |
| 20612 | When you run the Office Setup program and you click Customize in the Ready to Install dialog box, the Keep these programs check box is unavailable in the Remove Previous Versions dialog box. The Keep these programs check box may be unavailable if... |
| 20613 | When you upgrade to Office 2000, the Task Scheduler may be started. This occurs even if the Task Scheduler was turned off prior to installing Office. This behavior occurs when you install Office and you choose to install Microsoft Internet... |
| 20614 | When you install the Windows Installer files, the following registry keys below HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Windows\Installer are reset to a value of 0 (zero): AlwaysInstallElevatedDisableBrowseDisablePatch For security reasons,... |
| 20615 | When you run Office Setup using a command-line that includes the /j switch ( /jm or /ju ), some command-line properties or switches are ignored. For example, if you use the following command-line to start setup path\setup.exe /jm data1.msi... |
| 20616 | When you install the Microsoft Office 2000 Resource Kit (ORK), the Motionless Office Assistant (Stillogo.acs) is unexpectedly installed to the \Program Files\Microsoft Office\Office folder. This occurs even though you installed Office to a... |
| 20617 | The size of the selected features in the Microsoft Office 2000: Update Features dialog box is shown as 1280KB, even though you have not chosen to add any new features to your Office installation. In addition, the size will never show as less than... |
| 20618 | When you install Office, you do not see an alert advising you that Setup is finished. The only indication Setup has finished is that the dialog box with the progress indicator, Finishing Microsoft Office 2000 Setup disappears. You will not see an... |
| 20619 | When you perform a Custom set up for Office and you set the Microsoft Internet Explorer 5 installation state to Windows Web Browsing Component Only , Internet Explorer 5 is installed anyway. A minimal installation of Internet Explorer 5 will be... |
| 20620 | If you run Office Setup in Maintenance Mode, there is no way to install Microsoft Internet Explorer 5. The option to install or not install Internet Explorer 5 is only available when you are running Office Setup and Office is not currently... |
| 20621 | In each version of Microsoft Office, you can configure settings to customize the user interface. When you upgrade to Office 2000, however, you might discover that new settings have been added, and familiar settings have moved or disappeared. To... |
| 20622 | There may be a situation in which you cannot use your mouse to work with the feature tree in the Microsoft Office 2000: Selecting Features dialog box. The More Information section of this article provides the keyboard shortcuts that you can use... |
| 20623 | When you uninstall Office, modified templates and sample files such as the Northwind sample database, are removed. This problem will occur when the following are true: You modify a sample file or template from Office. -and-You set a sample file or... |
| 20624 | When you run Office Setup, you receive the following alert after the initial portion of setup has finished: The installer must restart your system before configuration of Office 2000 Product can continue. Click Yes to restart now or No if you... |
| 20625 | When you run Setup for Office, the following error message may appear: This installation is forbidden by system policy. Contact your system administrator. This error message may appear if all of the following are true: You have the Disable browse... |
| 20626 | Even though the Always install with elevated privileges System Policy from the Microsoft Office 2000 Resource Kit is in effect when you run setup for Office, you may receive the following error: Installing this product requires Administrative... |
| 20627 | When you run Intuit Quicken 98 and generate an EasyAnswer Report, digits in the report may appear with large spaces between them. For example, if the report displays the following number: 1234.56 it instead appears as the following: 1 2 3 4 . 5 6 |
| 20628 | Nothing happens when you double-click your Microsoft Binder documents after you install Office. The Binder files display the generic Microsoft Window icon. Binder is not installed with the default installation of Office. To install Binder, follow... |
| 20629 | When you run Microsoft Office 2000 Setup, you receive the following error message: Could not find a package to install on the installation media. This problem occurs when the following conditions are true: You run Setup from an administrative... |
| 20630 | When you upgrade from Microsoft Office 4.x to Microsoft Office 2000, the Microsoft Office Shortcut Bar in Microsoft Office 2000 does not retain the customized View settings that you have made to the Microsoft Office Manager. This problem occurs... |
| 20631 | After you upgrade to Office 2000, if any version of Microsoft Bookshelf has been installed previously the Bookshelf Edit menu is missing the following commands: Copy to WordCopy to ExcelCopy to PowerPoint To work around this problem, in Bookshelf... |
| 20632 | 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 |
| 20633 | When you run the System Information utility, the Applications section that lists all the installed Microsoft Office programs is missing. This problem will occur when you do the following: You install Office 2000 on Microsoft Windows 95. -and-You... |
| 20634 | When you run Microsoft Office Setup in maintenance mode and remove the templates, the Setup program removes database files that you modified using the spreadsheet templates. For example, Common.xls and Expdb.xls database files are removed. The... |
| 20635 | If you run the Microsoft Office 2000 Setup program in maintenance mode and click Remove Office , the Setup program does not remove a number of folders, shortcuts to files, and .tmp files located in the following folder: C:\Windows\Application... |
| 20636 | You receive an error message when you try to create or to modify the design of an SQL object in Office Access 2003 or in Access 2002 |
| 20637 | #Deleted is displayed in the records when you open a linked ODBC table from an Oracle 10g database in Access 2003, in Access 2002, or in Access 2000 |
| 20638 | The wizard uses the run-time files that are included with the release version of Access when you create an installation package for an application in Access 2003 or in Access 2002 |
| 20639 | Description of the updates for Office XP: March 14, 2006 |
| 20640 | When you install Office, the UserName and CompanyName fields are filled in, even if you use a command-line switch or transform (.mst) file to suppress these fields. This problem occurs when you attempt to set the UserName and CompanyName... |
| 20641 | When you remove Microsoft Office from your computer, modified templates and sample files such as the Northwind sample database, are removed. This problem occurs when the following conditions are true: You modify a sample file or template from... |
| 20642 | When you install Microsoft Office XP and you attempt to select a custom installation option, neither Run from CD nor Run all from CD appears as an installation option for any Office program or any feature in the Office feature tree. This behavior... |
| 20643 | When you install Microsoft Office XP from a network, the Setup program may stop responding (crash) and you may have to completely reinstall Office. Before Setup stops responding, the following (or similar) error message may appear: Error 1316: A... |
| 20644 | When you perform a Custom Install of Microsoft Office XP, your changes to the Features to Install settings are not saved. This issue occurs when the following conditions are all true: You select Custom Install.You make changes to the Features to... |
| 20645 | When you upgrade Microsoft Office 2000 to Office XP, buttons for removed Office 2000 programs may unexpectedly remain on the Office Shortcut Bar. This behavior occurs in the following situation: You customize the Office 2000 Shortcut Bar to... |
| 20646 | Jet 4.0 data engine update fixes issues that may occur on a Windows XP-based computer |
| 20647 | You cannot access Microsoft Office Online from a Microsoft Office 2003 program |
| 20648 | Description of the Office XP post-Service Pack 3 hotfix package: December 16, 2005 |
| 20649 | Description of the Office XP post-Service Pack 3 hotfix package: December 20, 2005 |
| 20650 | Description of the Dutch spelling checker for the Dutch version of Office XP post-Service Pack 3 and the Dutch Office XP Multilingual User Interface post-Service Pack 3 hotfix package: December 9, 2005 |
| 20651 | Description of the Office XP post-Service Pack 3 Proofing Tools Kit for the Dutch spelling checker hotfix package: December 9, 2005 |
| 20652 | Description of the Access 2002 post-Service Pack 3 hotfix package: November 2, 2005 |
| 20653 | The Private Bytes counter in Performance Monitor may continually increase when an ActiveX control is updated in an Office XP document |
| 20654 | Description of Office XP post-Service Pack 3 hotfix package: October 5, 2005 |
| 20655 | Description of Office XP post-Service Pack 3 hotfix package: September 6, 2005 |
| 20656 | Description of the Access 2002 post-Service Pack 3 hotfix package: July 12, 2005 |
| 20657 | Description of the update for Access 2002: October 18, 2005 |
| 20658 | You are offered an update for Access 2002 when you check for updates on the Microsoft Office Update Web site or on the Microsoft Update Web site |
| 20659 | How to troubleshoot video issues in Office programs |
| 20660 | You cannot embed an Adobe OpenType font in a document that is in an Office program |
| 20661 | You cannot change, add, or delete data in tables that are linked to an Excel workbook in Office Access 2003 or in Access 2002 |
| 20662 | How to change the source for a client computer from an updated administrative installation point to an Office 2003 or Office XP original baseline source |
| 20663 | You are unexpectedly prompted to restart the computer after you install an Office service pack or an Office update |
| 20664 | Description of the Microsoft Office XP Proofing Tools Kit hotfix package: September 1, 2005 |
| 20665 | Description of the proofing tools for the Dutch version of Office XP post-Service Pack 3 hotfix package: September 1, 2005 |
| 20666 | Description of the Portuguese (Brazilian) proofing tools for the Office XP post-Service Pack 3 hotfix package: August 29, 2005 |
| 20667 | 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 |
| 20668 | When you create a database or a table, an error occurs and Access unexpectedly closes in Office Access 2003 or in Access 2002 |
| 20669 | Custom changes that you made in the HKEY_CLASSES_ROOT subtree are overwritten after you update or repair the Office installation |
| 20670 | Provides information about how to remove Microsoft Office updates. The ability to remove Office updates was added to certain Office updates that are dated July 12, 2005 and later. |
| 20671 | Description of the Office XP Post-Service Pack 3 hotfix package: May 20, 2005 |
| 20672 | The Script Editor unexpectedly quits when you use the Script Editor for the first time in an Office program |
| 20673 | Office updates are not successfully installed on some client computers when you deploy updates by using Windows Server Update Services |
| 20674 | Description of the Italian Proofing Tools for Office XP post-Service Pack 3 hotfix package: July 15, 2005 |
| 20675 | The installation state of each Office XP program is shown as Not Available when you try to perform a custom installation of Office XP or of an individual Office XP program |
| 20676 | No updates are displayed when you scan for updates by using Microsoft Update or Windows Software Update Services after you connect to a Microsoft Office administrative installation point to reinstall Office |
| 20677 | Description of the Arial Narrow font for Office XP post-Service Pack 3 hotfix package: April 6, 2005 |
| 20678 | When you type your CD key in the Welcome to Microsoft Office 2000 dialog box, you may accidentally overwrite part of the CD key. This problem may occur when you use BACKPSACE to correct a mistake while you type the CD key. When you use BACKSPACE... |
| 20679 | When you import a Microsoft Word table that contains carriage returns in its cells, the table is not imported correctly because Microsoft Access interprets each carriage return/line feed as a new record delimiter. To avoid this problem, you can... |
| 20680 | Describes the Microsoft Access 2002 issue that is fixed in the Access 2002 post-Service Pack 3 hotfix package that is dated March 3, 2005. |
| 20681 | How to troubleshoot problems that you may experience when you try to activate an Office product |
| 20682 | You may receive a The Visual Basic for Applications project in the database is corrupt error message when you try to open an object that is in a compiled database or in a compiled project in Access 2002, in Access 2002 SP1, or in Access 2002 SP2 |
| 20684 | Describes a problem in Office Access where you receive an error message when you run a query. Or, you do not receive an error message but a Memo field is truncated to 255 characters. |
| 20685 | The following is a list of the supported methods for installing Microsoft Office 2000 on a workstation: Run Setup from a Microsoft Office 2000 CD.Run Setup from a server on which an administrative installation of Microsoft Office was performed.... |
| 20686 | Describes methods for how to create a DSN-less connection to SQL Server for linked tables in Microsoft Access. |
| 20687 | Discusses a work around for an issue that occurs in Office XP and Office 2003 where an Excel chart that contains an embedded arrowhead does not appear exactly in its original form when it is pasted to a Word document. |
| 20688 | This update resolves a security vulnerability that could allow malicious code to run when you store or open Microsoft Office documents from a Web site. |
| 20689 | Describes how to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients. |
| 20690 | When you install Microsoft Office, menu items on the Start menu that belong to Office 95 or Office 97 programs are overwritten by the menu items that belong to Office 2000 programs. This behavior occurs because the Setup programs for Office 2000,... |
| 20691 | When you install Office 2000, Microsoft Internet Explorer 5.0 either is not installed completely or is not installed at all. You do not receive a message to indicate that Microsoft Internet Explorer 5.0 is not installed correctly, in either... |
| 20692 | When you run the Microsoft Office Setup program, your previous version of Office may be removed without alerting you. However, you may see the following message during Setup: Microsoft Office 2000: Remove Previous Versions Setup will remove the... |
| 20693 | Explains that the Activate Product menu item unexpectedly remains on the Office Tools menu after you install Office XP and activate the license. You receive the This product has already been activated message when you click Activate Product. |
| 20694 | One of the new types of queries added to Microsoft Access version 2.0 for Windows is called a TOP N query. If you have Microsoft Access version 2.0 or higher, and Microsoft Visual Basic for Windows version 4.0 and higher, you can use this type of... |
| 20695 | Describes that you may receive A program is trying to automatically send e-mail on your behalf message when you run the SendObject macro action. Or, you may receive a run-time error '2293' when calling the SendObject VBA method in Access. |
| 20696 | You may not be able to edit a record on a form even though the AllowEdits property of the form is set to Yes . When you try to update data on the form, you may receive the following error message: This Recordset is not updateable. If the form is... |
| 20697 | Describes a problem that may occur when you use the SendObject macro action or the SendObject method in Access 2003. |
| 20698 | Explains that you cannot insert a record in a multi-table query and you receive a write conflict error if the primary key field of the primary table is an identity field or the query restricts the records to exclude some records from the primary table. |
| 20699 | Provides detailded steps on how to display a status message to inform users that they must wait for an action to be completed. It uses the sample database Northwind.mdb to show you how to create a Please Wait status message. |
| 20700 | Explains how to use the SelTop and SelHeight form properties to specify or determine the number of selected records in a continuous or Datasheet view form. Requires basic macro, coding, and interoperability skills. |
| 20701 | Explains that the date is not updated when you select a date on a Calendar control. The control does not update the field specified in the ControlSource property of the control until you either move the focus to another control or save the record. |
| 20702 | Explains that you will see a blank help window if you try to bring up context sensitive Help for ADO 2.6 by pressing F1 since the ADO 2.6 help file is not included with the core MDAC 2.6 installation file. |
| 20703 | Explains why you see no prompts for a company name or a CD key when you install an administrative installation of an Office 2000 product. This issue occurs when you install from an OEM version of Office 2000 products. |
| 20704 | Describes how you receive an error message when you start Office 2000 Setup from a hyperlink and Setup refers to a transform created by the Custom Installation Wizard. To resolve this problem, you can apply the Office 2000 SR-1/SR-1a update. |
| 20705 | Explains that you receive an error message when you install Office 2000. This problem occurs when you install from a source that contains spaces in the path name. To work around this problem, you can modify the source path. |
| 20706 | Explains an error message that you receive when you are prompted to restart Windows after you run Office 2000 programs for the first time. You can safely ignore this error message and your Office programs will still function correctly. |
| 20707 | Explains that Binder may not appear in the Office 2000 Tools program group even if you chose it during setup. You can create a new Office document and then cancel it in the New Office Document dialog box to show the Binder. |
| 20708 | Describes that you may receive an error message when you try to run a Make-Table query or an Append query on a linked Sybase table in Access 2002 or in Access 2003. |
| 20709 | Describes how to troubleshoot printing problems in Microsoft Windows Server 2003 when you use Microsoft Office products. |
| 20710 | Describes that Conflict Viewer does not list the tables in synchronization conflicts between the replicas of an Access database. This occurs if one of the replicas in the replica set is corrupted. Resolve the conflict manually. |
| 20711 | Explains that after redirecting the Application Data folder to a target folder that is not named Application Data, you cannot create a new database or open an existing database in Access 2002. Resolve by changing the folder redirection path. |
| 20712 | Describes how to troubleshoot printing problems in Windows 2000. |
| 20713 | Explains that initiating Internet synchronization may cause an error when the Internet server computer is on a local area network that uses a Network Address Translation router. Edit the hosts file on the Internet server computer to fix the problem. |
| 20714 | Provides troubleshooting tips for printing problems with Office programs in Windows XP. |
| 20715 | This article contains definitions for the most frequently used terms in an Access database environment. |
| 20716 | This article lists sample expressions that you can use to count the occurrences of Yes, No, or Null in a field with a Yes/No data type. |
| 20717 | Microsoft has added database passwords, security account passwords, and Visual Basic for Applications (VBA) passwords to Microsoft Access so that you can prevent unauthorized access to important information. If you are unable to access database... |
| 20718 | Describes a problem that occurs when you try to import or to link a large fixed-width text file that contains null values. To work around this problem, replace the null values with blank spaces. |
| 20719 | You are using Visual Basic for Applications (VBA) programming code to assign values to a combo box or a list box. After the code runs, you view the contents of the combo box or the list box. You see that the values listed are not in numeric or... |
| 20720 | Describes a problem that occurs where Access 2002 quits unexpectedly and you receive an error message if you add rows to a custom subform. |
| 20721 | Describes the issues that are fixed in the proofing tools for the Italian version of Office XP post-Service Pack 2 hotfix package that is dated November 7, 2003. |
| 20722 | Describes a problem that occurs when you convert an earlier version Access database to Access 2002, the database may not function as expected or you receive an error message. |
| 20723 | Describes the issue that is fixed in the Access 2002 post-Service Pack 3 hotfix package that is dated June 2, 2004. |
| 20724 | Describes an issue that is fixed in the Access 2002 post-Service Pack 3 hotfix package that is dated May 27, 2004. |
| 20725 | Describes the issue that is fixed in the Access 2002 post-Service Pack 3 hotfix package that is dated May 26, 2004. |
| 20726 | Describes the problem that AutoExpand feature of the combo box may not work when the rowSource property for a combo box on the form does not include the DISTINCT keyword.And privides the workaround . |
| 20727 | Describes an issue that when you convert a macro to a module and then try to compile the module, the compilation may not be successful. This issue only occurres when a macro contains a condition and the condition statement refers to a database object. |
| 20728 | Describes the problem that you will receive an error message if you try to add a new record to a table by using the NotInList event of the combo box on a form.And privides a workaround. |
| 20729 | Describes the issue that is fixed in the Office XP post-Service Pack 3 hotfix package that is dated May 8, 2004. |
| 20730 | Describes how to reset the page number and the total count of the pages for each group in a report in Microsoft Access. The article also describes how to display the page number and the total count in the Page of Pages format. |
| 20731 | Describes the issues that are fixed in the Access 2002 post-Service Pack 3 hotfix package that is dated May 7, 2004. |
| 20732 | Describes a problem that occurs if you have a licensed ActiveX control on an Access form. The ActiveX control may not appear when you open the Access form in Form view. This article provides a workaround. |
| 20733 | Discusses that opening a data access page that specifies a UNC path to the database in its connection string may cause a problem. You can modify the connection string so that the UNC path is replaced by the absolute path to the database. |
| 20734 | Discusses that the data in a linked table that is linked to an Excel spreadsheet is limited to 255 characters in an Access database. To work around this problem, import the Excel spreadsheet rather than linking to the spreadsheet in your database. |
| 20735 | Explains the exclusive lock error that occurs when you try to open a form, a report, or a module in Design view in Access 2000. To work around the problem, rename or move the database file to a different folder, or open the database exclusively. |
| 20736 | Describes that the default values for the field properties of a new table differ in Access 2003 and Access 2002 when compared to earlier versions of Access. |
| 20737 | Explains that an error message occurs when you try to start a wizard in Access. You must install the latest version of MDAC to resolve the issue. |
| 20738 | Explains that the text that is in a text box control of a report or of a form does not appear correctly when the vertical property of the text box is changed to Yes. |
| 20739 | Explains that the AutoDialer feature ignores the dialing rules that are set in Access. This article also provides the workaround for resolving the problem. |
| 20740 | Describes an issue where you may be prompted to provide the Office source files when you install a full file version of an Office hotfix or update. |
| 20741 | When you filter a table to eliminate duplicate data, use a query that uses one of the aggregate (totals) functions, such as First (), Last (), Min (), or Max (), in the fields that do not contain duplicate data. In the fields that do contain duplicate... |
| 20742 | Describes a problem that may occur in a multi-user environment when more than one user tries to access the same record at the same time in a multi-table view. To work around this problem, refresh the view at regular intervals. |
| 20743 | Describes a problem that may occur when you try to upsize your Access database to SQL Server by using the Upsizing Wizard with System DSN or with User DSN. To work around, use Upsizing Wizard with File DSN to upsize the Access database. |
| 20744 | Describes a problem that occurs if your database password ends with a backslash (password\). You cannot open your database. You receive a Not a valid password error message. To work around this problem, import your database objects to a new database. |
| 20745 | When you run a query in a Microsoft Access database that uses one of the aggregate (totals) functions such as the Sum() aggregate function, the Min() aggregate function, or the Max() aggregate function, the query may not run successfully. You may... |
| 20746 | In Microsoft Outlook, you cannot open the Personal Folders file (.PST) folder on a share across the network. In Microsoft Office, you cannot save documents on a Distributed File System (DFS) share. When you modify files on a network file server, you... |
| 20747 | After you compact a Microsoft Access database or an Access project that exists in a folder in an NTFS file system partition, you may notice that the custom NTFS permissions for the Access database file (.mdb) or for the Access project file (.adp) are... |
| 20748 | Storing SQL database login IDs and passwords locally requires that the database administrator create a unique table on the server. |
| 20749 | Lists the available Office XP service packs for Access 2002 Runtime. |
| 20750 | Describes security issues that are fixed in the Access 2002 Update that is dated March 23, 2004. |
| 20751 | Describes how to obtain and install Office XP SP3 for Access 2002 Runtime in addition to the issues that are fixed in this service pack. |
| 20752 | Discusses the issues that have been fixed for Access 2002 in the Office XP SP3 release. |
| 20753 | The .ldb file plays an important role in the multiuser scheme of the Microsoft Jet database engine version 4.0. The .ldb file is used to determine which records are locked in a shared database and by whom. |
| 20754 | Describes how to obtain and install Office XP Service Pack 3 (SP3) in addition to the issues that are fixed in this service pack. |
| 20755 | Describes Access 2002 runtime package installation failure on a Windows Server 2003 computer. Failure occurs when the Access 2002 runtime package Setup program tries to locate the Dbmsadsn.dll file that does not exist on a Windows Server 2003 computer. |
| 20756 | Describes a problem that occurs when you sort a Number field that contains negative decimal values, and you do the sort in descending order. This article describes how to work around this problem by creating an index on the Number field. |
| 20757 | When you try to open a three-tier data access page in a modal window from another three-tier data access page by using the ShowModalDialog method, you may receive one of the following error messages: Internet Server Error Internet Client Error: Cannot... |
| 20758 | When you try to run an append query in a large Microsoft Access database file, you may receive the following error message: Invalid argument. This problem occurs when the size of the Access database file approaches the 2 gigabyte (GB) size limitation. |
| 20759 | When you try to programmatically edit records in an Oracle table by using an ActiveX Data Objects (ADO) recordset in a Microsoft Office Access 2003 database project, you may not be able to edit the records. Additionally, you may receive the following... |
| 20760 | When you are modifying the structure of a table in a Microsoft Access project (ADP) file, you may receive the following error message: ADO error: Timeout Expired |
| 20761 | When you insert a Microsoft Access 2002 SnapShot object (*.snp) into a document (such as a Microsoft Word 2002 document), the SnapShot object does not appear as expected. For example, the SnapShot object may appear as a solid color. |
| 20762 | When you use Help in a Microsoft Office program (click Microsoft program Help on the Help menu), both the Answer Wizard and the Index tabs may be blank. |
| 20763 | If you connect to a Microsoft Access database and then you create more than 64 connections in one process, you may receive one of the following error messages: In Microsoft Visual Studio .NET: Unspecified error In Microsoft Visual Basic 6.0, if you... |
| 20764 | When you try to check the spelling and the grammar in a French language document in a Microsoft Office XP program, the French proofing tools do not flag spelling and grammar errors that have a certain sequence of letters, such as in the string ave. |
| 20765 | The performance of a query that is run against an Open Database Connectivity (ODBC) data source may significantly decrease if the query contains a user-defined function. |
| 20766 | When you use Microsoft Access 2002 to try to merge the data from a parameter query, you may receive the following error message. This error message may occur when you use Microsoft Word Mail Merge Wizard with Microsoft Word Mail Merge files. Word was... |
| 20767 | When you try to use a Microsoft Access wizard such as the Import Text wizard or the Import Spreadsheet wizard in Microsoft Access 2002, you may receive the following error message: Error in loading DLL |
| 20768 | In the Microsoft Access user interface, you can create a table in a database by using any of the follow three methods: You can create a table by using the Table Wizard. You can create a table by entering data into a datasheet. You can create a table... |
| 20769 | When you try to use the Filter By Form functionality, you may receive the following error message: Cannot apply Filter on one or more fields specified in the Filter property. |
| 20770 | When you import tables from a Microsoft Access project (*.adp), previously saved PivotTable and PivotChart views are not preserved as expected. |
| 20771 | When you open a table in a Microsoft Access project in Datasheet view, you may receive the following error message: The setting you entered isn't valid for this property. To see the valid settings for this property, search the Help index for the name... |
| 20772 | When you output a report from Microsoft Access to another file format, such as .rtf, .txt, .xls, or .html, an OLE object that you inserted into the report does not appear. |
| 20773 | If you use the msoFileDialogSaveAs constant with FileDialog in a Microsoft Visual Basic module, your code is compiled as expected. However, when you run the code, you receive the following error message: Run-time error '445': Object doesn't support... |
| 20774 | You can set the number of times Access is able to undo the previous operation or command for any value between 1 and 20 by editing the following registry key: HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Access\Settings |
| 20775 | When you open a database or project in Microsoft Access by using the /runtime switch, the Help menu includes Sample Databases as an unavailable item. This selection should not be visible at all because the sample databases are not usually included in... |
| 20776 | In Microsoft Access, when you attempt to run a union query, you may receive an error message similar to the following: The ORDER BY expression ( MyFieldName ) includes fields that are not selected by the query. Only those fields requested in the first... |
| 20777 | When you check out a Microsoft Access object from a Microsoft Visual SourceSafe project, you notice that previous changes that you made to new Access 2002 properties were not saved. |
| 20778 | After you have opened a Microsoft Access 97 database in Microsoft Access 2002 and converted it to the current file format, Label reports do not display some data correctly. Data from fields named Name , which were presented correctly in the Access 97... |
| 20779 | In a Microsoft Access form or report, you insert Microsoft Calendar Control 10.0 or a later version and then you try to set the FirstDay property of the Calendar Control by using the numeric constants. For example, you use vbMonday for the days, as... |
| 20780 | When you visit the Microsoft Office Update Web site to look for updates to your Microsoft Office programs, you may receive the following warning message: Warning: You are viewing this page with an unsupported Web browser. This Web site works best with... |
| 20781 | In many of the programs listed at the beginning of this article, you can prevent unauthorized users from opening a file by applying a password to the file. When you attempt to open the file, the program requests the password; if you do not enter the... |
| 20782 | After you use Microsoft Office links to export data from Access 2002 and open the file in Excel 2000 or 97, you cannot bring up the Format Cells... dialog box. When you right-click a cell and select Format Cells... (or click Cells on the Format menu),... |
| 20783 | Microsoft Office products include features that enable specific collaboration scenarios and features that are designed to help make your documents and files more secure. Features that enable collaboration scenarios function correctly in collaboration... |
| 20784 | When you create a TOP X or TOP X PERCENT view or function in a Microsoft Access project, the view cannot be updated as expected. The object can be updated only when you specify TOP 100 PERCENT . |
| 20785 | When you view data that you imported from a Microsoft Access Thai database, which was created in a version of Access earlier than Access 2000, the Thai characters may not be displayed correctly, even though the Thai language is enabled. |
| 20786 | When you type text in a Microsoft Access table by using the Arabic keyboard, the character Alef may appear to be unconnected to the rest of the word to which it belongs. |
| 20787 | If you use the TransferDatabase action to try to link an external data source in an Access project (ADP), you receive the following error message: Links can only be created between Microsoft Access database files. |
| 20788 | The Stop statement, which suspends the Visual Basic for Applications (VBA) code in a Microsoft Access 2000 database, no longer works when you use the same database in Access 2002. |
| 20789 | When you use the ODBC Data Source Administrator to compact an Access database, you may receive the following error message if Version 3.x is selected under Format : ODBC Microsoft Access Driver Login Failed Cannot perform this operation; features in... |
| 20790 | When you click Clips Online on the Insert Clip Art task pane (on the Insert menu, point to Picture , and then click Clip Art ) in a Microsoft Office XP program, you do not go to the Clip Art and Media section of the Microsoft Office Online Web site.... |
| 20791 | When you open a form that is bound to an ActiveX Data Objects (ADO) recordset, you receive the following error message, and then Microsoft Access quits: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.... |
| 20792 | When you import or create a link to a Microsoft Visual FoxPro database in an existing Access database, the default database type selected for Visual FoxPro databases in the Configure Connection dialog box is Free Table directory instead of Visual... |
| 20793 | Some programs, such as Microsoft Project, may have difficulty saving data to a secured Microsoft Access database. The purpose of this article is to demonstrate automation code that can be used to transfer tables from a nonsecured Access database to a... |
| 20794 | When you are using the Convert Database utility to convert a workgroup information file (.mdw file) that was created in Microsoft Access 95 or Microsoft Access 97 to Microsoft Access 2002, you receive the following error messages: Record(s) cannot be... |
| 20795 | This article answers common questions concerning Automation to Microsoft Office from Visual C++. |
| 20797 | Microsoft Access does not restrict the use of special characters such as a number sign (#), a period (.), or a double quotation () in the database object names or in the database field names. However, if you do use the special characters you may... |
| 20798 | An ATL ActiveX Control does not appear or appears incorrectly when added to a Microsoft Access Report. The same control displays correctly when the Report is in design mode or if the control is added to an Access Form. |
| 20799 | In Microsoft Access, when you import a dBase, FoxPro, or Paradox file that does not follow the MS-DOS 8.3 file name format (that is, its name before the period exceeds eight characters, or it lacks a three-character extension following the period),... |
| 20800 | According to Microsoft Knowledge Base article 275561 ACC2000: New Features in Microsoft Jet 4.0: To minimize the impact of the increased page size and respond to a long-standing request from developers building applications based on the Microsoft... |
| 20801 | When you reset a menu on a built-in menu bar using Microsoft Visual Basic for Applications code, none of the menu items are available. |
| 20802 | Microsoft Jet is the database engine that is used by default by Microsoft Access. This article provides a list of best practices that you can use to help keep your Jet database in top working condition. This article addresses a database running both... |
| 20803 | This article contains a list of Microsoft Office Developer samples and tools that are available in the Microsoft Download Center. |
| 20804 | Microsoft Office products may change from one release to the next. Typically, the type library for an Office product will have the same functions that were present in the earlier product version, but some functions may have additions to the number of... |
| 20805 | Microsoft Office 2000 and later support a new, uniform design architecture for building application add-ins to enhance and control Office applications. These add-ins are called COM Add-Ins. This article will demonstrate how to build a COM Add-In using... |
| 20806 | Microsoft Office XP provides a FileDialog object that gives you functionality that is similar to the standard Open and Save dialog boxes that are found in all Office XP applications. By using FileDialog objects in your Visual Basic for Application... |
| 20807 | Microsoft does not recommend or support Automation to a Microsoft Office application from an unattended user account. on why Microsoft does not recommend automation under this context 257757 INFO: Considerations for Server-Side Automation of Office... |
| 20808 | Incorrect CREATE TABLE statements are created when Microsoft Jet database engine 4.0 exports tables through ODBC drivers that do not require identifier quote characters. If an ODBC trace is generated, a you see a statement similar to the following:... |
| 20809 | Microsoft has created new Paradox and dBASE ISAM drivers for Microsoft Jet 4.0 that do not require the installation of the Borland Database Engine (BDE) to provide full read/write access to Paradox and dBASE files. The current Jet 4.0-based Paradox... |
| 20810 | When you reference hyperlinks in Visual Basic for Applications, you may receive the following error message: No program is registered to open this file. |
| 20811 | When you use any Office program, you may receive the following error message: This program has performed an illegal operation and will be shut down. If the problem persists, contact the program vendor. When you click Details , you see Program caused... |
| 20812 | This article describes the Access 2002 (Japanese) issues that are fixed in the Access 2002 Post-Service Pack 2 hotfix package that is dated July 18, 2003. Issues That Are Fixed in the Hotfix Package The following issue is fixed in this hotfix package... |
| 20813 | When you start any of the Office programs listed at the beginning of this article, or when you start the Office Assistant, you may receive the following error message: The Office Assistant could not be started. The Assistant might not have been... |
| 20815 | If you want to troubleshoot a problem with your printer driver, try printing with a different printer driver. If you determine that the problem does not occur when you use a different driver, you may need to update or reinstall the original printer... |
| 20816 | When you use Microsoft Access, you receive the following error message: ActiveX component can't create object This article describes some common causes for this error message and offers methods that you can use to resolve the issue. |
| 20817 | This article discusses the licensing and use of Microsoft Office XP Web Components. If you create a Web page that contains an Office XP Web component, the component is not visible to visitors to your site unless they install the Office XP Web... |
| 20819 | This article describes the Microsoft Access 2002 issue that is fixed in the Access 2002 Post-Service Pack 2 hotfix package that is dated September 12, 2003. back to the top Issues That Are Fixed in the Hotfix Package The following issue is fixed in... |
| 20820 | When you copy an item in any of the Microsoft Office XP programs listed at the beginning of this article, the item may not be added to the Office Clipboard and you are not warned that the Office Clipboard memory is full. |
| 20821 | Advanced: Requires expert coding, interoperability, and multiuser skills. By using API calls in Visual Basic for Applications, you can programmatically hide the Microsoft Windows 98 or Microsoft Windows NT 4.0 taskbar. This article shows you how to... |
| 20822 | When you open one of the Microsoft Office programs listed at the beginning of this article, the program may open slowly. |
| 20823 | When you insert an object from one program (for example, a Microsoft Excel worksheet object) into another program (for example, Microsoft Word), and then you deactivate and reactivate the inserted object, the Undo command may behave differently in... |
| 20824 | When you start the Microsoft Office Application Recovery utility, earlier versions of Office programs are listed as running applications. Also, when you select an earlier version of an Office program and click either Recover Application or End... |
| 20825 | This step-by-step article describes how to display or hide the Ask a Question box in Microsoft Office XP programs. The Ask a Question box is a new feature of Office XP that allows quicker access to Help topics. This box is located in the upper-right... |
| 20826 | This step-by-step article describes how to import a Microsoft Works database file into a Microsoft Access database. This is a two-step process: Save the Works database file in a format that is compatible with Microsoft Access. Import the Works... |
| 20827 | The Microsoft Visual Basic for Applications Str() function returns the string representation of a numeric value represented as (n). Positive numbers and zeros are converted to a string with a leading space character. This article discusses methods... |
| 20828 | When you attempt to install one of the programs listed at the beginning of this article, you may receive the following error message: Error 1324: The folder path folder name contains an invalid character. |
| 20829 | If you ask the Office Assistant a question about Microsoft Visual Basic for Applications from within the program (not within the Visual Basic Editor), you may receive the following message: No answers could be found for the question you typed. Please... |
| 20830 | If a Microsoft Office XP program experiences a serious error and quits, your computer records an error signature that describes the error that occurred. This article explains how to view these error signatures. The error signature contains... |
| 20831 | When you run any of the programs included with Microsoft Office XP and you use a lower screen resolution (800 x 600, for example), or if you have many windows open, or if your screen is very cluttered, you may find that the Office Assistant is too... |
| 20832 | If you try to open a specific file in one of the Microsoft Office 2000 programs listed at the beginning of this article, you may receive one of the following error messages: Filename is not valid. -or- The file could not be accessed. -or- The path you... |
| 20833 | This article describes how to clear the Most Recently Used list (MRU) for the Microsoft Office programs listed at the beginning of this article. To clear the MRU, follow the steps for the program that you are using. Microsoft Access, Excel, PhotoDraw,... |
| 20834 | When you minimize or close an Office program, the Language bar may be minimized or may seem to disappear. NOTE : The Language bar does not disappear; it is minimized to an indicator button in the status area on the Microsoft Windows taskbar (to the... |
| 20835 | While debugging your code that uses Automation to control Microsoft Access, you may receive one of the following errors. When automating Microsoft Access 95: MSACCESS caused an Invalid Page Fault in module MSACCESS.EXE at 0137:5000f878 -or- MSACCESS... |
| 20836 | In Microsoft Access 2002, if you manipulate a main form and a subform in Design and Form views, you may receive the following error message, and then Access quits: Microsoft Access has encountered a problem and needs to close. We are sorry for the... |
| 20837 | The dBASE database driver works in one of the following two modes: The latest Microsoft Jet 4.0 service pack or the Borland Database Engine (BDE) is installed. Neither the latest Jet 4.0 service pack or the BDE is installed. The dBASE data is only... |
| 20838 | This article describes the Microsoft Office XP issue that is fixed in the Office XP Spanish Post-Service Pack 2 hotfix package that is dated November 3, 2003. back to the top Issues That Are Fixed in the Hotfix Package The following issue is fixed in... |
| 20839 | When you try to save an Access database file (.mdb) as an MDE file (.mde), or when you try to save an Access project file (.adp) as an ADE (.ade) file, Access may stop responding. You may receive the following error message: Microsoft Access has... |
| 20840 | When you convert a Microsoft Access 1.x or a Microsoft Access 2.0 database to Microsoft Access 2002, the conversion process may display a warning message or stop altogether because of an incompatibility with the new features and enhancements. This... |
| 20841 | If you do not want to see the Convert/Open Database dialog box when you open an Access 97 database in Access 2002, you can suppress the dialog box by adding a registry entry that is named NoConvertDialog to the Access Settings subkey. This setting... |
| 20842 | This article describes how to disable the functionality of the SHIFT key that permits you to bypass the startup options. This article also describes how to enforce the startup options in a Microsoft Access database project. |
| 20843 | When you open a form that contains a subform that is based on a linked Microsoft SQL Server table, the subform does not display any records. |
| 20844 | When you view a data access page in Access 2002, one of the following may occur. When you view the page in Access, you may receive the following error: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.... |
| 20845 | After you install the Microsoft Office XP Service Pack 2, you notice that descending indexes in Access 2002 that have been upsized to SQL Server are still upsized as ascending indexes. |
| 20846 | In Microsoft Visual Basic Editor, when you add a reference to the ActiveX Data Objects (ADO) 2.7 Object Library or later, and then you press F1 to obtain context-sensitive Help for ADO, a blank window may appear for Microsoft Visual Basic Help. |
| 20847 | When you create a link to a text file from Microsoft Access and then move the text file to another folder, you may receive the following error message when you try to use the Linked Table Manager to refresh the link: The Microsoft Jet database engine... |
| 20848 | When you specify Calculate percent of total for sums on the Summary Options page of the Report Wizard, the caption of the label control reads Standard instead of Percent on the report that is created. |
| 20849 | When you import data from an Excel spreadsheet into an Access database, dates in long date format, such as January 1, 2000; or medium date format, such as 1-Jan-2000, lose formatting and are displayed as short dates, such as 01-01-2000. |
| 20850 | When you try to open a database that is located on a Novell NetWare server, you may receive the following error message: Couldn't use filename; file already in use. |
| 20851 | When you try to open a partial replica file, you may receive the following error message: You cannot add or change a record because a related record is required in table 'MSysAccessStorage' This message may be displayed several times, and then Access... |
| 20852 | When you import a comma delimited text file by using the Import Text Wizard, the following behaviors occur: When you import a text file by using the Import Text Wizard, a field that contains data that exceeds the range of Long Integer is still mapped... |
| 20853 | When you try to start Microsoft Script Editor from the Microsoft Access environment, you may receive the following error message: An error occurred and this feature is no longer functioning properly. Would you like to repair this feature now? When you... |
| 20854 | The Paradox database driver works in one of two modes. One mode is when either the Microsoft Jet 4.0 Service Pack 5 (SP5) or the Borland Database Engine (BDE) is installed. The other mode is when neither of these are installed. Paradox data is only... |
| 20855 | When you apply a filter to a table in a Microsoft Access project and switch to PivotTable or PivotChart view, the complete set of records is represented in that view instead of the filtered set. |
| 20856 | The Microsoft Access 2002 Startup command-line options Help topic incorrectly states the following: Converts a previous-version Access database or Access project to the default file format, renames the new file, and then closes Access. You must... |
| 20857 | When you use dBASE III to open a dBASE III file exported by Microsoft Access, you receive the following error message: Not a valid dBASE III file. |
| 20858 | When you attempt to select a different Office Assistant in Microsoft Word 2000, you may receive the following error message: Insert the 'Microsoft Word 2000' disk and click OK. When you click OK , you receive the following error message: Error 1706.... |
| 20859 | When you use the Mid , the Left , or the Right string function in a query to parse a column of data type Memo that contains a string that is longer than 256 characters, the result may be truncated. |
| 20860 | When you create a nested query against linked SQL Server tables and the top level query contains an outer join, you receive the following error message when you try to run the query: ODBC--Call Failed. [Microsoft][ODBC SQL Server Driver][SQL Server]... |
| 20861 | When you use Microsoft Data Access Objects version 3.0 (DAO 3.0) with the products listed at the beginning of this article, you may receive the following error message: Run-time error '429': ActiveX component can't create object. |
| 20863 | When you insert a Microsoft Excel workbook into a document of one of the Office programs listed at the beginning of this article or in a form in Microsoft Access, you receive one of the following messages Macros in this workbook are disabled because... |
| 20864 | When you try to install a Microsoft Access 2002 runtime deployment package on a computer that is running Microsoft Windows 98, the installation may fail and you may receive the following error message: The Office System Pack cannot be installed on... |
| 20865 | This article describes how to retrieve selected items from a multiple selection list box and then store the selected items as a comma-delimited string. |
| 20866 | When one or more users process many transactions in a multi-user environment, the transactions may fail with the following error message: File sharing lock count exceeded. Increase MaxLocksPerFile registry entry. |
| 20867 | When you try to open an Access 97 database in Access 2002 or later, you may receive one of the following error messages: Cannot open a database created with a previous version of your application. -OR- Cannot open database PathToDatabase It may not be... |
| 20868 | When you try to save design changes that you made to a Microsoft Access object that contains a module (a form, a report, or a standard module), it may take longer to save the object than it did in Microsoft Access 95 or 97. This is especially true in... |
| 20869 | When you close a Microsoft Access table in PivotTable view after you change the width of its window, you receive the following message Do you want to save the changes to the layout of table ' tablename '? where tablename is the table that you have... |
| 20870 | When you search for Help topics on any of the type conversion functions by name in Microsoft Visual Basic Help, you do not get the Help topic you were looking for. For example, if you type Cbool in the Office Assistant balloon or the Ask a Question... |
| 20871 | Unlike Microsoft Access version 2.0 and earlier, Access 2002 does not create a .ldb file when a database is opened exclusively. Because of this, you can no longer use the .ldb file to determine which user has a database open for exclusive use. |
| 20872 | In Microsoft Excel, when you use the Shell function in a Visual Basic for Applications macro to execute an external MS-DOS command, an MS-DOS window may open and you may receive the following error message: Specified COMMAND search directory had Too... |
| 20873 | This article explains database normalization terminology for beginners. A basic understanding of this terminology is helpful when discussing the design of a relational database. NOTE : Microsoft also offers a WebCast that discusses the basics of... |
| 20874 | The information covered in this article is provided by: Microsoft Press . This article is part 6 of a series of eight articles that explain how to keep your information in Access accurate. To view the other articles in this series, please see the... |
| 20875 | By using the Microsoft Access Report Wizard for mailing labels, you can quickly create a report design for many standard mailing labels. The Label Wizard has a Customize button that enables you to define your own label size and to save it as a... |
| 20876 | Microsoft has released an update to Access 2002. This update fixes a flaw in the Microsoft Access Snapshot Viewer control that may potentially permit an attacker to run their code on the system of a user if the user visits a malicious Web site.... |
| 20877 | When you try to open an Access database by using a URL address (such as http://servername/databasename or ftp://servername/databasename), you may receive one of the following messages: Microsoft Access cannot open this file. This file is located... |
| 20878 | When you preview a report created by saving a form as a report, you may receive the following error message: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. |
| 20879 | When you export data to the Microsoft Excel file format, null values are replaced with the data that should be in the next column in the resulting spreadsheet. |
| 20880 | When you use the SQL Text Editor to create a text stored procedure or function, you notice that all code appears in black text rather than in the color-coded format that you see in Microsoft Access 2000. |
| 20881 | You cannot create or view a data access page that is bound to Microsoft SQL Server version 6.5. If you are designing your page through an Access project (.adp), you may also receive the following error messages when you try to view the page in... |
| 20882 | When you try to export a table by using the Microsoft Visual FoxPro ODBC driver, you may receive the following error message: ODBC Call failed [Microsoft][ODBC Visual FoxPro Driver (#712) NOTE : You may also receive the following error message ODBC... |
| 20883 | When you call the Requery or Refresh methods from certain events in a form, one of the following occurs: You receive the following error message, and then Microsoft Access shuts down: Microsoft Access has encountered a problem and needs to close. We... |
| 20884 | When you run a Left Outer Join or Right Outer Join query, Microsoft Access may return incorrect data. |
| 20885 | This article explains how to recover a deleted or missing AutoFormat style in Microsoft Access. The procedure requires that you have a second copy of Access. The second copy can either be one that is installed on a different computer or one that is... |
| 20886 | When you type text data into a Text or Memo field or control in Microsoft Access with the AutoCorrect Capitalize first letter of sentence feature enabled, you find that the first word in the field is not capitalized. |
| 20887 | Microsoft has released Microsoft Office XP Service Pack 2 (SP-2). This article describes the issues that are fixed for Microsoft Access 2002. about how to download and how to install Office XP Service Pack 2 325671 OFFXP: Overview of the Office XP... |
| 20888 | The Configuring SQL Server 2000 Desktop Engine white paper (AccSQL02.doc) provides an overview of how to use Microsoft Access 2002 with Microsoft SQL Server 2000 Desktop Engine (SQL Server Desktop Engine). Topics that are covered in this white paper... |
| 20889 | In Microsoft Access, you may receive the following error message when you run a SQL query: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. |
| 20890 | If you open a data access page in Microsoft Access and then click a hyperlink on the page, the browser opens a Web page, as expected. However, you cannot click the Back button in the browser to return to the page in Microsoft Access. |
| 20891 | When you link a table from an ODBC data source, such as Microsoft SQL Server or ORACLE, and that table contains more than one unique index, Microsoft Access may select the wrong index as the primary key. |
| 20892 | If you convert an Access database that has a linked Microsoft FoxPro table to Microsoft Access 2002, the icon of the table appears dimmed. Also, if you try to open the table, you receive the following error message: Can't find installable ISAM. |
| 20893 | It is sometimes useful to create forms with linked charts in order to chart data that only applies to the current record of the form. In earlier versions of Microsoft Access, you could do this by using Microsoft Graph. This article demonstrates how... |
| 20894 | Microsoft Access can import or link data from other Microsoft Access databases (version 2.0, 7.0/95, 8.0/97, 9.0/2000, 10.0/2002), as well as data from other programs and file formats, such as Microsoft Excel, dBASE, Paradox, or XML (import only). You... |
| 20895 | When you start a Microsoft Access 2000 run-time application after you uninstall Microsoft Access 2002, including a Microsoft Access 2002 run-time application, you may experience either of the following symptoms: Visual Basic for Applications code... |
| 20896 | When you double-click a Microsoft Access database or project file (MDB or ADP) in Microsoft Windows Explorer, the file does not open as expected. Instead, the focus returns to an existing instance of Access. |
| 20897 | When you edit the PivotTable or PivotChart view of a Microsoft Access form, either manually or through code, Microsoft Access does not prompt you to save the changes when you close the form. Instead, Microsoft Access automatically saves any manual... |
| 20898 | If you run a query or a filter on data from a Microsoft SQL Server-based table, you receive the following error message: ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Line1: Incorrect Syntax near ,.(#170) |
| 20899 | In a data access page, if you call a function that is not available outside of Microsoft Access, you receive the following message when you open the page in Microsoft Internet Explorer: Data Provider failed executing a provider command. This message... |
| 20900 | After you install Microsoft Internet Explorer 6.0 Service Pack 1 (SP1) or Microsoft Windows XP Service Pack 1 (SP1), some data access pages do not display data when the page is opened in Page view in Microsoft Access. When you open a data access page... |
| 20901 | Certain fonts in the Font Name combo box of the Label Report Wizard in Microsoft Access may not display correctly. This occurs on a computer that is running an English version operating system with the Microsoft Office XP Multilingual User Interface... |
| 20902 | If you have versions of Microsoft Access that are earlier than Access 2002 on the same computer on which you install Microsoft Access 2002, when you create a new database in Access 2002, you may see templates that are used for creating databases in... |
| 20903 | When you sort a table while one of its columns is being renamed, Microsoft Access may quit and you receive the following error message: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. |
| 20904 | When you use Microsoft Access 2002 to link a Microsoft SQL Server 7.0 or a Microsoft SQL Server 2000 table that contains a UniqueIdentifier column as the primary key, #Deleted is displayed in every record of the linked table. |
| 20905 | The About MDE files Help Topic contains the following paragraph: If your database contains Microsoft Visual Basic for Applications (VBA) code, saving your Microsoft Access database as an MDE file compiles all modules, removes all editable source... |
| 20906 | When you run Microsoft Access on a computer that is running Microsoft Windows Millennium Edition (Me) or Microsoft Windows 98, you receive the following error message when you try to print or modify a report: There was a problem retrieving printer... |
| 20907 | When you use Microsoft Office speech recognition in Microsoft Access, the Dictation option may not be available in an Access project (ADP) file. |
| 20908 | On the Tools menu, you can point to Office Links , and then click Publish it with Microsoft Word , Analyze it with Microsoft Excel , or Merge it with Microsoft Word . When you click one of these options, you receive one or more of the following error... |
| 20909 | On a computer that is running Microsoft Windows 98, Microsoft Windows 98 Second Edition, or Microsoft Windows Millennium Edition (Me), when you open a database that contains approximately 120 modules, you receive an Out of memory error message.... |
| 20910 | This article discusses the causes of fatal system errors in Microsoft Access 2002 running on Windows 2000 and provides general troubleshooting steps that you can use to solve these errors. This article first discusses a new error reporting tool in... |
| 20911 | In Microsoft Access, you can create a query to retrieve information from a table or from multiple tables. You can then use the query as the basis of a form, a report, or a data access page. This article shows you how to create simple queries in... |
| 20912 | This article describes how to upsize a Microsoft Access database to the Microsoft SQL Server or to the Microsoft Data Engine (MSDE) by using the Access 2002 Upsizing Wizard. This article introduces the Upsizing Wizard, what to check before you upsize,... |
| 20913 | By using crosstab queries, you can create summary views of your data for easier analysis. This article shows you how to create a crosstab query in Microsoft Access with and without using a wizard. CAUTION : If you follow the steps in this example, you... |
| 20914 | You can use criteria in a query in Microsoft Access to restrict the set of records that the query returns. To query for different records each time that you run a particular query, you may want the query to prompt you for criteria to enter, for... |
| 20915 | The Microsoft Knowledge Base contains a wealth of information about all Microsoft products and technologies. This article introduces you, the Access 2002 user, to the Microsoft Knowledge Base and gives you tips to find the information and the... |
| 20916 | This article lists the references that you must set when you are working with databases that you create in Microsoft Access or when you access information in Microsoft Access databases from other applications. The following topics are covered in this... |
| 20917 | When you try to import XML, you may receive the following error message: Microsoft Access cannot create table(s) using the information contained in the document(s) you are trying to import. This article explains the possible causes of this error... |
| 20918 | When you try to set the Index property of an ActiveX Data Objects (ADO) recordset that is based on a table in a Microsoft Jet database, you may receive the following error message: Run-time error '3251': Current provider does not support the necessary... |
| 20919 | This article demonstrates a method that you can use to hide the drop-down arrow on a combo box until the combo box is selected. Steps to Hide the Drop-Down Arrow on a Combo Box To hide the drop-down arrow on a combo box when the combo box is not... |
| 20920 | When you view an Access project form that has a Server Filter applied to it in print preview, the form loses its connection to its record source and #Name is displayed in all of the data controls. |
| 20921 | When you attempt to change the icon for an object during any of the following operations Insert Object Convert Object Paste Special by using the From File option, you receive the following message: File mspaint.exe does not exist. |
| 20922 | This article describes how to access data in a Microsoft Visual FoxPro database (.dbc file) from Microsoft Access 2002. This article is divided into two parts. The first part explains how to set up a data source that points to a Visual FoxPro... |
| 20923 | This article presents the guidelines that Microsoft Product Support Services (PSS) support professionals follow when supporting Microsoft Access customers and also lists support options available for Microsoft Access. |
| 20924 | If you are working with XML data in Access in the user interface or in the Visual Basic Editor (VBE), you may notice that certain features are not available even though they are documented in the Access 2002 Help system. The following Help topics are... |
| 20925 | Sometimes, it is not practical to store images in a Microsoft Access table. If you have many images, or if each of your image files is large, the size of the Microsoft Access database file can quickly increase. This article demonstrates a custom... |
| 20926 | Session Summary In this session, we will discuss how to design a relational database system. The session will cover creating effective table structures and relationships, and database normalization. This is a Level 100 session that was recorded June... |
| 20927 | A Microsoft Access database has begun to bloat (or grow rapidly in size) after you implement Data Access Objects (DAO) to open a recordset. |
| 20928 | With the introduction of data access pages in Access, you can now create data bound Web pages that can be viewed in Microsoft Internet Explorer 5 or later. By default, these pages try to bind to data on the client computer, making them ideal for... |
| 20929 | In Microsoft Access, you can use variable parameters in queries. This article discusses how to construct a query that requires more than one prompt. You can use each parameter both as criteria and as a field to allow complicated evaluation of the... |
| 20930 | You cannot install the Microsoft SQL Server 2000 Desktop Engine through the Microsoft Office XP Setup program. There is a separate Setup program that you use to install the SQL Server 2000 Desktop Engine. NOTE : The previous version of Microsoft SQL... |
| 20931 | When you view the event properties of a form in Design view, you do not see an OnRecordExit event property, even though this event is documented in the Access 2002 Help system. |
| 20932 | When you try to export a report with the Publish It with Microsoft Word OfficeLinks command, you may receive the following message: The Save As command can't process any subforms contained in your report. Do you want to proceed anyway? If you... |
| 20933 | Microsoft Access addresses linked data differently than it does its own native data. This article discusses how Access retrieves linked ODBC data. |
| 20934 | When you try to save a Microsoft Access database as an MDE file, you may receive the following error message: Can't open any more tables. When you click OK , you receive the message: Out of memory. When you click OK again, you receive the message... |
| 20935 | This article lists words and symbols that you should not use in field, object, and variable names because they are reserved words. Reserved words have a specific meaning to Microsoft Access or to the Microsoft Jet database engine. If you use a... |
| 20936 | When you use Microsoft Access 2002 to open a database that was created in an earlier version of Microsoft Access, the database project is decompiled, even though no modifications were made to the underlying Visual Basic for Applications code. |
| 20938 | When you use Microsoft Access Help, you cannot seem to find any information about built-in functions, properties, or methods of objects or collections. -or- When you use Microsoft Access Help, you find Help topics that seem to be related to Microsoft... |
| 20939 | This article describes the Microsoft Office issue that is fixed in the Office XP Post-Service Pack 2 hotfix package that is dated October 7, 2003. back to the top Issues That Are Fixed in the Hotfix Package The following issue has been fixed in this... |
| 20940 | Unrelated rows in a subreport or a subform may be returned when the LinkMaster property or the LinkChild property uses fields of the Decimal data type and the table is linked through ODBC. |
| 20941 | If you want to print a report to a particular printer, you can manually select the printer and all of the print options, or you can automate the process so that with a click of a button, you can switch printers and then print your report with the... |
| 20942 | If you try to import, export, or link a file by using an indexed sequential access method (ISAM) driver, you may receive an error message if Microsoft Access cannot find the ISAM driver. |
| 20943 | You cannot create a system DSN by using the RegisterDatabase method. To create a system DSN, use the ODBC API call for SQLConfigDataSource . Microsoft provides programming examples for illustration only, without warranty either expressed or implied,... |
| 20944 | When you install Microsoft Office, you may receive the following (or similar) error message: You have chosen not to install Visual Basic for Applications. Microsoft Access requires Visual Basic for Applications and will be removed if you continue, and... |
| 20945 | This article explains how to use the Mail Merge feature in Word to create and print labels using data from an Access database. The article contains instructions using the Customers Table in the Northwinds sample database that is supplied with Access.... |
| 20946 | This article explains how to use the Mail Merge feature in Microsoft Word 2002 to create and print form letters that call data from a Microsoft Access database. This article contains instructions about using the Customers table in the Northwind sample... |
| 20947 | When you set the focus to the Header section of a subform, the GotFocus event of the first control in the tab order of the subform's Detail section is fired. This behavior occurs even if the control is not focused. |
| 20948 | This article describes how to store Outlook 2002 items in a Microsoft Access 2002 database file. |
| 20949 | In most Microsoft Access objects, such as forms and reports, you can use a domain function to easily retrieve data from sources other than the record source of the object. Domain functions are intrinsic functions built into Microsoft Access. Because... |
| 20950 | The Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is a SQL Server 2000-compatible data storage server that is included with Microsoft Office XP Developer, with rights to redistribute. The Office XP Developer Packaging Wizard has an option for... |
| 20951 | This article discusses the differences between the CurrentProject.Connection and the CurrentProject.AccessConnection properties in Microsoft Access 2002 or later. |
| 20952 | This article describes the Microsoft Office XP issue that is fixed in the Office XP Post-Service Pack 2 hotfix package that is dated October 3, 2003. back to the top Issues That Are Fixed in the Hotfix Package The following issue is fixed in this... |
| 20953 | When you try to import or link a Microsoft Hotmail Inbox into an Access database, you receive the following error message: You do not have the necessary permissions to use the object. Have your system administrator or the person who created this... |
| 20954 | When you use code that performs Delete and UpdateBatch methods based on the Forms collection, you receive the following error message: Microsoft Visual Basic Run-time error '91': Object variable or With block variable not set |
| 20955 | After you install Microsoft Visual C++ 6.0, the only ActiveX calendar control available to insert in Design view of a data access page or a form is version 8.0. |
| 20956 | This article describes how to use the Forms! FormName ! ControlName parameter reference in the RecordSource property for a form in a Microsoft Access project (ADP). In this method, the difficult step is integrating a server-based query with Access... |
| 20957 | When you try to edit a field in an ADO recordset by using the Microsoft Access and the Microsoft Jet OLE DB providers, you receive the following error: Run-time error '3251': Current Recordset does not support updating. This may be a limitation of the... |
| 20958 | When you attempt to use a wizard or to open a switchboard in Access 2000, you receive the following error message: Method 'connection' of object '_currentproject' failed. |
| 20959 | If you open a schema that is produced by using Access, you receive the following error message in the Visual Studio .NET designer: The XML Designer encountered the following error while reading this file: Document Element tag xsd:schema must identify... |
| 20960 | When you are automating an Office application from Visual Basic .NET, the Office application may display a dialog box. The dialog box causes the Visual Basic .NET application to appear to stop responding (hang) because the Visual Basic .NET... |
| 20961 | If you use the Create table by entering data option to create a table, the primary key field begins with a value of 22 instead of the expected value of 1. |
| 20962 | In Access 2002, you can link a replicated Access 97 database and view the data. If you try to add or edit a record, however, you receive the following error message: Operation not supported on replicable databases that have not been converted to the... |
| 20963 | To limit the number of records returned in a form, a combo box, or a list box, it is common practice to use a form reference. However, during the upsizing process, the Upsizing Wizard removes the form reference, leaving an incomplete SQL statement.... |
| 20964 | This article describes how to create and how to use a form that contains Start/Stop and Reset command buttons that use the Timer event of a form to display elapsed hours, minutes, and seconds in a text box control. Steps to Create a Stopwatch Form... |
| 20965 | This article shows you how to dynamically build criteria for a query string with values from a search form. |
| 20966 | This article shows you how to construct a query that returns all dates between and inclusive of start and stop dates without regard to year. The Challenge Date values include the year. Therefore, you must write the query to ignore the year portion of... |
| 20967 | Silent design changes (minor design changes) that are made to Microsoft Access-specific objects, such as forms, reports, macros, modules, or commandbars, may be discarded without warning. |
| 20968 | When you export a table that includes a Date/Time field to a text file, Microsoft Access automatically adds the time format to the date in the exported text file. The Date/Time field appears in the text file in mm/dd/yy hh:nn:ss format. |
| 20969 | A trigger that is assigned to a table does not display an error message when the trigger is executed. |
| 20970 | When you output a report to Microsoft Excel, any Memo field is truncated to 255 characters. You may also see this behavior when you click the Analyze It with Microsoft Excel command while you are previewing a report. |
| 20971 | When you run a query that includes a Memo, an OLE, or a Hyperlink field on a computer that is running Microsoft Jet 4.0 Service Pack 5 (SP5), you receive the following error message: Run-time error '3114': Cannot include Memo, OLE or Hyperlink Object... |
| 20972 | When you add a new record to a Microsoft Access project (.adp) table, and the primary key identity column has an increment value of 2 or more, the value in the primary key column appears to be incremented only by 1 until you save the record. When you... |
| 20973 | In Microsoft Access, the borders of the controls on a data access page may not be affected by Special Effects (border style) settings. You may notice this behavior when you work with rectangles or labels. |
| 20974 | When you try to preview or to print a report in Microsoft Access, you receive the following error message: Microsoft Access cannot communicate with the printer. You receive this error for one of the following reasons: Before you start this procedure,... |
| 20975 | If you want to control when and if the Borland Database Engine (BDE) is used by Microsoft Access, you can do so by changing the value in the following registry key: HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Xbase\BDE NOTE : You may have to... |
| 20976 | When you import data from a comma-delimited text file to an existing table by using the Import Text Wizard, the data in the fields that you have selected to skip in the Import Specification dialog box are imported to the existing table. |
| 20977 | When you copy or import a table in a Microsoft Access project (.adp), the new table is created, but no data is copied to the new table, and the primary key may not have been created. Depending on the size of the table, you may also receive the... |
| 20978 | When you start Microsoft PowerPoint or Microsoft Publisher on one of the following Hewlett-Packard (HP) laptops HP Pavilion n5470 HP Pavilion n5430 HP Pavilion xh485 HP Pavilion xh455 you receive a series of error messages that can include any of the... |
| 20979 | After you install a run-time version of Microsoft Access 2002 on a computer that has Microsoft Access 2000 or an earlier version installed, if you use Windows Explorer or a shortcut to open a file that was created in Access 2000 or in an earlier... |
| 20980 | When you try to use a Microsoft Jet 3.x workgroup information file (system database) with the Microsoft Jet 4.0 OLE DB provider, you may receive the following error message: Run-time error '3251': Object or provider is not capable of performing... |
| 20981 | After converting a Microsoft Access 2002 database to Microsoft Access 97, you receive the following error message when you open a form or report in the new Microsoft Access 97 database: There is no object in this control. |
| 20982 | You can run Visual Basic for Applications (VBA) code based on the tabs that are selected in a tab control. To make sure that a particular block of code runs when you click a particular tab, use a SELECT CASE statement with the Change event of the tab... |
| 20983 | Automation clients written for Microsoft Access 97 that use either early binding (VB, ATL with #import) or dispid binding (MFC) might unexpectedly fail when trying to automate Microsoft Access 2000 or 2002. Among the possible errors you might receive... |
| 20984 | When you run the Mail Merge Wizard to merge the results of a SQL Server stored procedure or function with a Microsoft Word document, you receive the following error message in Microsoft Word: filename is locked for editing by 'another user'. When... |
| 20985 | When you attempt to establish a link to, or import, a Microsoft Outlook Address Book (such as Contacts), your computer may stop responding. |
| 20986 | This step-by-step article describes how to call Office macros from a Visual C# .NET Automation client. You can use Microsoft Office Automation to open a document or create a new document that contains a Visual Basic for Applications (VBA) macro and... |
| 20987 | This step-by-step article describes how to call Office macros from a Visual Basic .NET Automation client. You can use Microsoft Office Automation to open a document or create a new document that contains a Visual Basic for Applications (VBA) macro and... |
| 20988 | When you click Open (on the File menu or on the Standard toolbar) in a Microsoft Office XP program, the Open dialog box may delay the display of files for approximately 2 to 5 minutes. Also, the processor (CPU) activity may indicate 100 percent... |
| 20989 | When a Microsoft Office application loads a Component Object Model (COM) add-in or a smart tag recognizer add-in that is created with Visual Studio .NET, you may experience one of the following problems: When the add-in is loaded in an Office... |
| 20990 | In a Microsoft Office XP program, when you click Open on the File menu, select a File Transfer Protocol (FTP) site, and then click Open , you may receive error messages similar to the following: Cannot connect to the FTP server on the computer named... |
| 20991 | This step-by-step article describes how to open documents from, and save documents to, a File Transfer Protocol (FTP) Web site by using Microsoft Office programs. Open a File from an FTP Site To open a file from an FTP site, follow these steps: On the... |
| 20992 | When you run a Microsoft Office XP program, the file Ctfmon.exe (Ctfmon) runs in the background, even after you quit all Office programs. This article answers some of the frequently asked questions about the Microsoft Text Services Ctfmon.exe file,... |
| 20993 | When you try to use System.Runtime.InteropServices.Marshal.GetActiveObject from Microsoft Visual C# .NET to automate a Microsoft Office application, you may receive the following error message, even though the Office application is running: An... |
| 20994 | In Microsoft PowerPoint 2002, when you open a Microsoft PowerPoint 2000 presentation that contains an image with transparent regions, the transparent regions are no longer transparent. |
| 20995 | When you try to use GetObject or System.Runtime.InteropServices.Marshal.GetActiveObject from Microsoft Visual Basic .NET to automate a running Microsoft Office application, you may receive one of the following error messages: With GetObject : Cannot... |
| 20996 | This article demonstrates how to obtain the window handle of a Microsoft Office application while automating that application from Microsoft Visual C# .NET. |
| 20997 | This article demonstrates how to obtain the window handle of a Microsoft Office application while automating that application from Microsoft Visual Basic .NET. |
| 20998 | This step-by-step article discusses how to use the object models for Office applications to avoid dialog boxes during Automation. It also provides an example of how to simulate user input to programmatically dismiss a dialog box that cannot be avoided... |
| 20999 | This step-by-step article demonstrates how to automate Excel from Visual C++ .NET to create a command bar that contains buttons, drop-down list boxes, combo boxes, and pop-up menus. The Visual C++ .NET application catches and responds to the Click and... |
| 21000 | When you install Microsoft Office, the amount of hard disk space required may vary, depending on the type of installation you perform and the version of Office. This article contains a listing of the amount of space required for the various types of... |
| 21001 | When you use one of the programs listed at the end of this article, and you attempt to open the Save In list in the Save As dialog box, the program appears to stop responding (hang) for a long time. If you click Cancel or attempt to close the Save As... |
| 21002 | To troubleshoot activation or licensing issues, you may have to force the re-entry of your Office XP product identification code. This article describes how to force your computer to prompt you for your Office XP product identification code. NOTE :... |
| 21003 | The Office Setup program accepts a number of optional command-line switches that you can use to control how the Setup program operates. This article lists the switches and describes the functionality of each switch. |
| 21004 | When you attempt to install Microsoft Office 2000, or insert the CD-ROM into the CD-ROM drive, the following error message may appear: Some default settings in Microsoft Office 2000 setup do not work properly on a Windows Terminal Server. To install... |
| 21005 | A Visual Studio .NET Shared add-in may not be displayed as expected in the Add-ins list in the Microsoft Office COM Add-Ins dialog box. |
| 21006 | When you try to install a patch for Office XP or for one of the Office programs that is listed at the beginning of this article, you may receive a message that prompts you to insert a CD-ROM for another program or patch. |
| 21007 | When you try to install or remove Office XP SP-1, you may receive an error message similar to the following: Error 1612. The installation source for this product is not available. Verify that the source exists and that you can access it. |
| 21008 | When you try to edit old or new documents, you may receive an error message similar to the following: This command is not available because the document is locked for edit. You cannot create any new documents and you cannot save documents.... |
| 21009 | When Office XP is distributed to many users as part of a hard disk image, those users should not have to activate the product. However, the first time that a user starts an Office program that was installed in this way, they may be prompted to... |
| 21010 | When you scroll in a document or resize the program window in any of the Office XP programs listed at the beginning of this article, you may experience one or more of the following symptoms: The positions of graphics or text, or both, are incorrect.... |
| 21011 | When you attempt to install one of the programs listed at the beginning of this article, your may receive the following error message Error file name GFVXD(01) + 00002F13 Error: OE:0028:C15E2953 installing program where program is the name of the... |
| 21012 | When you click one of the Help topics displayed by the Office Assistant, the following behavior may occur: The Office Assistant becomes hidden. When you click the window for the active Office program, the Office Assistant reappears. |
| 21013 | When you attempt to install the upgrade version of any of the products listed above, you may receive the following error message: Setup failed to locate a valid qualifying product on your machine. Please select the drive where a qualifying product can... |
| 21014 | When you click the File menu to choose a file from the most recently used file list, the most recently used file list is missing. When you click Options on the Tools menu and then click the General tab, you see that the Recently used file list check... |
| 21015 | When you are using one of the programs listed at the beginning of this article and you try to use a voice command to select a menu item, the menu item is not selected. |
| 21016 | When you view the thumbnail of an image file in Windows Explorer or the Open dialog box of an Office XP program, the thumbnail image is not displayed. |
| 21017 | When a user who does not have the Office XP Web Components installed on their computer accesses a Web page that contains an Office XP Web Component, he or she may receive a message similar to the following: To use this Web page interactively, you must... |
| 21018 | When you print a document that contains AutoShapes, the curves on these AutoShapes may appear as line segments instead of smooth curves. |
| 21019 | When you click Paste All in the Office Clipboard to paste multiple entries in your document, and then you click Undo on the Edit menu, not all of the items pasted are undone. Only the most recent item pasted from the Clipboard (the last item in the... |
| 21020 | When you view your company name in the startup splash screen for the Office programs, the name may be different from the name that appears in the dialog box when you click About program name on the Help menu. (For example, in Word 2002, you click... |
| 21021 | In the products listed at the beginning of this article, the Help topic Turn on or off transparent floating toolbars is incorrect. The topic states the following: Turn on or off transparent floating toolbars On the View menu, point to Toolbars , and... |
| 21022 | This step-by-step article describes the location of templates in Microsoft Office XP, how the Templates dialog box (click General Templates in the task pane) displays available templates, and the registry settings that control where to find your... |
| 21023 | When you install a Microsoft Office XP service pack, update, or security patch on your computer, you may be prompted to insert your Office XP CD-ROM. This article discusses why Office XP service packs, updates, and security patches may require your... |
| 21024 | When you receive an error message in any Microsoft Office program, the customizable alert button may be missing. |
| 21025 | When you try to install Microsoft Office XP, you receive the following error message: Error 2355. Setup cannot access a file cabinet. Check your connection to the network, or CD-ROM drive. For other potential solutions to this problem, see C:\Program... |
| 21026 | Microsoft Office XP introduces two new properties to the CommandBarButton object: the Mask and Picture properties. You can use these properties to place pictures on custom generated command bar controls. Note These properties are also available in... |
| 21028 | When you start one of the Office XP programs that was installed from an Enterprise edition of Office by using a volume license key, you may receive the following message Microsoft Office XP edition has detected a significant change in your machine... |
| 21029 | Task panes, a new feature in Microsoft Office XP, provide a common area for those commands that may require more information or options than a toolbar can provide. This article describes task panes and how to use them. |
| 21030 | In any Microsoft Office XP program, you may hear a beep when you click a menu item or anywhere within the document, or if you press a key on the keyboard. - or - If you click Show the Office Assistant on the Help menu or press the F1 key, the Office... |
| 21031 | When you have multiple documents open in a Microsoft Office program, and you press ALT+TAB to switch to another document, there is one more document icon displayed than there are open documents. |
| 21032 | When you use one of the Microsoft Office XP products that are listed at the beginning of this article, you may receive the following error message: Microsoft Office program has encountered a problem and needs to close. We are sorry for the... |
| 21033 | When you install any of the Office products listed at the beginning of this article, you may receive an error message similar to the following: Internal Error 2889: Please contact product support for assistance. |
| 21034 | After you install Office 2000 or Office XP, the Activation Wizard appears each time that you start an Office program. |
| 21035 | When you access a local area network (LAN) or intranet share, or intranet Web site by using an Internet Protocol (IP) address or fully qualified domain name (FQDN), the share or Web site is identified as being in the Internet zone instead of the Local... |
| 21036 | This article describes how to obtain a new product key for your Microsoft Office 2000 program setup if your product key label is damaged or missing. |
| 21037 | In any of the Microsoft Office XP programs listed at the beginning of this article, when you select the Pumpkin (large) desktop scheme, the selected menu item may be gray instead of the standard Pumpkin (large) desktop scheme of purple or white with a... |
| 21038 | After you install Microsoft Office XP, you cannot start an Office program. When you try to start an Office program, the Windows Installer starts, then stops, and then you receive the following error message: Internal Error 2744. |
| 21039 | When you use the Handwriting feature on the Language bar for the first time, Microsoft Office XP creates a file called Inferno.log in the root directory of drive C on your computer. Each time that you use the Handwriting feature, an entry of your... |
| 21040 | When you print a Microsoft Office XP document to an IBM InfoPrint 20 PS printer, and you choose to print hidden text, the hidden text is not printed as expected. |
| 21041 | Microsoft Office XP offers a new, easy-to-use, crash-reporting tool called Application Error Reporting. If a Microsoft Office program crashes, the Application Error Reporting dialog box appears and requests your permission to send a detailed report of... |
| 21042 | When you attempt to use Secure Sockets Layer (SSL) to connect to a SharePoint team Web site, the Office program that you are using stops responding. For example, in any Office XP program or Microsoft Internet Explorer, when you attempt to open a... |
| 21043 | When you use keyboard commands to open the task pane in a Microsoft Office XP program (press ALT+F, and then press N), you may be unable to close it with a keyboard command as expected. |
| 21044 | You may experience any of the following symptoms: When you copy a file over the network in Windows XP, if the source file is located on a Windows 2000-based network share, you may receive either of the following error messages: File or network path no... |
| 21045 | Handwriting recognition is a new feature in Microsoft Office XP. The Handwriting Recognition in Office XP white paper provides a general overview of handwriting recognition. Topics include installation and setup, system requirements, working with... |
| 21046 | When you try to upsize a Microsoft Access database (.mdb) to Microsoft SQL Server, the Upsizing Wizard fails to export data for large tables. |
| 21047 | Note This article does not apply to Microsoft Windows XP or Microsoft Windows 2000. When you try to install any of the products listed at the beginning of this article, you may receive an error message similar to the following Error 1402. Could not... |
| 21048 | When inserting records into a Microsoft Access database, immediately attempting to reselect them occasionally does not return all inserted records. This occurs even when the records are inserted and reselected on the same connection. The problem... |
| 21049 | When you open a Microsoft Access 97 database file in Access 2002, you receive the following message repeatedly even if you have selected Open Database : You have selected a database created in a previous version of Microsoft Access. You can convert or... |
| 21050 | This article demonstrates how to automate Microsoft Access from Microsoft Visual C# .NET. The topics and the sample code show you how to do the following: Open a database in Access. Print or preview an Access report. Show and edit an Access form.... |
| 21051 | When you try to change the properties of your printer from one of the Microsoft Office XP programs listed at the beginning of this article, you may receive an error message similar to the following Microsoft program name has encountered a problem and... |
| 21052 | When you use one of the Microsoft Office XP programs listed at the beginning of this article, you may receive an error message similar to the following : Microsoft program name has encountered a problem and needs to close. We are sorry for the... |
| 21053 | This article contains links to other articles about issues that you may experience when you upsize a database in Microsoft Access. |
| 21054 | When you use one of the Microsoft Office XP programs that is listed at the beginning of this article, you may receive an error message that is similar to the following: Microsoft program has encountered a problem and needs to close. We are sorry for... |
| 21055 | When you try to save a modified query or run a query, Microsoft Access may quit unexpectedly without an error message. |
| 21056 | This article describes how to use the HTML document object model to determine if a data access page is open in Microsoft Access or Microsoft Internet Explorer. |
| 21057 | This article shows you how to create an SQL pass-through query in Microsoft Visual Basic for Applications (VBA) with Microsoft ActiveX Data Objects (ADO). |
| 21058 | This article lists some of the most common specifications for Microsoft Access. |
| 21059 | Speech recognition is a new feature in Microsoft Office XP. The Speech Recognition in Office XP white paper provides a general overview of speech recognition. Topics include installation and setup, system requirements, the user interface, using... |
| 21060 | On a data access page, when you set the control source of a text box or a Bound SPAN to an expression that references the HTML document object, Microsoft Access may stop responding, or you may receive the following error message, and then Microsoft... |
| 21061 | Microsoft Access 2002 allows you to enable and add additional users to a Microsoft Access 97 workgroup information file (.mdw). However, you are prevented from converting the file to Access 2000 or 2002 format. In this case, the Convert Database Into... |
| 21062 | When you are saving a data access page or viewing it in Page View, you receive the following error message, and then Microsoft Access quits: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. When you... |
| 21063 | This article describes how to programmatically rotate a chart in PivotChart view in Microsoft Access. Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the... |
| 21064 | Microsoft Access provides an automatic row fix-up feature that uses links between tables to update (fix up) records in queries and forms. You can use this feature to enter a single value, and then Microsoft Access automatically looks up and displays... |
| 21065 | You may have a need to copy an existing database from Microsoft SQL Server 2000 and to place the database on another computer that is running Microsoft SQL Server 2000 Desktop Engine. This article describes how to do so. The process involves... |
| 21066 | When you use the query design grid to modify a query in a Microsoft Access project (.adp) file, you eventually run out of system resources. Then, you may experience one or more of the following symptoms: Microsoft Windows returns the following error... |
| 21067 | When you reset a customized toolbar button or menu command in any Microsoft Office program, if the control style has been changed, the reset operation may not change the item back to the original style as expected. This behavior occurs both when you... |
| 21068 | When you click Paste All on the Microsoft Office Clipboard, the items are not pasted into your document in the same order that they appear on the Clipboard. |
| 21069 | When you open Microsoft Access and a form through Automation and set focus to the form's custom menu bar, you receive the following Microsoft Visual Basic error message: Run-time error '-2147467259 (80004005)': Method 'SetFocus' of object... |
| 21070 | When you run a procedure that references an object from the Microsoft Jet and Replication Objects (JRO) 2.5 Library, you may receive the following error message: Microsoft Visual Basic Compile error: Can't find project or library. In addition, the... |
| 21071 | If you enter a partial date in a field that is assigned the Date/Time data type, Microsoft Access fills in the current year automatically. |
| 21072 | After you rename Vbe6.dll and then do one of the following you open a replicated database you open a database under Microsoft Visual Source Safe Control you open a database in which you are creating a data access page you experience an infinite loop... |
| 21073 | If you move a database file that was created in an earlier version of Microsoft Access, for example, in Microsoft Access 97, from one computer to another computer, and you then try to open the database on the other computer, you receive the following... |
| 21074 | When you insert a TIFF file in a Microsoft Office XP document or e-mail message, the Office program may stop responding. Additionally, you receive the following error message. (Microsoft Word is used in this example.) Microsoft Word has encountered a... |
| 21075 | You are unable to import Microsoft Excel Spreadsheets and HTML files. When you use the Import Wizard to import a Microsoft Excel spreadsheet or a Hypertext Markup Language (HTML) file, you see a message in the status bar that says Import Spreadsheet... |
| 21076 | After you install a Microsoft Office Service Pack or you upgrade from one version of Microsoft Office to a newer version, you cannot access the Internet. |
| 21077 | This article provides step-by-step samples that show you how to automate Microsoft Access from Visual Basic .NET. The topics and the sample code show you how to do the following: Open a database in Access Print or preview an Access report Show and... |
| 21078 | This article describes how you can start another application from a text box on a Microsoft Access form. Steps to Start Another Application from a Text Box in Microsoft Access You can start another application from a text box that is on a form by... |
| 21079 | When you apply a sort to a table, a view, a stored procedure, or a function in a Microsoft Access project (.adp) file, you receive the following error message, and then Microsoft Access crashes. Microsoft Access has encountered a problem and needs to... |
| 21080 | If you add code to one of the new events in Access 2002, and you then compile the database in Access 2000, when the code is run in Access 2002, you may receive the following error, and then Microsoft Access quits: Microsoft Access has encountered a... |
| 21081 | The Jet compact utility, JETCOMP.exe, is a stand-alone utility that compacts databases created with Microsoft Jet database engine 3.x and 4.x. This utility may be run in conjunction with Microsoft Jet database engine 3.x and 4.x for recovering... |
| 21082 | When you open a database that was created in Microsoft Access 97 or earlier in Microsoft Access 2002, you receive the following message. You also receive this message when you open an object in this database in Design view. You can't make changes to... |
| 21083 | When you use the Add/Remove Programs tool in Control Panel to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) from the MSDE2000 folder of the Microsoft Office XP installation CD-ROM, you may find that nothing is installed. Setup may start... |
| 21084 | In Microsoft Access 2002 or Microsoft Access 2003, when you try to open or convert a secured Microsoft Access 97 or earlier database file, you may receive the following error message: The current user account doesn't have permission to convert or... |
| 21085 | When you click a hyperlink to a Microsoft Office document in your Web browser or you double-click an Office document that is attached to an e-mail message in Microsoft Outlook or Microsoft Outlook Express, you are prompted to confirm whether you want... |
| 21086 | If your Access project (.adp) uses Microsoft SQL Server as the database engine, you can link data from other programs and other file formats, such as Microsoft Excel, dBase, Paradox, or XML (import only). You can also import or link a Microsoft Access... |
| 21087 | This article describes Microsoft Office XP features that are turned off or not installed when you select Not Available for Microsoft Visual Basic for Applications when you install Office XP. |
| 21088 | When you open or make a reference to a linked table in Microsoft Access, you may receive one of the following error messages: Couldn't find input table or query 'name' -or- Could not find file 'drive:\path\filename' -or- The Microsoft Jet... |
| 21089 | This article lists some of the technical resources available on the Microsoft World Wide Web site that can help you find answers to questions about Microsoft Office XP. |
| 21090 | When you save a form or a report as a data access page in a Microsoft Access project (ADP) file or a Microsoft Access database (MDB) file, you receive the following error message: Microsoft Access is unable to create the data access page. The file you... |
| 21091 | When users in a multiuser environment try to open a Microsoft Access project (.adp) file or a Microsoft Access project extension (.ade) file, they may receive an error message similar to the following: The database DatabaseName will be opened... |
| 21092 | When you open a linked table in Microsoft Access 2002 that can display related records in a subdatasheet, the process takes noticeably longer than it does if you use the same database in Microsoft Access 97. |
| 21093 | When you start a Microsoft Office program with the /safe command-line switch, the Microsoft Windows Installer dialog box may appear. The Installer dialog box may remain on the screen for several minutes before the Office program starts. |
| 21095 | When you import any type of data into a database that you previously added to Microsoft Visual SourceSafe control, you receive the following error message: Microsoft Access To import tables, relationships, menus, toolbars, import/export specs or data... |
| 21096 | When you start one of the Microsoft Office XP programs on a computer that is running Microsoft Windows NT, Microsoft Windows 2000, or Microsoft Windows XP, the program starts and then immediately quits. |
| 21097 | When you add a new record to a grouped data access page, the page unexpectedly closes. You receive no error message or warning message. The page simply disappears, and then either Microsoft Access or Microsoft Internet Explorer also quits, depending... |
| 21098 | After you install the Microsoft URLScan utility or the IIS Lockdown Tool on the Microsoft Internet Information Services (IIS) server that is hosting the Microsoft Jet Internet Synchronizer, you receive the following error message when you try to... |
| 21099 | When you author any new Microsoft Operations Manager (MOM) reports by using Microsoft Access 2002, MOM reporting may not work on Access 2000 due to compilation errors. |
| 21100 | When you try to execute the Microsoft SQL Server stored procedure sp_setapprole from a Microsoft Access project (ADP), you receive the following error message: Application roles can only be activated at the ad hoc level. |
| 21101 | When you use Data Transformation Services (DTS) to transfer data from a table that is based on Microsoft SQL Server to Microsoft Excel, DTS reports a successful execution of a package, but the data is not transferred. |
| 21102 | When you import a Microsoft SQL Server 7.0 table from an Access project (.adp) into an Access project that is connected to Microsoft SQL Server 6.5, you receive the following error message, and then Microsoft Access quits: Microsoft Access has... |
| 21103 | If you specify a nonexistent server in the connection information for a Microsoft Access project (ADP), you receive one of the following error messages: Microsoft Data Link Error Test connection failed because of an error initializing provider.... |
| 21104 | When you view the Application Error Reporting log in Microsoft System Information after an Office program stops responding (hangs or crashes), the date of the incident is not displayed as expected. This behavior occurs when you use Microsoft Office XP... |
| 21105 | On a Microsoft Windows Millennium Edition (Me)-based computer, when you attempt to view the system information summary of a Microsoft Office XP program, you may receive an error message similar to the following: Microsoft program 2002 has not been... |
| 21106 | When you try to send a Microsoft Access database table (.mdb) as an .XML format attachment by clicking Send To on the File menu in Access, you may receive the following error message: Microsoft Access Can't Send this format in a Mail Message. |
| 21107 | A data access page is an HTML page that has an Office Web Component embedded into it. The Office Web Component stores connection information about a data source. This article describes how to use data access pages to connect an HTML page to tables in... |
| 21108 | This article describes how to define relationships in a Microsoft Access database. It includes the following topics: What Are Table Relationships Types of Table Relationships One-To-Many Relationships Many-To-Many Relationships One-To-One... |
| 21109 | This article describes what is required to create an updateable form that is bound to an ActiveX Data Objects (ADO) Recordset object. |
| 21110 | This article shows you how to edit records in related tables. It includes the following topics: How to Add or Edit Data in a Datasheet (Table or Query) or in a Form How to Save a Record in a Datasheet or in a Form How to Delete a Record in a Datasheet... |
| 21111 | When you attempt to start a Microsoft Office XP program, the Microsoft Windows Installer starts, and then you may receive the following message: Please wait while Windows configures Microsoft Office version Gathering required information... |
| 21112 | To optimize PivotTable List performance in Microsoft Access, use the following tips, which are explained in detail in the More Information section: Hide details in the PivotTable list. Use a query to restrict unnecessary fields and records.... |
| 21113 | Session Summary In this Support WebCast session, you will learn how to set up, configure, write queries for, and troubleshoot various linked servers with Microsoft SQL Server. You will hear about the architecture of linked servers, and how to... |
| 21114 | This article describes several tips for improving performance when you access data from an ODBC data source. |
| 21116 | For various reasons, you may decide to split your database into a front-end/back-end application. The back-end database contains the tables and is stored on a file server. The front-end database, which links to the back-end tables, contains all the... |
| 21117 | Use this step-by-step guide to call a .NET class library from Visual Basic for Applications. This sample shows how a Visual Basic for Applications program can use a Visual Basic .NET class library to encrypt and decrypt a string. You can use the... |
| 21118 | This article shows you how to modify query properties in Microsoft Access. This information is useful if you want to perform such tasks as: Change the display of fields. Create top value queries. Add an alias for a table. Change field captions and... |
| 21119 | By using Jet 4.0, a user is able to call unsafe Visual Basic for Applications functions in query statements from Microsoft Access. For example, the following statement would result in all files being deleted from a computer's current folder: SELECT... |
| 21120 | Session Summary This session will present an overview of how to use the basic feature set of the PivotTable and PivotChart features in Microsoft Access 2002. Microsoft Access 2002 introduces PivotTable and PivotChart views to tables, queries, views,... |
| 21121 | This article shows you how to format and print a table from the Microsoft Access user interface. |
| 21122 | In Microsoft Access, you can add a field to a table to look up information in another table. You typically use this technique when you want to create relationships between tables. For example, perhaps you have a Products table with a Category field... |
| 21123 | In Microsoft Access 2002, you can view tables, queries, views, functions, and forms in PivotTable view. This is possible because Access 2002 natively hosts the Microsoft Office Web Components. This article shows you how to use the Office Web... |
| 21124 | This article provides an overview and sample code for importing Outlook contact information into an Access table. The sample code in the More Information section of this article should be run from an Access global module. The code provides a... |
| 21125 | This step-by-step article describes how to use the Microsoft Office Application Recovery tool. This tool provides you with a way to potentially recover data from an Office program that stops responding (hangs). If an Office program stops responding... |
| 21126 | When you try to create a data access page in Microsoft Access 2002, you may receive the following message: Content within this application coming from the Web site listed below is being blocked by Internet Explorer Enhanced Security Configuration.... |
| 21127 | When you try to link Open Database Connectivity (ODBC) tables to an Access database, Access may quit unexpectedly. You may receive the following error message: Microsoft Access has encountered a problem and needs to close. If you click Debug , you may... |
| 21128 | When you try to connect to a Microsoft SQL Server database from a Microsoft Access project (ADP), you may receive the following error: Microsoft Access could not find the database on the server. Verify that the database name is correct. If you click... |
| 21129 | There are a number of reasons corruption can occur in a Microsoft Access database. This article provides a list of references to Microsoft Knowledge Base articles that may assist you in resolving corruption in your database. |
| 21130 | In a subdatasheet, you can view and edit related or joined data in a table or a query, in a form datasheet, or in a subform. For example, in the Northwind sample database, the Suppliers table has a one-to-many relationship with the Products table;... |
| 21131 | When you delete a Microsoft Access database object that is under Source Code control, and you then recover the object by using Visual SourceSafe Explorer, when you click Get Latest Version or Check Out , the object is not made available in the Access... |
| 21132 | Table names in Microsoft Access project may be displayed incorrectly. They may be inside quotation marks or may appear broken, with their parts transposed and inside parenthesis. For example, the table name Categories may be displayed in ways similar... |
| 21133 | When you add a new record to a subform in a Microsoft Access project (ADP), you receive the following error message: The data was added to the database but the data won't be displayed in the form because it doesn't satisfy the criteria in the... |
| 21134 | The column format on a Microsoft Excel worksheet is lost or replaced with a different format after you import the data into Microsoft Access or create a link to the Excel worksheet. |
| 21135 | When two users change the same record at the same time in a Microsoft Access project or in a Microsoft Access database connected to SQL Server, a write conflict message is not received if the data type of the field is Text or Image. |
| 21136 | This article provides an overview of how you can secure a database so that it is not changed or copied by other Microsoft Access users. This article assumes that you have a thorough understanding of the pieces that make up the Microsoft Access... |
| 21137 | When you try to preview or print a report in Microsoft Access, you receive the following error message: Microsoft Access cannot communicate with the printer. You may receive this error for one of the following reasons: Before beginning this procedure,... |
| 21138 | When you need unlimited users, 24x7 support, and ACID transactions, Microsoft strongly recommends that you use Microsoft SQL Server with Internet Information Server (IIS). Although Active Server Pages (ASP) works with any OLE DB and ODBC-compliant... |
| 21139 | If your regional settings are configured to use a comma as the decimal separator (for example, in the German regional settings), filtering by selection on a Decimal field may generate the following error message when you link to an Open Database... |
| 21140 | The Show Desktop button on the Quick Launch portion of the taskbar minimizes all the open windows on the desktop. When you click it a second time, the windows are not restored as expected but remain minimized. |
| 21141 | This article discusses and explains how COM (Component Object Model) determines which version of an Office application is loaded when you use Office Automation. |
| 21142 | An Automation client that successfully automated an Office 97 application crashes with the same Office 97 application after the program is recompiled using an Office 2000 or later type library. You might receive an error similar to one of the... |
| 21143 | When you are automating an Office application from Visual Basic (VB), the Office application may display a dialog box. The dialog box causes the Visual Basic application to appear to stop responding (or hang) because VB is waiting for the dialog box... |
| 21144 | When a modal form is displayed from an ActiveX EXE component called from VBA, the Office application that made the call does not repaint correctly while the dialog is displayed. |
| 21145 | While automating an Office application, you might receive a large error value such as -2147221494. Troubleshooting the error is greatly facilitated by determining the exact description of the error. This article discusses several methods of obtaining... |
| 21146 | When you use the OutputTo action or method to output a report to another format, you receive one of the following errors: Run-time error '2024': The report snapshot was not created because you do not have enough free disk space for temporary work... |
| 21147 | This article illustrates by example how you can create an MFC Automation client to retrieve a list of Visual Basic for Automation (VBA) macros ( Sub and Function procedures) from a Microsoft Office document. |
| 21148 | In a Microsoft Access Database Project, two forms may be based on the same recordset. If you edit a record in one form, and then you try to save the record by using the BeforeUpdate event procedure, an incorrect record may be referred to in the... |
| 21149 | Developers can use Automation to Microsoft Office to build custom solutions that utilize the capabilities and features that are built into the Office product. While such programmatic development can be implemented on a client system with relative... |
| 21150 | In a Microsoft Access database, if you view a report in the Print Preview mode that is linked to a subreport by using an AutoNumber field, and if the Field Size property of the field is set to Replication ID , the subreport may not display any data. |
| 21151 | This article demonstrates how to obtain the window handle of an Office application with Microsoft Foundation Classes (MFC) while automating that application from Visual C++. |
| 21152 | This step-by-step article describes how to reset a menu in a Microsoft Office program back to its default first-run condition. In addition, this article describes the following: What the Personalized Menus and Toolbars feature is. Two methods for... |
| 21153 | When you try to install one of the programs listed at the beginning of this article, on a computer that is running Microsoft Windows 95, Microsoft Windows 98, or Microsoft Windows Millennium (Me) you may receive the following error message: Error... |
| 21154 | You can use Automation to control Microsoft Office components from your Visual C++ applications. This article provides the basic information you need to automate Office, as well as pointers to resources and sample code. |
| 21155 | You may use the Export option in Access to export a report to Microsoft Excel. If the report has numeric values in the text field, the resultant Excel worksheet may have incorrect values. This problem may also occur when you use the Analyze It with... |
| 21156 | This article lists the minimum security settings that are required to connect to a remote Microsoft Access database from ASP.NET, including: Windows NT File System (NTFS) settings Microsoft Internet Information Services (IIS) settings Local security... |
| 21157 | This article includes sample code that illustrates how you can programmatically determine the installation path for a Microsoft Office application given the ProgID for that application. |
| 21158 | Microsoft Office applications can act as ActiveX Servers. They provide client applications design-time access to an Object library, or type library, that enables client applications to view an Office application's objects, properties, methods, and... |
| 21159 | Using Jet 4.x, a user is able to call unsafe Visual Basic for Applications functions in query statements from Microsoft Access. For example, the following statement would result in all files being deleted from a computer's current folder: SELECT... |
| 21160 | When you try to open an Access 2.0 database file (.mdb) in Microsoft Access 2000 or Access 2002, you may receive an error message that is similar to the following: Disk or network error. |
| 21161 | This article demonstrates how to use the Windows Installer to find the installation path of Microsoft Office or an Office XP or an Office 2003 applications. |
| 21162 | This article demonstrates how to obtain the window handle of an Microsoft Office application while automating that application from Visual Basic. |
| 21163 | If you try to gain access to an Access 2000 or Access 2002 database, you may receive one of the following errors within your Visual Basic program. If you are using Microsoft ActiveX Data Objects (ADO) (or the ADO Data Control), you receive the... |
| 21164 | When you try to use GetObject (Microsoft Visual Basic) or GetActiveObject (Microsoft Visual C++) to automate a Microsoft Office application, you get one of the following error messages, even though the Office application is running: Run-time error... |
| 21165 | When you delete a column from a table that is opened in the Datasheet view in Microsoft Access, the ColumnOrder property of the ActiveDatasheet property may display an incorrect value. |
| 21166 | If you enable the keyboard layout of your computer to use a right-to-left (bidirectional) language (such as Syriac) in a Microsoft Access database project, and you try to create a table in Design view, the column names in the table may appear as a... |
| 21167 | This article discusses the different behaviors that occur when you use the GetObject and CreateObject functions with various versions of Microsoft Office applications. GetObject and CreateObject are functions that are provided by Microsoft Visual... |
| 21168 | When you query a table that is linked to a Microsoft Excel spreadsheet, you may receive the following error message: Numeric field overflow. |
| 21169 | Microsoft does not recommend or support Automation to a Microsoft Office application from an unattended user account. on why Microsoft does not recommend automation under this context 257757 INFO: Considerations for Server-Side Automation of Office... |
| 21170 | Microsoft does not recommend or support Automation to a Microsoft Office application from an unattended user account. on why Microsoft does not recommend automation under this context 257757 INFO: Considerations for Server-Side Automation of Office... |
| 21171 | When you click a hyperlink in an embedded Microsoft Excel workbook, Excel generates the following error and does not select the range indicated by the hyperlink: An Unexpected Error Has Occurred |
| 21172 | When you try to roll back a record, Microsoft Jet may commit the record instead. |
| 21173 | This article contains information about Microsoft Jet 4.0 database engine Service Pack 8 (SP8). about how to obtain the latest service pack for Jet 4.0 239114 How to Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine For... |
| 21174 | When you run a query in a Microsoft Access database that joins linked Microsoft SQL Server tables from different sources or databases, the query may not return any data. However, when you run a similar query that refers to the linked SQL Server tables... |
| 21175 | When you try to obtain information about the Timer event from Microsoft Access Help in Access 2000 or Access 2002, the maximum value of the TimerInterval property of an Access form is incorrectly listed as 65,535 milliseconds. |
| 21176 | When you attempt to import tables from an Access 2000 or 2002 database to Outlook 2000 or 2002, the following error message may appear: An ODBC error has occurred in the Microsoft Access translator while opening a file to build a field map.... |
| 21177 | When you click a hyperlink in a Microsoft Office document in an Office program, you may receive an error message similar to the following: This operation has been canceled due to restrictions on this computer. Please contact your system administrator. |
| 21178 | When you run a parameter query so you can query a table that is linked to Microsoft SQL Server, the query may return no records. However, you expect some records to be returned. |
| 21179 | Microsoft Visual Basic for Applications (VBA) is based on the Microsoft Visual Basic development system. Microsoft Office products include VBA and use it to perform certain functions. You can use VBA to build customized programs that are based on an... |
| 21180 | When you use the Oracle ODBC driver to export an Access table that has fields of data type Single or Double, the driver fails to export those fields as follows. The Microsoft Oracle driver displays the following error message: Microsoft Access was... |
| 21181 | When you use any of the Microsoft Office XP or Microsoft Office 2000 programs, you may notice one or more of the following behaviors: Publisher document icons are displayed as generic icons. Microsoft Publisher is no longer displayed under Programs on... |
| 21182 | Microsoft has adopted a standardized naming schema for all hotfix (patch or update) packages for Office that are created and distributed by Microsoft. The new naming schema will go into effect for all hotfix packages in May, 2003. Note An Office... |
| 21183 | When you use = Null instead of Is Null as the criteria for a query, the query may not return the expected results. For example, a query may return no records if you use = Null as the criteria in a field that has records that have no data.... |
| 21184 | Session Summary In this session, we will discuss common combo box usage in a Microsoft Access database. This session will cover what combo boxes are, how they are created, and the distinct properties of a combo box. It will also introduce various... |
| 21185 | This article describes how to determine the current Microsoft Jet 4.0 database engine service pack level. This article permits you to download the latest Service Pack to the Jet 4.0 database engine, provides you setup instructions, lists the files... |
| 21186 | When you try to edit a record in Microsoft Office Access that is being edited by another user, the record may not be shown as locked. Also, Access may stop responding for a significant period of time during the attempt to edit a record that is... |
| 21187 | The Microsoft Office XP Setup program and the Microsoft Access 2002 Setup program only update system files in certain situations and to a certain level. Therefore, after you install Access you may not have the latest version of the Microsoft Jet 4.0... |
| 21188 | When you attempt to use the Sign out of Microsoft Passport command, the command may be unavailable and you are therefore unable to sign out. In Microsoft Excel 2002, the Sign out of Microsoft Passport command is available, but when you click it,... |
| 21189 | Data Transformation Services (DTS) is an alternative method that you can use to move data from an Access database to Microsoft SQL Server. Note The previous version of Microsoft SQL Server 2000 Desktop Engine was called Microsoft Data Engine (MSDE).... |
| 21190 | This article provides an overview and sample code for creating Microsoft Outlook contacts from information stored in a Microsoft Access database. The sample code in the More Information section of this article should be run from a Microsoft Access... |
| 21191 | When you try to merge data from a Microsoft Access query with Microsoft Word, Microsoft Word displays one of the following error messages: Word could not merge the main document with the data source because the data records were empty or no data... |
| 21192 | After you open a Microsoft Access project (ADP) that appears to connect successfully, no tables or queries are visible in the Database window, and you may receive the following error messages: When you are creating a new table, a stored procedure, or... |
| 21193 | This article shows you how to programmatically change the connection of a Microsoft Access project (ADP) file. |
| 21194 | Microsoft Access allows you to set the Recordset property of a report to an ActiveX Data Objects (ADO) recordset. However if you set the Recordset property twice in the OnOpen event of a report that uses an ADO recordset, you receive the following... |
| 21195 | After you change a relationship that is made up of multiple fields in the data outline on a data access page, Microsoft Access may stop responding (hang) or may quit unexpectedly when you browse through the page. |
| 21196 | When you use the vertical scroll bar to scroll through a text box on a subform, you may receive the following error message: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. When you view the details... |
| 21197 | The Microsoft Access 2000 Security Manager enables the database-security administrator to make knowledgeable security decisions as the database and its workgroup evolve. By presenting all security settings in a single view, the administrator can set... |
| 21198 | In a Microsoft Access project (ADP), when you try to link to a particular data source when you are using an Open Database Connectivity (ODBC) File Data Source Name (File DSN) connection, you receive the following error message: This data source... |
| 21199 | When you try to install Microsoft SQL Server 2000 Desktop Engine on a computer that already has SQL Server 2000 Desktop Engine installed, you receive the following error message. The installation package could not be opened. Verify that the package... |
| 21200 | After you upgrade to Microsoft Windows NT 4.0 Service Pack 6/6a on a client computer without upgrading the server to the same service pack, opening Access objects such as forms, reports, macros, or modules in Design View across a network is unusually... |
| 21202 | In Microsoft Access (and other Microsoft Office applications), you can use the Shell command in Visual Basic for Applications (VBA) code to start another application. Although you can start most applications in this manner, the Shell command does not... |
| 21203 | When you try to view an animation that describes new features in Microsoft Access, you experience the following symptoms in the Microsoft Access Help dialog box: You receive the following message: Your current security settings prohibit running... |
| 21204 | You cannot update data in a view in a Microsoft Access project (ADP). |
| 21205 | When you apply a filter in a Microsoft Access project to display a subset of records, you may receive a result set that does not match the filter condition. |
| 21206 | When you use keyboard actions to link an Open Database Connectivity (ODBC) table, Access 2002 may quit unexpectedly. You may receive the following error message: Microsoft Access has encountered a problem and needs to close. We are sorry for the... |
| 21207 | This article shows you how to view and edit relationships in a Microsoft Access database. |
| 21208 | When you start an Office XP program or try to use the Office Assistant from within a program, you may receive the following error message: The Office Assistant requires Microsoft Agent 2.0 or later. This product is available on the Office System Pack. |
| 21209 | With Microsoft Access Snapshot Viewer you can distribute a snapshot of a Microsoft Access database that permits you to view the snapshot without Access installed. For example, you may want to send a supplier an invoice that is generated by using an... |
| 21210 | When you import a table into a Microsoft Access project (ADP) from another Access project, you may receive an error message similar to the following: [Microsoft][ODBC SQL server Driver][SQL Server] Line 5: Incorrect Syntax near 'COLLATE'. When you... |
| 21211 | When you use Visual Basic for Applications (VBA) code to switch between views on open tables or queries, you may receive the following error message, and then Microsoft Access quits: Microsoft Access has encountered a problem and needs to close. We... |
| 21212 | Microsoft Access includes a tool called the Microsoft Script Editor that you can use to edit the script behind data access pages. There are four ways to open the Script Editor from Design view of a data access page. |
| 21213 | The ADOAcc02.exe file contains the Using ADO in Microsoft Access 2002 white paper, which discusses how to use ActiveX Data Objects (ADO) with forms and reports in Microsoft Access 2002. It also discusses the new Client Data Manager (CDM) in... |
| 21214 | When you try to open a form or a report in a replicated database, and if the database is in Microsoft Access 2000 format, and you if then try to open the Visual Basic Editor, you receive the following error message Microsoft Access failed to create... |
| 21215 | Microsoft supplies several primary interop assemblies (PIAs) that contain the official description of the most commonly used Microsoft Office XP type libraries. These Microsoft Office XP PIAs make interoperability easier between managed code and... |
| 21216 | In a Microsoft Access project, when you try to export a table to an Access database (*.mdb) and the table contains fields that have long field names, Microsoft Access closes unexpectedly. You receive the following error message: Microsoft Office... |
| 21217 | When you import an Extensible Markup Language (XML) file into a Microsoft Access project (.adp), you may receive one of the following error messages: Microsoft SQL Server Desktop Engine must be on the machine running Microsoft Access. -or-... |
| 21218 | Microsoft has expanded its online services to a non-proprietary platform with the addition of no-charge Microsoft-sponsored NNTP newsgroups on the Internet. Previously, Microsoft-sponsored electronic service forums were limited to users of CompuServe... |
| 21219 | The Microsoft Jet replication update, Jet40Repl.exe, is a Setup program that updates certain files that are used by Access and by Microsoft Replication Manager 4.0. These files were updated with the release of Microsoft Jet 4.0 Service Pack 7 (SP7).... |
| 21220 | When you try to use the Lookup Wizard for a data type of a field, you may receive the following error message: Microsoft Access is unable to start the Lookup Wizard. The Lookup Wizard doesn't apply to fields of this data type. |
| 21221 | When you rest the mouse pointer over a report name in the Database window, you receive the following error message: Microsoft Access can't open the file 'Path to file'. |
| 21222 | When you use Automation to create a new object in a Microsoft Access run-time application on a computer that does not have the full version of Access installed, you receive the following error message: Runtime error -2147023181 Automation error:... |
| 21223 | When you copy and paste a table in a Microsoft Access database (.mdb) or an Access project (.adp), the new table does not include permissions from the original table. |
| 21224 | The Microsoft Jet database engine runs in several different modes depending on whether it is called from Microsoft Access, Data Access Objects, the Microsoft OLE DB Provider for Microsoft Jet, or the Microsoft Access ODBC driver. It can be run in... |
| 21225 | With the Snapshot Viewer, you can view snapshots that are created with any version of Microsoft Access. The download consists of a stand-alone executable program (Snapview.exe), a Snapshot View control (Snapview.ocx), and related files. Note This... |
| 21226 | When you try to add a record to a datasheet that is produced by a query that has three or more tables, Microsoft Access will either stop responding (hang) briefly and will eventually quit without a warning or error, or you receive one of the following... |
| 21228 | Microsoft has made available a downloadable Help file that contains automation theory and multiple examples showing how to automate the Microsoft Office XP programs listed at the beginning of this article. |
| 21229 | A Btrieve ISAM is no longer available starting from Microsoft Access 2002. |
| 21230 | In Reduced Functionality mode, the Microsoft Office Activation Wizard is displayed. It lists Microsoft Access 2002 Runtime . This suggests that the Runtime version has to be activated. |
| 21231 | When you open a Microsoft Access 97 database file in Access 2002, you receive the following message repeatedly even if you have selected Open Database : You have selected a database created in a previous version of Microsoft Access. You can convert or... |
| 21232 | When you use the query design grid to modify a query in a Microsoft Access project (.adp) file, you eventually run out of system resources. Then, you may experience one or more of the following symptoms: Microsoft Windows returns the following error... |
| 21233 | You may have a need to copy an existing database from Microsoft SQL Server 2000 and to place the database on another computer that is running Microsoft SQL Server 2000 Desktop Engine. This article describes how to do so. The process involves... |
| 21234 | When you open a converted data access page that has a theme that is not installed and you try to view or change the theme of the page (by clicking Theme on the Format menu), you receive the following error message, and then Microsoft Access quits:... |
| 21235 | If you add code to one of the new events in Access 2002, and you then compile the database in Access 2000, when the code is run in Access 2002, you may receive the following error, and then Microsoft Access quits: Microsoft Access has encountered a... |
| 21236 | The Table Analyzer Wizard can help you create a relational database from a set of data. When you use the Table Analyzer Wizard, you do not have to know relational database design principles. This article explains how the Table Analyzer Wizard... |
| 21237 | Microsoft Access provides an automatic row fix-up feature that uses links between tables to update (fix up) records in queries and forms. You can use this feature to enter a single value, and then Microsoft Access automatically looks up and displays... |
| 21238 | When you try to edit code in a module, you may see the following message, even though you just saw the same message: You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later. |
| 21239 | Microsoft Access does not have a built-in DragDrop event for controls as does Visual Basic. This article describes how to create a DragDrop procedure that will run in response to a Microsoft Access control being dragged to another control. This... |
| 21240 | In a Microsoft Access project (.adp), you may be forced to save your changes to a subdatasheet of a table when you make modifications to the size of that subdatasheet. If you click No when the Save Changes dialog box appears, you are continuously... |
| 21241 | When you install a Microsoft Office XP service pack, update, or security patch on your computer, you may be prompted to insert your Office XP CD-ROM. This article discusses why Office XP service packs, updates, and security patches may require your... |
| 21242 | After you rename Vbe6.dll and then do one of the following you open a replicated database you open a database under Microsoft Visual Source Safe Control you open a database in which you are creating a data access page you experience an infinite loop... |
| 21243 | When you are saving a data access page or viewing it in Page View, you receive the following error message, and then Microsoft Access quits: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. When you... |
| 21244 | When you create a link to a text file from Microsoft Access and then move the text file to another folder, you may receive the following error message when you try to use the Linked Table Manager to refresh the link: The Microsoft Jet database engine... |
| 21245 | When you output a report from Microsoft Access to another file format, such as .rtf, .txt, .xls, or .html, an OLE object that you inserted into the report does not appear. |
| 21246 | When you try to convert an uncompiled, read-only database to Microsoft Access 2002, you may receive the following error message: Cannot update. Database or object is read-only. When you try to quit Access after you receive this error message, you may... |
| 21247 | When you try to activate an existing navigation button on the record navigation toolbar of a data access page, you receive the following error message, and then Access quit: Microsoft Access has encountered a problem and needs to close. We are sorry... |
| 21248 | Subreports and text box controls do not have a KeepTogether property to prevent the controls' data from printing across two or more pages. However, you can simulate the KeepTogether property behavior by creating artificial group sections and placing... |
| 21249 | When you compile or run code, you may receive the following error message: Compile Error: User-defined type not defined. |
| 21250 | When you apply a filter in a Microsoft Access project to display a subset of records, you may receive a result set that does not match the filter condition. |
| 21251 | When you use code that performs Delete and UpdateBatch methods based on the Forms collection, you receive the following error message: Microsoft Visual Basic Run-time error '91': Object variable or With block variable not set |
| 21252 | Microsoft Visual Basic for Applications (VBA) is based on the Microsoft Visual Basic development system. Microsoft Office products include VBA and use it to perform certain functions. You can use VBA to build customized programs that are based on an... |
| 21253 | When you try to edit a record in Microsoft Office Access that is being edited by another user, the record may not be shown as locked. Also, Access may stop responding for a significant period of time during the attempt to edit a record that is... |
| 21254 | With Microsoft Access Snapshot Viewer you can distribute a snapshot of a Microsoft Access database that permits you to view the snapshot without Access installed. For example, you may want to send a supplier an invoice that is generated by using an... |
| 21255 | In a Microsoft Access project (ADP), when you copy and paste or import a table that contains a primary key, no primary key is created on the resulting table. Therefore, the table is not updateable. |
| 21256 | If you try to update a Microsoft Access table by using an update query that reads data from a linked text file, the update may fail and you may receive the following error message: Updating data in a linked table is not supported by this ISAM. If you... |
| 21257 | When you try to update records in a view that is created from a linked server in an Access project, you receive the following status message: This recordset is not updateable. |
| 21258 | Unlike Microsoft Access version 2.0 and earlier, Access 2002 does not create a .ldb file when a database is opened exclusively. Because of this, you can no longer use the .ldb file to determine which user has a database open for exclusive use. |
| 21259 | When you import a module from an earlier version of Access to Access 2003, and the earlier version of the Access module includes a reference to a DLL (.dll) or to a type library (.tlb) that does not exist on your computer, you may receive the... |
| 21260 | When you try to set New database sort order in Access, you may notice that the database sort order appears as Macedonian instead of FYRO Macedonian . |
| 21261 | This article describes the Access 2002 (Japanese) issues that are fixed in the Access 2002 Post-Service Pack 2 hotfix package that is dated July 18, 2003. Issues That Are Fixed in the Hotfix Package The following issue is fixed in this hotfix package... |
| 21262 | When you create a nested query against linked SQL Server tables and the top level query contains an outer join, you receive the following error message when you try to run the query: ODBC--Call Failed. [Microsoft][ODBC SQL Server Driver][SQL Server]... |
| 21263 | When you use Data Transformation Services (DTS) to transfer data from a table that is based on Microsoft SQL Server to Microsoft Excel, DTS reports a successful execution of a package, but the data is not transferred. |
| 21264 | When you use keyboard actions to link an Open Database Connectivity (ODBC) table, Access 2002 may quit unexpectedly. You may receive the following error message: Microsoft Access has encountered a problem and needs to close. We are sorry for the... |
| 21265 | When you try to open a database that is located on a Novell NetWare server, you may receive the following error message: Couldn't use filename; file already in use. |
| 21266 | After you compact and repair a database that includes a table that has an AutoNumber field, you notice that when you enter new data, the AutoNumber is a duplicate of an earlier AutoNumber. |
| 21267 | SQL pass-through queries are used to send commands directly to an ODBC database server. By using an SQL pass-through query, you work directly with the server tables instead of having the Microsoft Jet database engine process the data. |
| 21268 | When you create a Memo field in a Microsoft Access database and create an index on that field (or you create a field name that includes text that is automatically indexed), you can enter only a specific amount of text. Once you reach this limit... |
| 21269 | This article describes why the User Authentication dialog box may appear in a non-secure database. This article also describes how you can troubleshoot this problem. |
| 21270 | When you try to link a table in a Microsoft Access project (.adp), you may receive the following error message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. |
| 21271 | Microsoft Access includes a Data Definition Language (DDL) that you can use to create and delete (drop) tables and relationships. You can also perform these same operations by using Data Access Objects (DAO) in Visual Basic for Applications. This... |
| 21272 | When you try to use the Filter By Form functionality, you may receive the following error message: Cannot apply Filter on one or more fields specified in the Filter property. |
| 21273 | When you try to link Open Database Connectivity (ODBC) tables to an Access database, Access may quit unexpectedly. You may receive the following error message: Microsoft Access has encountered a problem and needs to close. If you click Debug , you may... |
| 21274 | This article describes the Access 2002 issues that are fixed in the Access 2002 Post-Service Pack 2 hotfix package that is dated July 14, 2003. Issues That Are Fixed in the Hotfix Package The following issue is fixed in this hotfix package but was not... |
| 21275 | When you apply a sort to a table, a view, a stored procedure, or a function in a Microsoft Access project (.adp) file, you receive the following error message, and then Microsoft Access crashes. Microsoft Access has encountered a problem and needs to... |
| 21276 | This article shows you how to use a form to specify the criteria for a query. This technique is called query by form (QBF). |
| 21277 | This article demonstrates two methods that you can use to create a running totals query. A running totals query is a query in which the total for each record is a summation of that record and any previous records. This type of query is useful for... |
| 21278 | If a database has the Name AutoCorrect feature enabled, users may experience a delay when they try to open database objects. |
| 21279 | This article describes how to convert data values of Text data type to Proper Case format (Title case format). |
| 21280 | When you try to roll back a record, Microsoft Jet may commit the record instead. |
| 21281 | When you link a table from an ODBC data source, such as Microsoft SQL Server or ORACLE, and that table contains more than one unique index, Microsoft Access may select the wrong index as the primary key. |
| 21282 | When you try to open a Microsoft Access database file (.mdb) in Access 2003, you may receive the following error message, and Access 2003 may stop responding: Microsoft Office Access has encountered a problem and needs to close. Note To view the... |
| 21283 | Microsoft has released an update to Access 2002 Runtime. This update contains significant security enhancements, stability improvements, and performance improvements. The Access 2002 Runtime Update includes stability improvements that were developed... |
| 21284 | When you run the Mail Merge Wizard to merge the results of a SQL Server stored procedure or function with a Microsoft Word document, you receive the following error message in Microsoft Word: filename is locked for editing by 'another user'. When... |
| 21285 | When you click Open (on the File menu or on the Standard toolbar) in a Microsoft Office XP program, the Open dialog box may delay the display of files for approximately 2 to 5 minutes. Also, the processor (CPU) activity may indicate 100 percent... |
| 21286 | When you perform a Custom installation of Office, your previous version of Outlook is removed. This occurs even though you installed Office into a different folder from your previous Office version, and you selected Keep these programs . |
| 21287 | When you install Microsoft Office 2000, you may receive the following error message: Microsoft Development Environment Unexpected critical error: can't start program When you click OK , Office Setup is completed successfully. When you then use... |
| 21288 | During Microsoft Office Setup, you may receive the following error message: Internal Error 2343: Please contact product support for assistance. Microsoft has created a utility to resolve this error message. The utility does this by modifying or... |
| 21289 | After you install or remove Microsoft Outlook 2000 or Office 2000, Microsoft Windows Messaging is no longer stored in the same location. |
| 21290 | When you start a Microsoft Office 2000 program, a Windows Installer dialog box appears. After the Windows Installer finishes configuring Microsoft Office 2000, the User Name dialog box appears, prompting you for your name and your initials. |
| 21291 | The following is a list of the supported methods for installing Microsoft Office on a workstation: Run Setup from a Microsoft Office compact disc (CD). Run Setup from a set of Microsoft Office disks. Run Setup from a server on which an administrative... |
| 21292 | You are unable to import Microsoft Excel Spreadsheets and HTML files. When you use the Import Wizard to import a Microsoft Excel spreadsheet or a Hypertext Markup Language (HTML) file, you see a message in the status bar that says Import Spreadsheet... |
| 21293 | When you use the Oracle ODBC driver to export an Access table that has fields of data type Single or Double, the driver fails to export those fields as follows. The Microsoft Oracle driver displays the following error message: Microsoft Access was... |
| 21294 | You receive one of the following error messages when you try to connect to either the Microsoft Data Engine (MSDE) or Microsoft SQL Server 7 Desktop Edition on a computer running Microsoft Windows 98: Test Connection Failed because of an error... |
| 21295 | When you use Microsoft Access 2002 to link a Microsoft SQL Server 7.0 or a Microsoft SQL Server 2000 table that contains a UniqueIdentifier column as the primary key, #Deleted is displayed in every record of the linked table. |
| 21296 | The About MDE files Help Topic contains the following paragraph: If your database contains Microsoft Visual Basic for Applications (VBA) code, saving your Microsoft Access database as an MDE file compiles all modules, removes all editable source... |
| 21297 | When you import a Microsoft SQL Server 7.0 table from an Access project (.adp) into an Access project that is connected to Microsoft SQL Server 6.5, you receive the following error message, and then Microsoft Access quits: Microsoft Access has... |
| 21298 | This article shows you how to format and print a table from the Microsoft Access user interface. |
| 21299 | To optimize PivotTable List performance in Microsoft Access, use the following tips, which are explained in detail in the More Information section: Hide details in the PivotTable list. Use a query to restrict unnecessary fields and records.... |
| 21300 | When you try to create a data access page in Microsoft Access 2002, you may receive the following message: Content within this application coming from the Web site listed below is being blocked by Internet Explorer Enhanced Security Configuration.... |
| 21301 | When you view an Access project form that has a Server Filter applied to it in print preview, the form loses its connection to its record source and #Name is displayed in all of the data controls. |
| 21302 | In a subdatasheet, you can view and edit related or joined data in a table or a query, in a form datasheet, or in a subform. For example, in the Northwind sample database, the Suppliers table has a one-to-many relationship with the Products table;... |
| 21303 | You cannot install the Microsoft SQL Server 2000 Desktop Engine through the Microsoft Office XP Setup program. There is a separate Setup program that you use to install the SQL Server 2000 Desktop Engine. NOTE : The previous version of Microsoft SQL... |
| 21304 | When two users change the same record at the same time in a Microsoft Access project or in a Microsoft Access database connected to SQL Server, a write conflict message is not received if the data type of the field is Text or Image. |
| 21305 | This article shows you how to view and edit relationships in a Microsoft Access database. |
| 21306 | After you upgrade to Microsoft Windows NT 4.0 Service Pack 6/6a on a client computer without upgrading the server to the same service pack, opening Access objects such as forms, reports, macros, or modules in Design View across a network is unusually... |
| 21307 | Microsoft Access allows you to set the Recordset property of a report to an ActiveX Data Objects (ADO) recordset. However if you set the Recordset property twice in the OnOpen event of a report that uses an ADO recordset, you receive the following... |
| 21308 | When you try to export a report with the Publish It with Microsoft Word OfficeLinks command, you may receive the following message: The Save As command can't process any subforms contained in your report. Do you want to proceed anyway? If you... |
| 21309 | When you try to view an animation that describes new features in Microsoft Access, you experience the following symptoms in the Microsoft Access Help dialog box: You receive the following message: Your current security settings prohibit running... |
| 21310 | When you import a table into a Microsoft Access project (ADP) from another Access project, you may receive an error message similar to the following: [Microsoft][ODBC SQL server Driver][SQL Server] Line 5: Incorrect Syntax near 'COLLATE'. When you... |
| 21311 | Microsoft Access includes a tool called the Microsoft Script Editor that you can use to edit the script behind data access pages. There are four ways to open the Script Editor from Design view of a data access page. |
| 21312 | The ADOAcc02.exe file contains the Using ADO in Microsoft Access 2002 white paper, which discusses how to use ActiveX Data Objects (ADO) with forms and reports in Microsoft Access 2002. It also discusses the new Client Data Manager (CDM) in... |
| 21313 | According to Microsoft Knowledge Base article 275561 ACC2000: New Features in Microsoft Jet 4.0: To minimize the impact of the increased page size and respond to a long-standing request from developers building applications based on the Microsoft... |
| 21314 | When you run a stored procedure in Access project and that stored procedure creates and fetches a cursor, the stored procedure may fail. You may receive the following error messages: The data provider or other service returned an E_FAIL status.... |
| 21315 | When you click Edit in Microsoft Access for a database template in the Microsoft Office Template Gallery, and that database template requires Access 2000 or later, you may receive the following error message: Microsoft Access cannot be started. If you... |
| 21316 | When you use Microsoft Access Help, you cannot seem to find any information about built-in functions, properties, or methods of objects or collections. -or- When you use Microsoft Access Help, you find Help topics that seem to be related to Microsoft... |
| 21317 | When you copy and paste a table in a Microsoft Access database (.mdb) or an Access project (.adp), the new table does not include permissions from the original table. |
| 21318 | The Microsoft Access 2000 Security Manager enables the database-security administrator to make knowledgeable security decisions as the database and its workgroup evolve. By presenting all security settings in a single view, the administrator can set... |
| 21320 | With the Snapshot Viewer, you can view snapshots that are created with any version of Microsoft Access. The download consists of a stand-alone executable program (Snapview.exe), a Snapshot View control (Snapview.ocx), and related files. Note This... |
| 21321 | A Btrieve ISAM is no longer available starting from Microsoft Access 2002. |
| 21322 | When you convert a Microsoft Access project (.adp) from a Microsoft Access 2002 file format to a Microsoft Access 2000 file format, you may receive the following error, and then Microsoft Access quits: Microsoft Access has encountered a problem and... |
| 21323 | When you query a table that is linked to a Microsoft Excel spreadsheet, you may receive the following error message: Numeric field overflow. |
| 21324 | Microsoft has adopted a standardized naming schema for all hotfix (patch or update) packages for Office that are created and distributed by Microsoft. The new naming schema will go into effect for all hotfix packages in May, 2003. Note An Office... |
| 21325 | By modifying a report's section properties, you can design a report that breaks the page for each new entry in a group and resets the report's page number. For example, in Microsoft Access 2000, the Employee Sales by Country report in the sample... |
| 21326 | This article describes how to contact Microsoft for help with the following issues: Replace lost, broken, damaged or defective Microsoft software disks. Purchase product upgrades. Replace broken or defective Microsoft hardware products. Check the... |
| 21327 | This article describes how to programmatically create a column in an Access report. You can dynamically add the column to the report by using either Method 1 or Method 2 that are described in the More Information section. |
| 21328 | This step-by-step article describes how to reset an AutoNumber field value in Access. The AutoNumber field value in Access does not automatically reset when you delete some rows or all rows in a table. To reset the AutoNumber field value and to... |
| 21329 | When you open specific files that are in folders that have long folder names in Word 2002, PowerPoint 2002, Access 2002, Excel 2002, and Outlook 2002 , you receive one of the following error messages: Filename is not valid. -or- The file could not be... |
| 21330 | When you try to save an Access database file (.mdb) as an MDE file (.mde), or when you try to save an Access project file (.adp) as an ADE (.ade) file, Access may stop responding. You may receive the following error message: Microsoft Access has... |
| 21331 | When you close forms and reports in Microsoft Access Project, the memory may not be released, resulting in a memory leak. When the memory leak is large enough, the performance level may drop significantly, and your computer may stop responding (hang). |
| 21332 | When you use the Advanced Filter/Sort feature in a Microsoft Access table, the Filter toolbar disappears when the Advanced Filter/Sort window opens. |
| 21333 | When you preview a report created by saving a form as a report, you may receive the following error message: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. |
| 21334 | When you switch from Print Preview to Design view and then to Datasheet view, Microsoft Access may quit unexpectedly. This behavior occurs when either of the following conditions are true: You create a new table, open it in Print Preview before saving... |
| 21335 | When you try to add a control to a form, you receive the following error message: Microsoft Access can't add, rename, or delete the control(s) you requested. |
| 21336 | You cannot create or view a data access page that is bound to Microsoft SQL Server version 6.5. If you are designing your page through an Access project (.adp), you may also receive the following error messages when you try to view the page in... |
| 21337 | In Microsoft Access, you may receive the following error message when you run a SQL query: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. |
| 21338 | When you add a new record to a grouped data access page, the page unexpectedly closes. You receive no error message or warning message. The page simply disappears, and then either Microsoft Access or Microsoft Internet Explorer also quits, depending... |
| 21339 | When you sort a table while one of its columns is being renamed, Microsoft Access may quit and you receive the following error message: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. |
| 21340 | You can create Compressed HTML Help files (.chm) by using HTML Help Workshop included with Microsoft Office XP Developer. This article demonstrates how to create a simple HTML Help file in HTML Help Workshop, and then how to use the Help file in a... |
| 21341 | When you run Microsoft Access from the Start menu or a shortcut menu, you can use command-line switches to modify the startup process. For example, you can open a particular database, run a macro, or supply a password. |
| 21342 | When you need unlimited users, 24x7 support, and ACID transactions, Microsoft strongly recommends that you use Microsoft SQL Server with Internet Information Server (IIS). Although Active Server Pages (ASP) works with any OLE DB and ODBC-compliant... |
| 21343 | When you click the Exit button that runs the DoCmd.Close Microsoft Visual Basic for Applications (VBA) code, an Enter Parameter Value dialog box may appear. This occurs when you close a form window in Access that runs with the Windows XP operating... |
| 21344 | When you type text data into a Text or Memo field or control in Microsoft Access with the AutoCorrect Capitalize first letter of sentence feature enabled, you find that the first word in the field is not capitalized. |
| 21345 | When you add a breakpoint to a Visual Basic for Applications (VBA) procedure or function, the breakpoint is ignored and the code runs to completion without pausing, as you would expect. |
| 21346 | When you copy numbers from an Access 2002 database and paste them in Excel 2002, the data type of the pasted numbers is text. They data appears as numbers, but sorts as text and are not available for formulas and functions. |
| 21347 | After you convert a database that you created with the Database Wizard in an Access 97 or earlier version of Microsoft Access, you may receive the following error message when you click the Change Switchboard Items button on the Main Switchboard form:... |
| 21348 | When you save a form or a report as a data access page in a Microsoft Access project (ADP) file or a Microsoft Access database (MDB) file, you receive the following error message: Microsoft Access is unable to create the data access page. The file you... |
| 21349 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). For a Microsoft Access 2000 version of this article, see 198452. When you click a hyperlink, you may |
| 21350 | In Microsoft Access 2002 or Microsoft Access 2003, when you try to open or convert a secured Microsoft Access 97 or earlier database file, you may receive the following error message: The current user account doesn't have permission to convert or... |
| 21351 | Novice: Requires knowledge of the user interface on single-user computers. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). For a Microsoft Access 2000 version of this article, see 207684. When you type data into a new record on a |
| 21352 | Moderate: Requires basic macro, coding, and interoperability skills. For a Microsoft Access 2000 version of this article, see 202025. If a report or a form has its RecordSource property defined as a table, and if the table contains no records, #Error is displayed when you preview |
| 21353 | Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access database (.mdb). For a Microsoft Access 2000 version of this article, see 202269. When you use a combo box or a list box to |
| 21354 | Novice: Requires knowledge of the user interface on single-user computers. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). For a Microsoft Access 2000 version of this article, see 209653. This article shows you how to concatenate |
| 21355 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). For a Microsoft Access 2000 version of this article, see 208718. When you reference a subreport control from a main |
| 21356 | Novice: Requires knowledge of the user interface on single-user computers. For a Microsoft Access 2000 version of this article, see 208855. This article shows you how to shuffle the records in a table in random order. It also shows you how to get records from a table at random (where |
| 21357 | Novice: Requires knowledge of the user interface on single-user computers. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). After you click to clear the Display Database Window check box in the Startup dialog box on the Tools menu, |
| 21358 | Novice: Requires knowledge of the user interface on single-user computers. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). When you set the BorderStyle property of a list box on a report to Transparent, parts of the list box border |
| 21359 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). For a Microsoft Access 2000 version of this article, see 253911. This article provides examples for using a built-in function |
| 21360 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). For a Microsoft Access 2000 version of this article, see 231808. This article describes how to repeat a subreport's |
| 21361 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). The Nz method of the data source control is suppose to replace Null values with a zero (0) or some other specified |
| 21362 | This article demonstrates how you can create a report that ranks a specific number of records for each group in order according to a top value, for example, the top five selling products per category. |
| 21363 | Advanced: Requires expert coding, interoperability, and multiuser skills. This article applies only to a Microsoft Access project (.adp). For a Microsoft Access 2000 version of this article, see 225939. When you try to examine properties of the ADOX Views collection with an Access |
| 21364 | You can use Microsoft Access 2002 to create dynamic reports that are based on parameter crosstab queries. You can also create reports to match a dynaset that is returned by such a query. Dynamic reports allow your customized reports to show only the... |
| 21365 | After you install the Microsoft Office XP Service Pack 2, you notice that descending indexes in Access 2002 that have been upsized to SQL Server are still upsized as ascending indexes. |
| 21366 | This article contains links to other articles about issues that you may experience when you upsize a database in Microsoft Access. |
| 21367 | After you install Microsoft Internet Explorer 6.0 Service Pack 1 (SP1) or Microsoft Windows XP Service Pack 1 (SP1), some data access pages do not display data when the page is opened in Page view in Microsoft Access. When you open a data access page... |
| 21368 | This article describes how to upsize a Microsoft Access database to the Microsoft SQL Server or to the Microsoft Data Engine (MSDE) by using the Access 2002 Upsizing Wizard. This article introduces the Upsizing Wizard, what to check before you upsize,... |
| 21369 | By default, a new Microsoft Access 2000 database does not reference the Microsoft DAO 3.6 Object Library. This is a change from earlier versions of Access. If you run Visual Basic for Applications code that uses the Data Access Object (DAO) library in... |
| 21370 | In the Help system for the Microsoft Script Editor, the Connection property of the DSCEventInfo object is described as a property that returns an ADO connection object. However, a variable set equal to this Connection property does not produce a... |
| 21371 | Access disables the Send To Mail Recipient command although all requirements to send are met and other Microsoft Office products have the same command enabled. To use Send To Mail Recipient , the following requirements must be met: You must have an... |
| 21372 | When you edit a record in a form that is bound to an ActiveX Data Objects (ADO) recordset, you receive the following error message: This recordset is not updateable. When you close the form, you receive the following error message multiple times: You... |
| 21373 | When you open a form that is bound to an ActiveX Data Objects (ADO) recordset, you receive the following error message, and then Microsoft Access quits: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.... |
| 21374 | The Microsoft Office XP client updates and patches that were published after September 2002 may require the Windows Installer service 2.0. This article provides more information about this requirement. |
| 21375 | When you install Office, you do not have a choice to install the Compatibility mode of Microsoft Internet Explorer version 5. |
| 21376 | 3/25/1999 3/25/1999 10/2/2002 10/2/2002 KB KB _IKkbZNotKeyword4 kbOffice2000 kbOffice2000Search kbOffice2000SetupSearch kbOfficeSearch kbZNotKeyword5 kbZNotKeyword6 _IKkbZNotKeyword4 kbOffice2000 kbOffice2000Search kbOffice2000SetupSearch kbOfficeSearch kbZNotKeyword5 kbZNotKeyword6 224096 224096 |
| 21377 | The products that are listed at the beginning of this article contain code that is specifically designed to run only on computers with an Intel i386- family microprocessor. Computers with other types of microprocessors may emulate the Intel command... |
| 21378 | To troubleshoot activation or licensing issues, you may have to force the re-entry of your Office XP product identification code. This article describes how to force your computer to prompt you for your Office XP product identification code. NOTE :... |
| 21379 | When you use Microsoft Data Access Objects version 3.0 (DAO 3.0) with the products listed at the beginning of this article, you may receive the following error message: Run-time error '429': ActiveX component can't create object. |
| 21380 | When you have multiple documents open in any of the Office XP programs listing at the beginning of this article, only one icon for the program appears on the taskbar, even though the Windows in Taskbar option is selected (on the Tools menu, click... |
| 21381 | Data access pages enable you to create data bound Web pages that can be viewed in Microsoft Internet Explorer 5 or later. These Web pages are typically intended for Intranet use; however, with special considerations, they can be deployed successfully... |
| 21382 | If you have versions of Microsoft Access that are earlier than Access 2002 on the same computer on which you install Microsoft Access 2002, when you create a new database in Access 2002, you may see templates that are used for creating databases in... |
| 21383 | When you use one of the Microsoft Office XP programs that is listed at the beginning of this article, you may receive an error message that is similar to the following: Microsoft program has encountered a problem and needs to close. We are sorry for... |
| 21384 | When you try to connect to a Microsoft SQL Server database from a Microsoft Access project (ADP), you may receive the following error: Microsoft Access could not find the database on the server. Verify that the database name is correct. If you click... |
| 21385 | If a table has more than 16,384 rows, and you click the OfficeLinks button, and then Analyze It with Microsoft Excel , you may receive the following error message: There are too many rows to output, based on the limitation specified by the output... |
| 21387 | When you attempt to install Microsoft Office XP, you receive the following error message: Microsoft Office XP Standard cannot be installed on this computer. This product requires Microsoft Windows 98, Microsoft Windows Millennium, Microsoft NT v4.0... |
| 21388 | When you remove (uninstall) Microsoft Office 2000, Internet Explorer 5 is not removed. |
| 21389 | When you try to export a table by using the Microsoft Visual FoxPro ODBC driver, you may receive the following error message: ODBC Call failed [Microsoft][ODBC Visual FoxPro Driver (#712) NOTE : You may also receive the following error message ODBC... |
| 21391 | Microsoft Office XP Professional with FrontPage, Microsoft Office XP Professional, and the stand-alone version of Microsoft Access 2002 have a Calendar ActiveX control that you can use in Microsoft Office applications. However, you are not licensed to... |
| 21392 | Microsoft supplies several primary interop assemblies (PIAs) that contain the official description of the most commonly used Microsoft Office XP type libraries. These Microsoft Office XP PIAs make interoperability easier between managed code and... |
| 21393 | When you add a new record to a subform in a Microsoft Access project (ADP), you receive the following error message: The data was added to the database but the data won't be displayed in the form because it doesn't satisfy the criteria in the... |
| 21394 | When you try to save a Microsoft Access database as an MDE file, you may receive the following error message: Can't open any more tables. When you click OK , you receive the message: Out of memory. When you click OK again, you receive the message... |
| 21395 | This article describes the new features of Microsoft Jet 4.0, and compares some of the changes between the prior version of Microsoft Jet (version 3.5) and Jet 4.0. |
| 21396 | SYMPTOMS After you select a country or region in the Customer Information dialog box of the Microsoft Office XP Activation Wizard, you may receive the following error message Microsoft program has encountered a problem and needs to close. We are |
| 21397 | When you use one of the Microsoft Office XP products that are listed at the beginning of this article, you may receive the following error message: Microsoft Office program has encountered a problem and needs to close. We are sorry for the... |
| 21399 | When you try to edit a field in an ADO recordset by using the Microsoft Access and the Microsoft Jet OLE DB providers, you receive the following error: Run-time error '3251': Current Recordset does not support updating. This may be a limitation of the... |
| 21400 | Certain fonts in the Font Name combo box of the Label Report Wizard in Microsoft Access may not display correctly. This occurs on a computer that is running an English version operating system with the Microsoft Office XP Multilingual User Interface... |
| 21401 | SUMMARY This article shows you how to convert a replicated database back to a regular database. |
| 21402 | SUMMARY This article demonstrates four methods that you can use to simulate a subform or a subreport on a data access page. There is no subpage control in the toolbox in Design view of a page. Therefore, these methods demonstrate how to imitate this |
| 21403 | SYMPTOMS When you create a query that contains two or more tables in a Microsoft Access project (.adp), you receive the following error message when you try to save the query: ADO error: Column names in each view or function must be unique. Column |
| 21404 | SYMPTOMS If you select all fields from a table or query in the Combo Box wizard, click Back, and then click Next, you receive the following error message: No valid fields can be found in ' ObjectName'. Please select a new source. No valid |
| 21405 | Microsoft does not recommend or support Automation to a Microsoft Office application from an unattended user account. on why Microsoft does not recommend automation under this context 257757 INFO: Considerations for Server-Side Automation of Office... |
| 21406 | Microsoft does not recommend or support Automation to a Microsoft Office application from an unattended user account. on why Microsoft does not recommend automation under this context 257757 INFO: Considerations for Server-Side Automation of Office... |
| 21407 | SYMPTOMS When you try to run a query, a form, or a report, the Enter Parameter Value dialog box may appear unexpectedly. |
| 21408 | After you turn on (enable) Terminal Services in Microsoft Windows 2000 Server or Microsoft Windows 2000 Advanced Server, you may be unable to use any Microsoft Office programs. When you attempt to install any new component or use a component for the... |
| 21409 | If the Windows Installer needs to copy information from your Office source location, and that source is not available, a dialog box with the following text appears: The feature you are trying to use is on a network resource that is unavailable. Click... |
| 21410 | When you run Microsoft Office 2000 Setup, you may receive the following message: Microsoft Office 2000 has been advertised on your computer by the system administrator. To install Microsoft Office 2000, run Setup with the /q or /qb command-line... |
| 21411 | This article demonstrates how to convert an Access database to the Access 97, 2000 and 2002 file formats while you are in Access 2002.Introduction To make design changes to a database, it must be in the Access 2000 or 2002 file format. This article... |
| 21412 | After you install Microsoft Office XP, you cannot start an Office program. When you try to start an Office program, the Windows Installer starts, then stops, and then you receive the following error message: Internal Error 2744. |
| 21413 | Session Summary In this Support WebCast session, you will learn how to set up, configure, write queries for, and troubleshoot various linked servers with Microsoft SQL Server. You will hear about the architecture of linked servers, and how to... |
| 21414 | You can run Visual Basic for Applications (VBA) code based on the tabs that are selected in a tab control. To make sure that a particular block of code runs when you click a particular tab, use a SELECT CASE statement with the Change event of the tab... |
| 21415 | By using the RunningSum property on a report, you can display a line number for each record. This article shows you how to use script and DataSourceControl events to do the same thing on a data access page. |
| 21416 | This article shows you how to programmatically change the connection of a Microsoft Access project (ADP) file. |
| 21417 | This article explains how Microsoft Access stores the Date/Time data type, and why you may receive unexpected results when you calculate or compare dates and times. This article addresses the following topics: Storing Date/Time Data Formatting a |
| 21418 | This article shows you how to create a sample Visual Basic for Applications function that you can use to recover a table deleted from a Microsoft Access database under the following conditions: The database has not been closed since the table was |
| 21419 | In Microsoft Access, you can add a field to a table to look up information in another table. You typically use this technique when you want to create relationships between tables. For example, perhaps you have a Products table with a Category field... |
| 21420 | This article shows you how to edit records in related tables. It includes the following topics: How to Add or Edit Data in a Datasheet (Table or Query) or in a Form How to Save a Record in a Datasheet or in a Form How to Delete a Record in a Datasheet... |
| 21421 | This article demonstrates a method that you can use to hide the drop-down arrow on a combo box until the combo box is selected. Steps to Hide the Drop-Down Arrow on a Combo Box To hide the drop-down arrow on a combo box when the combo box is not... |
| 21422 | When you try to install or remove Office XP SP-1, you may receive an error message similar to the following: Error 1612. The installation source for this product is not available. Verify that the source exists and that you can access it. |
| 21423 | When you are working with data in an Access database, you may not want to view all of the data at once. Instead, you may want to view only those records that meet a certain criteria. To do so, you must apply a filter. This article shows you |
| 21424 | When you are working with data in Access, you may want to view your information sorted in a different fashion than it currently appears. This article shows you how to sort records in a table, a query, a form, or a report in an Access datab |
| 21425 | During this Support WebCast, you will learn about the various ways that you can deploy Microsoft Office XP Service Pack 2 (SP2) in an enterprise computing environment. You will find out how to use Ohotfix.exe to chain client-side patch depl |
| 21426 | This article provides an overview of how you can secure a database so that it is not changed or copied by other Microsoft Access users. This article assumes that you have a thorough understanding of the pieces that make up the Microsoft Access... |
| 21427 | A database object is a table, a query, a form, a report, a macro, or a module. When you try to delete an object, you receive a message similar to the following Do you want to delete the ''? where refers to the type of database object, and |
| 21428 | When you try to install Microsoft Office XP or an Office XP program, you may receive an error message similar to the following: |
| 21429 | This article discusses how you can optimize query performance in Microsoft Access 2000. The topics include the Microsoft Jet database engine's query Optimizer, query timing, analyzing performance, and design tips for improving query performance. |
| 21430 | You can use the tab control to display linked subforms. A form contains linked subforms when the second subform displays only the records related to the record that you select in the first subform. The Customer Orders form in the sample dat |
| 21431 | This article first describes lightweight objects and shows you how to make an object lightweight. It then shows you how to create a lightweight switchboard form that uses the |
| 21432 | This article shows you how to use the ActiveX Data Objects Extensions for DDL and Security (ADOX) in Visual Basic for Applications code to read the relationships from an external Microsoft Access database and to import those relationships t |
| 21434 | In Microsoft Access 2002, you can view tables, queries, views, functions, and forms in PivotTable view. This is possible because Access 2002 natively hosts the Microsoft Office Web Components. This article shows you how to use the Office Web... |
| 21435 | This article shows you how to programmatically implement a RecordExit event in a form in Access 2002. |
| 21436 | By using the |
| 21437 | Unlike with a form, you cannot use the |
| 21438 | Microsoft Access has no built-in method for disabling the |
| 21439 | The |
| 21440 | In Microsoft Access reports, page numbering always starts with the number 1. However, you may want your report to have page numbering that starts with some number other than 1. This article describes two methods for defining custom starting |
| 21441 | This article shows you how to use the |
| 21442 | Before you print a form or a report, you can save space by conditionally reducing the size of the controls on the form or report. For example, you might want to reduce the size of text boxes that contain varied-length text, or reduce the si |
| 21443 | When a control on a data access page is bound to a field in a table that has a valid input mask, the data access page ignores the input mask. In the data access page, you can enter and save values that do not conform to the input mask that is... |
| 21444 | When you view a data access page in Access 2002, one of the following may occur. When you view the page in Access, you may receive the following error: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.... |
| 21445 | When you programmatically set the |
| 21446 | On a data access page, when you set the control source of a text box or a Bound SPAN to an expression that references the HTML document object, Microsoft Access may stop responding, or you may receive the following error message, and then Microsoft... |
| 21447 | When you try to upsize a Microsoft Access database (.mdb) to Microsoft SQL Server, the Upsizing Wizard fails to export data for large tables. |
| 21448 | If your computer's Regional Options (or Regional Settings) |
| 21449 | When you open a form that contains a subform that is based on a linked Microsoft SQL Server table, the subform does not display any records. |
| 21450 | When you want to bind a data access page to another data source or to the same data source that has been moved to a new location, one way to do this is to update the |
| 21451 | When you output a report to Microsoft Excel, any Memo field is truncated to 255 characters. You may also see this behavior when you click the Analyze It with Microsoft Excel command while you are previewing a report. |
| 21452 | Microsoft Access addresses linked data differently than it does its own native data. This article discusses how Access retrieves linked ODBC data. |
| 21453 | This article describes a method that you can use to collate and print two reports. This method alternates two reports between the |
| 21454 | If you do not want to see the Convert/Open Database dialog box when you open an Access 97 database in Access 2002, you can suppress the dialog box by adding a registry entry that is named NoConvertDialog to the Access Settings subkey. This setting... |
| 21455 | When you use the Export Text Wizard to import, export, or link a text file, you may receive the following error message: |
| 21456 | When you save a table after you add a new field or change the properties of an existing field, you receive the following error message: |
| 21457 | If you convert an Access database that was created in an earlier version of Access that is also not the same language version, you may see unexpected characters, including extended characters, in the converted database. |
| 21458 | If your Access project (.adp) uses Microsoft SQL Server as the database engine, you can link data from other programs and other file formats, such as Microsoft Excel, dBase, Paradox, or XML (import only). You can also import or link a Microsoft Access... |
| 21459 | When you convert to Microsoft Access 2002 an Access 2.0, an Access 95, or an Access 97 database that contains characters specific to a foreign language, unexpected characters appear in the converted database. |
| 21460 | This article describes how to remove recently used templates from the |
| 21461 | If you move a database file that was created in an earlier version of Microsoft Access, for example, in Microsoft Access 97, from one computer to another computer, and you then try to open the database on the other computer, you receive the following... |
| 21462 | When you convert a database from an earlier version of Microsoft Access, you may receive the following error message: |
| 21463 | You can improve the performance of Microsoft Access if you periodically defragment your hard disk and compact your database. |
| 21465 | Session Summary This session will present an overview of how to use the basic feature set of the PivotTable and PivotChart features in Microsoft Access 2002. Microsoft Access 2002 introduces PivotTable and PivotChart views to tables, queries, views,... |
| 21466 | Session Summary In this session, we will discuss common combo box usage in a Microsoft Access database. This session will cover what combo boxes are, how they are created, and the distinct properties of a combo box. It will also introduce various... |
| 21467 | When you click a hyperlink to a Microsoft Office document in your Web browser or you double-click an Office document that is attached to an e-mail message in Microsoft Outlook or Microsoft Outlook Express, you are prompted to confirm whether you want... |
| 21468 | When you try to merge data from a Microsoft Access query with Microsoft Word, Microsoft Word displays one of the following error messages: Word could not merge the main document with the data source because the data records were empty or no data... |
| 21469 | If you programmatically open a form in Filter-by-Form view in a Microsoft Access 2002 run-time application, you may receive the following error message: Execution of this application has stopped due to a run-time error. The application can't |
| 21470 | This article shows you how to create a PivotChart view that displays data based on values that you select from combo boxes. |
| 21471 | When you use the Switchboard Manager to try to create a new Switchboard or when you open an existing Switchboard in a Microsoft Access database, you receive the following error message: Run-time error '429': ActiveX component can't create |
| 21472 | This article shows you how to create a PivotChart view that displays detail data instead of summarized data. By default, when you drag fields to the data fields area, the PivotChart view of an object displays summarized data. Sometimes, however, you |
| 21473 | This article shows you how to modify query properties in Microsoft Access. This information is useful if you want to perform such tasks as: Change the display of fields. Create top value queries. Add an alias for a table. Change field captions and... |
| 21474 | This article describes how to define relationships in a Microsoft Access database. It includes the following topics: What Are Table Relationships Types of Table Relationships One-To-Many Relationships Many-To-Many Relationships One-To-One... |
| 21475 | In a Microsoft Access crosstab query, you can specify only one field or calculation as the value. You may want to show more than one value in the query. The following example shows two columns of information per company, a count of the |
| 21476 | In a Microsoft Access project (ADP), when you try to link to a particular data source when you are using an Open Database Connectivity (ODBC) File Data Source Name (File DSN) connection, you receive the following error message: This data source... |
| 21477 | If you use the Upsizing Wizard to upsize the tables in a Microsoft Access database in which any table or query name contains an apostrophe ('), none of the tables are upsized. |
| 21478 | By using Jet 4.0, a user is able to call unsafe Visual Basic for Applications functions in query statements from Microsoft Access. For example, the following statement would result in all files being deleted from a computer's current folder: SELECT... |
| 21479 | When you try to preview or print a report in Microsoft Access, you receive the following error message: Microsoft Access cannot communicate with the printer. You may receive this error for one of the following reasons: Before beginning this procedure,... |
| 21480 | When you make a design change to a table and then try to save the table, you may get an error message that starts with the following sentence: Errors were encountered during the save operation. Errors were encountered during the save |
| 21481 | The Access 2002 Upsizing Tools white paper (Upsize02.doc) describes how to use the Upsizing Tools included in Access 2002. Use the document as an aid in preparing to migrate the data in an Access 2002 database to SQL Server, creating a client/server |
| 21482 | When you try to run an upsized append query in a Microsoft Access project, you may receive the following error message: Cannot insert explicit value for identity column in table ' table name ' when IDENTITY_INSERT is set to OFF. Cannot insert |
| 21483 | When you use a LIKE clause on a column in a query, and the column has Double-Byte Character Set (DBCS) characters, not all the records that meet the criteria are returned. |
| 21484 | When you try to convert an Access 97 database to Access 2002, you may receive the following error message An error occurred while loading Form_FormName. Do you want to continue. An error occurred while loading Form_FormName. followed by a |
| 21485 | This article shows you how to create a parameter query to search for all the records in a table that begin with, or that contain, a certain letter. |
| 21486 | This article shows you how to create two functions that you can use to calculate the age of a person or thing based on a specified date. |
| 21487 | Sometimes, it is not practical to store images in a Microsoft Access table. If you have many images, or if each of your image files is large, the size of the Microsoft Access database file can quickly increase. This article demonstrates a custom... |
| 21488 | The Microsoft Visual Basic for Applications Str() function returns the string representation of a numeric value represented as (n). Positive numbers and zeros are converted to a string with a leading space character. This article discusses methods... |
| 21489 | After you programmatically change properties of the Application.Printer object, forms and reports that use the default printer do not automatically inherit these settings. |
| 21490 | This article provides an overview and sample code for importing Outlook contact information into an Access table. The sample code in the More Information section of this article should be run from an Access global module. The code provides a... |
| 21491 | This article provides an overview and sample code for creating Microsoft Outlook contacts from information stored in a Microsoft Access database. The sample code in the More Information section of this article should be run from a Microsoft Access... |
| 21492 | This article shows you how to create a sample Visual Basic for Applications function that populates (or fills) controls on a report that is based on a table or a query when you preview or print the report. The sample function fills a newly created |
| 21493 | This article shows you four methods of moving to a specific record based on selection from a combo box. The methods are as follows: In the AfterUpdate event of a combo box, execute code that uses the FindFirst method. In the |
| 21494 | This article shows you how to use the Seek method with an ActiveX Data Objects (ADO) recordset. |
| 21495 | When you change the view of a form several times in succession, from Form view to Datasheet view to PivotTable view and then back to Form view, one of the following behaviors may occur: Microsoft Access shuts down unexpectedly without |
| 21496 | When you use the w Weekday option to calculate the number of weekdays between two dates, the DateDiff() function returns the number of weeks, not the number of work days as described in Access help. The w option is supposed to work the same |
| 21497 | This article shows you how to shade every other detail line on a Microsoft Access report. |
| 21498 | When you delete the last record or records in a table or in a form that has an AutoNumber field, and you then compact the database, the AutoNumber field does not start at the next higher number when you add new records. |
| 21499 | You cannot create a system DSN by using the RegisterDatabase method. To create a system DSN, use the ODBC API call for SQLConfigDataSource . Microsoft provides programming examples for illustration only, without warranty either expressed or implied,... |
| 21500 | When you try to set the Index property of an ActiveX Data Objects (ADO) recordset that is based on a table in a Microsoft Jet database, you may receive the following error message: Run-time error '3251': Current provider does not support the necessary... |
| 21501 | When you are using ActiveX Data Objects (ADO), if you use the AddNew or Delete method of the Recordset object, and you open the recordset with an unspecified lock type, you may receive one of the following error messages: Run-time |
| 21502 | This article shows you how to synchronize two combo boxes so that when you select an item in the first combo box, the selection limits the choices in the second combo box. |
| 21503 | A Microsoft Access database has begun to bloat (or grow rapidly in size) after you implement Data Access Objects (DAO) to open a recordset. |
| 21504 | When you run a procedure or a function, you may receive one of the following error messages: Compile error: Expected variable or procedure, not module. Compile error: Expected variable or procedure, not module. -Or- |
| 21505 | When you try to execute the Microsoft SQL Server stored procedure sp_setapprole from a Microsoft Access project (ADP), you receive the following error message: Application roles can only be activated at the ad hoc level. |
| 21506 | When you view an object in PivotTable or in PivotChart view, the data in a decimal field is truncated after the decimal point. |
| 21507 | This article lists supported providers for data access page connection strings. |
| 21508 | When you type data into a parameter prompt for a Memo field, you are limited to 255 characters. |
| 21509 | This article describes how to completely remove Microsoft Office 2000 CD2 from a computer that is running Microsoft Windows 2000. This article includes files installed from CD2 and does not apply to other CDs included with your edition of M |
| 21510 | This article describes how to completely remove Microsoft Office 2000 CD2 from your computer. This article includes files installed from CD2 and does not apply to other discs included with your edition of Microsoft Office 2000. |
| 21511 | You may not be able to save your logon ID and password locally when you link a table from an Open Database Connectivity (ODBC) data source because the |
| 21512 | When you attempt to install Office, you may receive the following error message: |
| 21513 | This article lists some of the most common specifications for Microsoft Access. |
| 21514 | If you are familiar with ODBC tables and Microsoft Access databases, you know that an ODBC table is not literally stored in an Access database. Instead, the Access database contains a link that points to the actual location of the back-end |
| 21515 | When you open a table or view in a Microsoft Access project (.adp) file, the following error occurs: |
| 21516 | This article explains how to use the Common Dialog API to replace the Common Dialog Box functionality that is included only with the Office 97 Developer Edition. |
| 21517 | This article shows you two methods of using the NotInList event to add a new record to a combo box on a form. |
| 21518 | When you open a database, a prompt appears for a database password, even though you may not have set a database password for the database. |
| 21519 | When Microsoft Access attempts open a report, it will automatically switch to Design view if an existing Print Preview view of the same report is not first closed. The report will switch views both in MDB and MDE files. |
| 21520 | When you try to install Office 2000, an error message similar to the following appears: |
| 21521 | When you try to preview or to print a report in Microsoft Access, you receive the following error message: Microsoft Access cannot communicate with the printer. You receive this error for one of the following reasons: Before you start this procedure,... |
| 21522 | When inserting records into a Microsoft Access database, immediately attempting to reselect them occasionally does not return all inserted records. This occurs even when the records are inserted and reselected on the same connection. The problem... |
| 21523 | When you try to use the Lookup Wizard for a data type of a field, you may receive the following error message: Microsoft Access is unable to start the Lookup Wizard. The Lookup Wizard doesn't apply to fields of this data type. |
| 21524 | If you try to type text in a memo field, you may receive the following error message: |
| 21525 | When you try to import dBASE files into Access, you may receive the following error message: |
| 21526 | When you start your computer after you install Microsoft Access 2002, you may receive the following error message: |
| 21527 | By using crosstab queries, you can create summary views of your data for easier analysis. This article shows you how to create a crosstab query in Microsoft Access with and without using a wizard. CAUTION : If you follow the steps in this example, you... |
| 21528 | You can use criteria in a query in Microsoft Access to restrict the set of records that the query returns. To query for different records each time that you run a particular query, you may want the query to prompt you for criteria to enter, for... |
| 21529 | Action queries are used when you want to perform tasks such as inserting, updating, or deleting records. You can convert an existing select query to an action query by changing its query type. This article describes the different types of |
| 21530 | This article shows you how to programmatically change the chart type of a Microsoft Access form in PivotChart view. |
| 21531 | In Microsoft Access, you can create a query to retrieve information from a table or from multiple tables. You can then use the query as the basis of a form, a report, or a data access page. This article shows you how to create simple queries in... |
| 21532 | You can use the |
| 21533 | By carrying out the |
| 21534 | This article shows you how to create a macro and a Visual Basic procedure to fax a report from Microsoft Access. The examples assume that you have Microsoft Outlook, Microsoft Fax, and a fax modem installed and that they are functioning. |
| 21535 | This article describes how to print multiple copies of the same mailing label, and how to use a partially used page where only some of the labels are available. |
| 21536 | This article shows you how to use an SQL pass-through query for a form's record source. It assumes that you know how to build and use SQL pass-through queries. |
| 21537 | This article describes the |
| 21538 | When you double-click a shortcut that points to a Microsoft Access 2002 database object, the Windows Installer starts, and you receive the following error message: |
| 21539 | Using Access Client/Server, you can create temporary tables in both SQL Server and Microsoft SQL Server 2000 Desktop Engine. Even though you cannot see the tables in the Tables pane of the Database window, the temporary tables are available |
| 21540 | This article shows you how to create a Visual Basic for Applications function to determine if a date falls on a weekend or holiday. This example is useful for setting due dates in applications that have billing or invoicing features. |
| 21541 | If your regional settings are configured to use a comma as the decimal separator (for example, in the German regional settings), filtering by selection on a Decimal field may generate the following error message when you link to an Open Database... |
| 21542 | The Microsoft Jet replication update, Jet40Repl.exe, is a Setup program that updates certain files that are used by Access and by Microsoft Replication Manager 4.0. These files were updated with the release of Microsoft Jet 4.0 Service Pack 7 (SP7).... |
| 21543 | When a Microsoft Office application loads a Component Object Model (COM) add-in or a smart tag recognizer add-in that is created with Visual Studio .NET, you may experience one of the following problems: When the add-in is loaded in an Office... |
| 21544 | The Microsoft Jet database engine runs in several different modes depending on whether it is called from Microsoft Access, Data Access Objects, the Microsoft OLE DB Provider for Microsoft Jet, or the Microsoft Access ODBC driver. It can be run in... |
| 21545 | When users in a multiuser environment try to open a Microsoft Access project (.adp) file or a Microsoft Access project extension (.ade) file, they may receive an error message similar to the following: The database DatabaseName will be opened... |
| 21546 | This article shows you how to create a combination chart. A combination chart is a chart on which different series have a different chart type. For example, one series might be a bar chart. Another series might be a line chart. You can create a |
| 21547 | This article explains how to populate several text boxes with the selections made in a multicolumn combo box, and then save the contents of the text boxes as one record in a table. |
| 21548 | Table names in Microsoft Access project may be displayed incorrectly. They may be inside quotation marks or may appear broken, with their parts transposed and inside parenthesis. For example, the table name Categories may be displayed in ways similar... |
| 21549 | After you install Office 2000 or Office XP, the Activation Wizard appears each time that you start an Office program. |
| 21550 | This article includes sample code that illustrates how you can programmatically determine the installation path for a Microsoft Office application given the ProgID for that application. |
| 21551 | When a modal form is displayed from an ActiveX EXE component called from VBA, the Office application that made the call does not repaint correctly while the dialog is displayed. |
| 21552 | When you use the New operator or CreateObject function in Microsoft Visual Basic to create an instance of a Microsoft Office application, you may get the following error message: Run-time error '429': ActiveX component can't create object |
| 21553 | This article describes how to create application-specific add-ins for Access. In Access, there are two different types of add-ins: application-specific add-ins and Component Object Model (COM) add-ins. An application-specific add-in works in only one |
| 21554 | When you delete a record on a data access page, a combo box that is used to find records on the page is not refreshed to reflect the deletion. |
| 21555 | When you run a query that includes a Memo, an OLE, or a Hyperlink field on a computer that is running Microsoft Jet 4.0 Service Pack 5 (SP5), you receive the following error message: Run-time error '3114': Cannot include Memo, OLE or Hyperlink Object... |
| 21556 | This step-by-step article shows you how to programmatically change a DSN that is using a trusted connection. You may want to use this technique because, if you use a DSN with a trusted connection to connect to SQL server, you cannot manuall |
| 21557 | This article describes how to troubleshoot a custom-created smart tag that does not work as you expect. Smart tag technology gives Microsoft Office programs the ability to recognize data that you enter. Office then offers on-the-spot access to actions... |
| 21558 | This step-by-step article describes how to use the Microsoft Office Application Recovery tool. This tool provides you with a way to potentially recover data from an Office program that stops responding (hangs). If an Office program stops responding... |
| 21559 | Microsoft Office products may change from one release to the next. Typically, the type library for an Office product will have the same functions that were present in the earlier product version, but some functions may have additions to the number of... |
| 21560 | After you run Visual Basic for Applications code to create a linked table from a text file, you notice #Num! in one or more records. |
| 21561 | In a replicated database, you notice that queries in which you designed PivotChart or PivotTable lists, the PivotChart or PivotTable list has been reset to blank. It does not matter whether the replica is a new one created from the Design Master or |
| 21562 | When you preview or print an object in PivotTable view, you receive the following message: Previewing or printing this PivotTable view might take a long time because it displays a large amount of detail data. Microsoft Access might not respond for |
| 21563 | After you have synchronized one member of a replica set with another, some of the data in the two databases may not match as expected. |
| 21564 | When you use calculated columns that contain data of the Variant data type, you receive the following error message: Microsoft Visual Basic Run-time error '-2147217891 (80040e1d)': Requested conversion is not |
| 21565 | After you have opened a Microsoft Access 97 database in Microsoft Access 2002 and converted it to the current file format, Label reports do not display some data correctly. Data from fields named Name , which were presented correctly in the Access 97... |
| 21566 | In Microsoft Access, when you attempt to run a union query, you may receive an error message similar to the following: The ORDER BY expression ( MyFieldName ) includes fields that are not selected by the query. Only those fields requested in the first... |
| 21567 | When you insert an OLE Object, such as a picture, in a form and set the Display Type property of the bound object frame to Icon , the object is not displayed as an icon when the record is saved. The Display Type property reverts to |
| 21568 | When you open a database or project in Microsoft Access by using the /runtime switch, the Help menu includes Sample Databases as an unavailable item. This selection should not be visible at all because the sample databases are not usually included in... |
| 21569 | You can set the number of times Access is able to undo the previous operation or command for any value between 1 and 20 by editing the following registry key: HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Access\Settings |
| 21570 | When you view a linked SQL Server table that contains at least one field with a data type of Decimal and if that Decimal field has its Identity property set to Yes , the data in the table appears as #Name. |
| 21571 | When you use dBASE III to open a dBASE III file exported by Microsoft Access, you receive the following error message: Not a valid dBASE III file. |
| 21572 | If you use the msoFileDialogSaveAs constant with FileDialog in a Microsoft Visual Basic module, your code is compiled as expected. However, when you run the code, you receive the following error message: Run-time error '445': Object doesn't support... |
| 21573 | When you start a Microsoft Access 2000 run-time application after you uninstall Microsoft Access 2002, including a Microsoft Access 2002 run-time application, you may experience either of the following symptoms: Visual Basic for Applications code... |
| 21574 | When you run a procedure that references an object from the Microsoft Jet and Replication Objects (JRO) 2.5 Library, you may receive the following error message: Microsoft Visual Basic Compile error: Can't find project or library. In addition, the... |
| 21575 | When you set the event property of a control in one form to be a function that is declared in the class module of another form, the order in which the arguments is processed is reversed. |
| 21576 | On a computer that is running Microsoft Windows 98, Microsoft Windows 98 Second Edition, or Microsoft Windows Millennium Edition (Me), when you open a database that contains approximately 120 modules, you receive an Out of memory error message.... |
| 21577 | When you use Microsoft Office speech recognition in Microsoft Access, the Dictation option may not be available in an Access project (ADP) file. |
| 21578 | On a Microsoft Windows 2000-based computer, when you use the Oracle 7.3 ODBC driver, you are prompted for an Oracle password to access an Oracle linked table even after you have click to select the Save Password check box in the List Tables |
| 21579 | If you specify a nonexistent server in the connection information for a Microsoft Access project (ADP), you receive one of the following error messages: Microsoft Data Link Error Test connection failed because of an error initializing provider.... |
| 21580 | After you set a password for the Admin user, non-Admin users can connect to and view data from a data access page without being prompted for a password. |
| 21581 | When you view data that you imported from a Microsoft Access Thai database, which was created in a version of Access earlier than Access 2000, the Thai characters may not be displayed correctly, even though the Thai language is enabled. |
| 21582 | When you select one of the sample databases in the New File window under Open a File , you receive the following error message: ! Could not find file 'C:\ ... Northwind Sample Database'. ! Could not find file 'C:\ ... NOTE : The New |
| 21583 | If you want to force a new line in a message box, you can include either: The Visual Basic for Applications constant for a carriage return and line feed, vbCrLf . -or- The character codes for a carriage return and line feed, |
| 21584 | This article discusses the differences between the CurrentProject.Connection and the CurrentProject.AccessConnection properties in Microsoft Access 2002 or later. |
| 21585 | It is sometimes useful to create forms with linked charts in order to chart data that only applies to the current record of the form. In earlier versions of Microsoft Access, you could do this by using Microsoft Graph. This article demonstrates how... |
| 21586 | This article shows you how to bind a data access page to XML to create a read-only view of the page. |
| 21587 | Combo boxes provide a good way of presenting a list of choices to a user. If the row source for a combo box needs to be based upon a subset of records from a table or query, you can add a WHERE clause to limit the choices. The example in this |
| 21588 | By using the new properties of the data source control, you can bind a data access page to XML data that is embedded within the data access page or in a separate XML file. Embedded XML is also known as a data island. If you bind the page to an XML |
| 21589 | When upsizing to an existing Access database, the tables are unexpectedly upsized to the Master database on your SQL Server. |
| 21590 | This article describes what is required to create an updateable form that is bound to an ActiveX Data Objects (ADO) Recordset object. |
| 21591 | The Microsoft Office XP Setup program and the Microsoft Access 2002 Setup program only update system files in certain situations and to a certain level. Therefore, after you install Access you may not have the latest version of the Microsoft Jet 4.0... |
| 21592 | This article describes how to create a sample user-defined function that uses the FileSearch object contained in the Application object to locate a file on a particular drive. |
| 21593 | It is possible to connect to a remote Microsoft Access database from Active Server Pages on an IIS Web server. To do this, you need to set up your connection string just as you would if the database were on the local server as described in the |
| 21594 | Because a Date/Time value is stored as a double-precision number, you may receive incorrect formatting results when you try to manipulate Date/Time values in an expression. This article demonstrates how to create expressions and custom functions for |
| 21595 | After you add ANSI-92 syntax to a query in a database that is also in ANSI-92 mode, the query still appears when you open the database in Access 2000. The query may or may not run correctly. |
| 21596 | A trigger that is assigned to a table does not display an error message when the trigger is executed. |
| 21597 | When you run a Left Outer Join or Right Outer Join query, Microsoft Access may return incorrect data. |
| 21598 | The ADO EndOfRecordset event is not triggered with form recordsets. |
| 21599 | After you rename fields within a table, you open a form or report that is based on that table and you are prompted to enter parameter values. When you check the design of your form, you find that all the controls on the form have been properly fixed |
| 21600 | When you try to delete a record from a table that contains a trigger that is designed to delete records from another table, you receive the following error message: Another user or application has deleted this record or changed the value of its |
| 21601 | When you import or create a link to a Microsoft Visual FoxPro database in an existing Access database, the default database type selected for Visual FoxPro databases in the Configure Connection dialog box is Free Table directory instead of Visual... |
| 21602 | When you use the question mark (?) or the asterisk (*) character as the criteria for a Filter By Selection, the filter is not applied. |
| 21603 | The column format on a Microsoft Excel worksheet is lost or replaced with a different format after you import the data into Microsoft Access or create a link to the Excel worksheet. |
| 21604 | When you try to sort on a column of a crosstab query, you receive the following error message: Cannot use the crosstab of a non-fixed column as a subquery. Cannot use the crosstab of a non-fixed column as a subquery. |
| 21605 | When you try to filter a data access page, you notice that sometimes the filter works as expected and sometimes it does not. It appears as though the filter never works when you use certain words to filter the data. |
| 21606 | When you use the ODBC Data Source Administrator to compact an Access database, you may receive the following error message if Version 3.x is selected under Format : ODBC Microsoft Access Driver Login Failed Cannot perform this operation; features in... |
| 21607 | When you attempt to establish a link to, or import, a Microsoft Outlook Address Book (such as Contacts), your computer may stop responding. |
| 21608 | If you use the Create table by entering data option to create a table, the primary key field begins with a value of 22 instead of the expected value of 1. |
| 21609 | When you open a linked table in Microsoft Access 2002 that can display related records in a subdatasheet, the process takes noticeably longer than it does if you use the same database in Microsoft Access 97. |
| 21610 | The Stop statement, which suspends the Visual Basic for Applications (VBA) code in a Microsoft Access 2000 database, no longer works when you use the same database in Access 2002. |
| 21611 | When you enter new data into a Microsoft Access database, your entry is immediately replaced by incorrect values. -or- When you enter new data, you receive the following error message: The data was added to the database but the data |
| 21612 | After you open a Microsoft Access project (ADP) that appears to connect successfully, no tables or queries are visible in the Database window, and you may receive the following error messages: When you are creating a new table, a stored procedure, or... |
| 21613 | When you try to filter an Access form or report by using a value that is displayed on another object, such as another Access form, the filter is not applied. |
| 21615 | After you save a data access page, you notice that one or more unexpected underscore characters appear in both the page name in Access and in the file name. |
| 21616 | In a data access page, if you call a function that is not available outside of Microsoft Access, you receive the following message when you open the page in Microsoft Internet Explorer: Data Provider failed executing a provider command. This message... |
| 21617 | This article shows you how to manage two lists so that items from one list can be transferred singly or as a group to the second list and vice versa. The process is similar to that seen in Access wizards such as the List Box wizard itself. |
| 21618 | When you use the expand indicator ( + ) in Datasheet view to display related records in a subdatasheet, the fields from those records are not available for selection if you switch to Pivot Table or Pivot Chart view. |
| 21619 | This article describes how to use the Forms! FormName ! ControlName parameter reference in the RecordSource property for a form in a Microsoft Access project (ADP). In this method, the difficult step is integrating a server-based query with Access... |
| 21620 | The Lookup Wizard that is available in an Access database (MDB) is not available in an Access project (ADP). However, in an Access project, you can set lookup properties manually to provide lookup functionality in an ADP. |
| 21621 | When you apply text criteria to tables in the Query Designer, a capital letter N may be added in front of the criteria. |
| 21622 | When you use a make-table query to create a new table, you are unable to change the format of Yes/No fields or Bit fields to display check boxes in Datasheet view. |
| 21623 | When you use the SQL Text Editor to create a text stored procedure or function, you notice that all code appears in black text rather than in the color-coded format that you see in Microsoft Access 2000. |
| 21624 | This article shows you how to programmatically change what paper bin the printer uses when you print a report. For example, suppose that you want to print the first page of a report from a paper bin that supplies custom letterhead and the remaining |
| 21625 | This article shows you how to use the new FileDialog method in Microsoft Access to display the built-in file dialog box and to determine what files the user selected. |
| 21626 | When you check out a Microsoft Access object from a Microsoft Visual SourceSafe project, you notice that previous changes that you made to new Access 2002 properties were not saved. |
| 21627 | When you use the Default keyword with a parameterized stored procedure, you are not prompted to provide a value for the parameter. Instead, the stored procedure automatically runs using the default value for the parameter. |
| 21628 | This article shows you how to use the new AddItem method in Microsoft Access to fill a list box or a combo box with the names of database objects. |
| 21629 | On the Tools menu, you can point to Office Links , and then click Publish it with Microsoft Word , Analyze it with Microsoft Excel , or Merge it with Microsoft Word . When you click one of these options, you receive one or more of the following error... |
| 21630 | You cannot use the TAB key to move focus to some controls in an Access wizard. For example, you cannot move focus to certain command buttons in a wizard. |
| 21631 | If you use the TransferDatabase action to try to link an external data source in an Access project (ADP), you receive the following error message: Links can only be created between Microsoft Access database files. |
| 21632 | The label on a record navigation bar of a data access page returns to its default when you click on the bar. |
| 21633 | When you use Microsoft Visual Basic for Applications (VBA) code to run a procedure in a Microsoft Access 2000 database, and the procedure contains an unhandled error or Err.Raise or Stop statements, the code does not return an error message or |
| 21634 | When you type text in a Microsoft Access table by using the Arabic keyboard, the character Alef may appear to be unconnected to the rest of the word to which it belongs. |
| 21635 | When you make changes to the PivotTable view or the PivotChart view of a form in a Microsoft Access database, the changes are not saved when you close the form. |
| 21636 | If you run a query or a filter on data from a Microsoft SQL Server-based table, you receive the following error message: ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Line1: Incorrect Syntax near ,.(#170) |
| 21637 | When you try to open a query that contains a function, you receive both of the following error messages. When you open any subsequent query, you receive only the second error. Your Microsoft Access database or project contains a missing or |
| 21638 | When you try to save a record in a replica, you may receive the following error message: Record is deleted. Record is deleted. |
| 21639 | When you create a TOP X or TOP X PERCENT view or function in a Microsoft Access project, the view cannot be updated as expected. The object can be updated only when you specify TOP 100 PERCENT . |
| 21640 | In Microsoft Access, when you display a custom Compressed HTML (.chm) Help file, the Help content is displayed in the Access Help window, along with the default Access index, the Access Answer Wizard, and the Access title. This behavior occurs even if |
| 21641 | When you use Microsoft Access 2002 to open a database that was created in an earlier version of Microsoft Access, the database project is decompiled, even though no modifications were made to the underlying Visual Basic for Applications code. |
| 21642 | When you import an Extensible Markup Language (XML) file into a Microsoft Access project (.adp), you may receive one of the following error messages: Microsoft SQL Server Desktop Engine must be on the machine running Microsoft Access. -or-... |
| 21643 | The Access 2002 sample database Northwind.mdb and the sample project NorthwindCS.adp are no longer located under the Open command on the File menu. In Access 2002, the sample files have been moved to the Help menu. To open either |
| 21644 | When you open the sample database Northwind.mdb, you receive the following error message: Run-time error '3709': The Connection cannot be used to perform the operation. It is either closed or invalid in the context. Run-time error |
| 21645 | The Access Workgroup Administrator program has been integrated into the Access 2002 user interface. To start the Workgroup Administrator program, point to Security on the Tools menu, and then click Workgroup Administrator . |
| 21646 | When you view a table, a query, or a form that is using a lookup field in PivotTable or PivotChart view, the actual data stored in the field is displayed instead of the data from the lookup field. |
| 21647 | In an Access database (MDB) file or an Access project (ADP) file, you notice that the command to make an MDE or ADE file is not available on the Database Utilities menu on the Tools menu. |
| 21648 | While debugging your code that uses Automation to control Microsoft Access, you may receive one of the following errors. When automating Microsoft Access 95: MSACCESS caused an Invalid Page Fault in module MSACCESS.EXE at 0137:5000f878 -or- MSACCESS... |
| 21649 | There is no Automation method in the object model of Access that allows Visual Basic to open a secured Access database without getting a prompt requesting a username and password. However, it is possible to accomplish this using the Shell command. |
| 21650 | When you insert a new record into a linked ODBC table that has a fixed-length text field (CHAR) as the primary key, #DELETED appears in all of the fields in the new record. NOTE : If you then close and reopen the linked table, the newly |
| 21651 | The utility program described in this article provides the developer with a tool to list the Visual Basic for Automation (VBA) routines stored in a Microsoft Access database (*.mdb). This tool provides a means for auditing databases and for locating... |
| 21652 | Forms bound to a cursor that uses batch updates do not display the cursor's data correctly after the data has been modified. |
| 21654 | When you insert a Microsoft Excel workbook into a document of one of the Office programs listed at the beginning of this article or in a form in Microsoft Access, you receive one of the following messages Macros in this workbook are disabled because... |
| 21655 | Microsoft Access 2002 allows you to enable and add additional users to a Microsoft Access 97 workgroup information file (.mdw). However, you are prevented from converting the file to Access 2000 or 2002 format. In this case, the Convert Database Into... |
| 21656 | When you copy and paste a table in a Microsoft Access project, the new table does not include extended properties from the original table. |
| 21657 | Microsoft Access 2002 introduces the ability to view tables, queries, views, functions, and forms in PivotTable view by natively hosting the Microsoft Office Web Components. This article shows you how to programmatically build a PivotTable view in a |
| 21658 | With the introduction of data access pages in Access, you can now create data bound Web pages that can be viewed in Microsoft Internet Explorer 5 or later. By default, these pages try to bind to data on the client computer, making them ideal for... |
| 21659 | In Microsoft Access 2000, conditional formatting was added to forms and reports to allow users to format a control based on a particular condition. However, in the Access user interface, you cannot automatically propagate the conditional formatting of |
| 21660 | In Microsoft Access 2002, you can view tables, queries, views, functions, and forms in PivotChart view. This is possible because Access 2002 natively hosts the Microsoft Office Web Components. This article shows you how to use the Office Web |
| 21661 | When you run a macro that uses the TransferSpreadsheet action to export a table or query to the Microsoft Excel file format, you receive the following error message: Cannot update. Database or object is read-only. Cannot update. |
| 21662 | This article demonstrates how to use the Windows Installer to find the installation path of Microsoft Office or an Office XP or an Office 2003 applications. |
| 21663 | An ATL ActiveX Control does not appear or appears incorrectly when added to a Microsoft Access Report. The same control displays correctly when the Report is in design mode or if the control is added to an Access Form. |
| 21664 | Automation clients written for Microsoft Access 97 that use either early binding (VB, ATL with #import) or dispid binding (MFC) might unexpectedly fail when trying to automate Microsoft Access 2000 or 2002. Among the possible errors you might receive... |
| 21665 | Clients that use early binding to the Microsoft Calendar control (Mscal.ocx) may encounter unexpected errors or invalid data or may crash because of stack corruption when the properties or methods of the control's ICalendar interface are called. |
| 21666 | When you try to edit a record that has an expression on a data access page, you receive the following error message A value could not be saved into the data source's '' field. Operation failed with a status of 0. Discard changed value? |
| 21667 | This article describes how to programmatically rotate a chart in PivotChart view in Microsoft Access. Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the... |
| 21668 | When you have set Default open mode to Exclusive on the Advance tab of the Options dialog box, and you then open a database by clicking Open Exclusive in the Open dialog box, Microsoft Access opens the database for shared use. |
| 21669 | When you try to start the Query Designer by clicking the Build (...) button next to the RecordSource property of a report, you receive the following error message: This version of Microsoft Access doesn't support design changes to the |
| 21670 | This article shows you how to create queries that return records based on a range of letters in a text field. Although there are several ways to do this in Access, this article shows you how to specify the range by using brackets. |
| 21671 | When you view a table in Datasheet view, filter by form does not filter data that has commas in it if all of the following conditions are true: The display control is a combo box. The bound column is hidden. The displayed column |
| 21672 | When you export a form or a report, you can export live data if you are using a Microsoft Access project (ADP) that is connected to Microsoft SQL Server 2000 or later. Live data is not updatable. However, if you refresh the page by closing and |
| 21673 | When you edit data that uses multiple forms that have the same record source, you may receive the following error message: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the |
| 21674 | This article shows you how to programmatically determine if the currently open file is an MDE or ADE file. |
| 21675 | This article shows you how to dynamically build criteria for a query string with values from a search form. |
| 21676 | The Auto List Members feature in Microsoft Access helps you type Visual Basic for Applications code by displaying a list of the properties and methods of an object as you type. However, when you type the name of a report control in the class |
| 21677 | When you try to pass a valid UDL file as the BaseConnectionString argument of the CurrentProject.OpenConnection method in an Access project (ADP), you receive no error message, but the ADP file is not connected. |
| 21678 | This article explains the role and relationship of the workgroup information file in Microsoft Access security. |
| 21679 | The About ANSI SQL query mode topic in the Microsoft Access Help system has a hyperlinked subtopic named Why use ANSI-92 SQL? This subtopic states the following: You may want to use ANSI-92 SQL for the following reasons: You want to take advantage... |
| 21680 | When you try to add a record to a datasheet that is produced by a query that has three or more tables, Microsoft Access will either stop responding (hang) briefly and will eventually quit without a warning or error, or you receive one of the following... |
| 21681 | When you save a form in PivotTable or in PivotChart view as a report, the report does not have a PivotTable or PivotChart object. |
| 21682 | When you use the vertical scroll bar to scroll through a text box on a subform, you may receive the following error message: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. When you view the details... |
| 21683 | With a Pareto chart, you can easily analyze categorical data. In a Pareto chart, categories are arranged in descending order from left to right as histogram columns, based upon a selected numeric criterion, from highest to lowest values. Then, an |
| 21684 | This article demonstrates how to programmatically create an AutoNumber field in a Microsoft Access table and set this field's New Values property to Random . |
| 21685 | This article shows you how to simulate a progress bar on a form by using the rectangle controls in the Microsoft Access toolbox. In this example, you create a form that uses either Data Access Objects (DAO) or Microsoft ActiveX Data Objects (ADO) to |
| 21686 | For various reasons, you may decide to split your database into a front-end/back-end application. The back-end database contains the tables and is stored on a file server. The front-end database, which links to the back-end tables, contains all the... |
| 21687 | This article lists some of the resources that are available to help you learn Microsoft Visual Basic for Applications programming. The article contains the following categories: Online Help The Object Browser Microsoft Press and Third-Party Reference... |
| 21688 | On a Microsoft Access form, you can enter the record number in the navigation bar to move to a particular record. Data access pages do not have this feature. However, you can simulate this functionality on data access pages by using script to respond... |
| 21689 | When you use Automation to create a new object in a Microsoft Access run-time application on a computer that does not have the full version of Access installed, you receive the following error message: Runtime error -2147023181 Automation error:... |
| 21690 | When you use Visual Basic for Applications (VBA) code to switch between views on open tables or queries, you may receive the following error message, and then Microsoft Access quits: Microsoft Access has encountered a problem and needs to close. We... |
| 21691 | After you change a relationship that is made up of multiple fields in the data outline on a data access page, Microsoft Access may stop responding (hang) or may quit unexpectedly when you browse through the page. |
| 21692 | When you paste a hyperlink from a Microsoft Access table into Microsoft Word, Microsoft Excel, or Microsoft PowerPoint, the display text of the hyperlink changes to question marks or to other unreadable characters. When you paste the hyperlink as |
| 21693 | The Microsoft Access 2002 Startup command-line options Help topic incorrectly states the following: Converts a previous-version Access database or Access project to the default file format, renames the new file, and then closes Access. You must... |
| 21694 | When you access a local area network (LAN) or intranet share, or intranet Web site by using an Internet Protocol (IP) address or fully qualified domain name (FQDN), the share or Web site is identified as being in the Internet zone instead of the Local... |
| 21695 | Microsoft has made available a downloadable Help file that contains automation theory and multiple examples showing how to automate the Microsoft Office XP programs listed at the beginning of this article. |
| 21696 | When you use Microsoft Access, you receive the following error message: ActiveX component can't create object This article describes some common causes for this error message and offers methods that you can use to resolve the issue. |
| 21697 | When you try to open an Access 97 database in Access 2002 or later, you may receive one of the following error messages: Cannot open a database created with a previous version of your application. -OR- Cannot open database PathToDatabase It may not be... |
| 21698 | When you author any new Microsoft Operations Manager (MOM) reports by using Microsoft Access 2002, MOM reporting may not work on Access 2000 due to compilation errors. |
| 21699 | When you set the system date on your computer to a year greater than or equal to 2038, you may receive the following error message: Synchronization between replica and replica failed. The Microsoft Jet database engine could not read the |
| 21700 | When you enter a date range in a Server Filter by Form window, search for records, and then return to the Server Filter by Form window, date criteria is incorrectly converted to Microsoft Jet syntax. For example, if you enter the date criteria |
| 21701 | When you upgrade to Microsoft Office XP from Microsoft Office 2000, your PowerPoint 2000 templates are not saved and installed in the Office XP template folder. As a result, some of the PowerPoint 2000 templates are not available when you upgrade to |
| 21702 | This article shows you how to display the |
| 21703 | When you start Microsoft PowerPoint or Microsoft Publisher on one of the following Hewlett-Packard (HP) laptops HP Pavilion n5470 HP Pavilion n5430 HP Pavilion xh485 HP Pavilion xh455 you receive a series of error messages that can include any of the... |
| 21704 | The "Microsoft Access 2002 Conversion" white paper has useful information about how to convert databases that were created in earlier versions of Access to the Access 2002 file format. This white paper also describes the issues that you may |
| 21705 | This article describes the numbering scheme used by Microsoft Office-family programs and utilities. |
| 21706 | Sometimes, you may have to perform maintenance tasks on a Microsoft Access database, such as compacting or repairing, making backup copies, or making design modifications. Many of these operations require that all users exit the database. H |
| 21707 | To enable the |
| 21708 | Use this step-by-step guide to call a .NET class library from Visual Basic for Applications. This sample shows how a Visual Basic for Applications program can use a Visual Basic .NET class library to encrypt and decrypt a string. You can use the... |
| 21709 | When you use = Null instead of Is Null as the criteria for a query, the query may not return the expected results. For example, a query may return no records if you use = Null as the criteria in a field that has records that have no data.... |
| 21710 | The Readme.doc file that is located on the root of the Office 2000 CD contains incorrect information about the Office readme file. For late breaking or other information relevant to all the Microsoft Office 2000 products, see the Ofread.txt |
| 21711 | This article contains information about the Microsoft Office 2000 FYRO Macedonian Update. The following text explains why an update was necessary, how to download it, and how to install it. |
| 21712 | This article describes how to clear the Most Recently Used list (MRU) for the Microsoft Office programs listed at the beginning of this article. To clear the MRU, follow the steps for the program that you are using. Microsoft Access, Excel, PhotoDraw,... |
| 21713 | This article shows you the proper format for connection strings when you deploy data access pages. The path in the connection string must point to a database that can be seen from the Web server. This article also shows you some connection |
| 21714 | When you add a reference to the Access 10.0 object library to create a COM interop assembly, you may receive the following error message: |
| 21715 | This article discusses the causes of fatal system errors in Microsoft Access 2002 running on Windows 2000 and provides general troubleshooting steps that you can use to solve these errors. This article first discusses a new error reporting tool in... |
| 21716 | This article describes how to store Outlook 2002 items in a Microsoft Access 2002 database file. |
| 21717 | In Microsoft Access, you can create new instances of heavyweight |
| 21718 | When you try to use System.Runtime.InteropServices.Marshal.GetActiveObject from Microsoft Visual C# .NET to automate a Microsoft Office application, you may receive the following error message, even though the Office application is running: An... |
| 21719 | When you use the Import wizard to import and open Excel workbook, Date fields are displayed as numeric values. |
| 21720 | When you use the Add/Remove Programs tool in Control Panel to install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) from the MSDE2000 folder of the Microsoft Office XP installation CD-ROM, you may find that nothing is installed. Setup may start... |
| 21721 | This article explains the capabilities, the limitations, and the workarounds for using Microsoft SQL Server Application roles in a Microsoft Access project (ADP). |
| 21722 | Microsoft has expanded its online services to a non-proprietary platform with the addition of no-charge Microsoft-sponsored NNTP newsgroups on the Internet. Previously, Microsoft-sponsored electronic service forums were limited to users of CompuServe... |
| 21723 | The Microsoft Knowledge Base contains a wealth of information about all Microsoft products and technologies. This article introduces you, the Access 2002 user, to the Microsoft Knowledge Base and gives you tips to find the information and the... |
| 21724 | A chart on a report displays incorrect values for some records. |
| 21725 | Handwriting recognition is a new feature in Microsoft Office XP. The Handwriting Recognition in Office XP white paper provides a general overview of handwriting recognition. Topics include installation and setup, system requirements, working with... |
| 21726 | Speech recognition is a new feature in Microsoft Office XP. The Speech Recognition in Office XP white paper provides a general overview of speech recognition. Topics include installation and setup, system requirements, the user interface, using... |
| 21728 | The |
| 21729 | When you export data to the Microsoft Excel file format, null values are replaced with the data that should be in the next column in the resulting spreadsheet. |
| 21730 | This article discusses and explains how COM (Component Object Model) determines which version of an Office application is loaded when you use Office Automation. |
| 21731 | When you supply a GUID value as a criteria in a query field that is based on an AutoNumber field that is set to a Replication ID, no fields are returned. You might see this if you reference a form field that contains the Replication ID in t |
| 21733 | If you decide to store the data for your solution in an Access database or in another relational database, designing the database structure is likely to be the most challenging part of building the solution. Although it is fairly easy to mo |
| 21734 | By using Microsoft Visual Basic for Applications in Microsoft Access, you can prevent users from logging on to a Jet database. If users are already in the database, they will remain logged on; however, no other users will be able to open th |
| 21735 | When you click a shortcut to an existing Microsoft Access database, you receive the following error message: |
| 21736 | After you install the Microsoft URLScan utility or the IIS Lockdown Tool on the Microsoft Internet Information Services (IIS) server that is hosting the Microsoft Jet Internet Synchronizer, you receive the following error message when you try to... |
| 21737 | When you open or convert a database that was created in a version of Access earlier than Access 2000, and you attempt to run or compile older code that uses Data Access Objects (DAO), you may receive compile errors. |
| 21738 | After you upgrade your computer from Office 97 to Office XP, your custom dictionary is not available. You expect the custom dictionary settings that you configured in Office 97 to be migrated when you upgrade to Office XP. NOTE : |
| 21739 | The Show Desktop button on the Quick Launch portion of the taskbar minimizes all the open windows on the desktop. When you click it a second time, the windows are not restored as expected but remain minimized. |
| 21740 | When you drag commands on the File menu to a location above the list of Most Recently Used files, and no menu command appears below that file listing, you are no longer able to place a menu command below the listing of most recently used files. You... |
| 21741 | In any Microsoft Office XP program, you may hear a beep when you click a menu item or anywhere within the document, or if you press a key on the keyboard. - or - If you click Show the Office Assistant on the Help menu or press the F1 key, the Office... |
| 21742 | This article describes Microsoft Office XP features that are turned off or not installed when you select Not Available for Microsoft Visual Basic for Applications when you install Office XP. |
| 21743 | This article demonstrates how to obtain the window handle of an Office application with Microsoft Foundation Classes (MFC) while automating that application from Visual C++. |
| 21744 | This article explains how you can examine the registry at run time to determine the installation path and version of an Office application. |
| 21745 | After you install a Microsoft Office Service Pack or you upgrade from one version of Microsoft Office to a newer version, you cannot access the Internet. |
| 21746 | This article illustrates by example how you can create an MFC Automation client to retrieve a list of Visual Basic for Automation (VBA) macros ( Sub and Function procedures) from a Microsoft Office document. |
| 21748 | Task panes, a new feature in Microsoft Office XP, provide a common area for those commands that may require more information or options than a toolbar can provide. This article describes task panes and how to use them. |
| 21749 | In any of the Microsoft Office XP programs listed at the beginning of this article, when you select the Pumpkin (large) desktop scheme, the selected menu item may be gray instead of the standard Pumpkin (large) desktop scheme of purple or white with a... |
| 21750 | When you attempt to use the Sign out of Microsoft Passport command, the command may be unavailable and you are therefore unable to sign out. In Microsoft Excel 2002, the Sign out of Microsoft Passport command is available, but when you click it,... |
| 21751 | When you view your company name in the startup splash screen for the Office programs, the name may be different from the name that appears in the dialog box when you click About program name on the Help menu. (For example, in Word 2002, you click... |
| 21752 | When you use keyboard commands to open the task pane in a Microsoft Office XP program (press ALT+F, and then press N), you may be unable to close it with a keyboard command as expected. |
| 21753 | When you start an Office XP program or try to use the Office Assistant from within a program, you may receive the following error message: The Office Assistant requires Microsoft Agent 2.0 or later. This product is available on the Office System Pack. |
| 21754 | When you start one of the Office programs, you may be prompted to type your user name, initials, organization, and CD Key. You may see this prompt even though you typed in your user information and CD Key when you installed Office 2000. |
| 21755 | Microsoft Office XP provides a FileDialog object that gives you functionality that is similar to the standard Open and Save dialog boxes that are found in all Office XP applications. By using FileDialog objects in your Visual Basic for Application... |
| 21756 | When you insert an object from one program (for example, a Microsoft Excel worksheet object) into another program (for example, Microsoft Word), and then you deactivate and reactivate the inserted object, the Undo command may behave differently in... |
| 21757 | When you start the Microsoft Office Application Recovery utility, earlier versions of Office programs are listed as running applications. Also, when you select an earlier version of an Office program and click either Recover Application or End... |
| 21758 | When you run Office Setup, you may receive an error message similar to one of the following: Ie5wzd caused an exception in module Msjava.dll Ie5wzd caused an exception in module Msjava.dll -or- Ie5wzd caused an exception |
| 21759 | In a Microsoft Office XP program, when you click Open on the File menu, select a File Transfer Protocol (FTP) site, and then click Open , you may receive error messages similar to the following: Cannot connect to the FTP server on the computer named... |
| 21760 | When you start one of the Microsoft Office XP programs on a computer that is running Microsoft Windows NT, Microsoft Windows 2000, or Microsoft Windows XP, the program starts and then immediately quits. |
| 21761 | When you attempt to start an Office program, the following error message appears: This application requires the Windows Installer to run. This application requires the Windows Installer to run. |
| 21762 | When you install one of the products listed above and then install a second product listed above (CD1 or CD2 in the case of Microsoft Office), the default installation location of the second product is not the location where you installed the previous |
| 21763 | When you click Paste All in the Office Clipboard to paste multiple entries in your document, and then you click Undo on the Edit menu, not all of the items pasted are undone. Only the most recent item pasted from the Clipboard (the last item in the... |
| 21764 | When you use any of the Microsoft Office XP or Microsoft Office 2000 programs, you may notice one or more of the following behaviors: Publisher document icons are displayed as generic icons. Microsoft Publisher is no longer displayed under Programs on... |
| 21765 | When you use the Handwriting feature on the Language bar for the first time, Microsoft Office XP creates a file called Inferno.log in the root directory of drive C on your computer. Each time that you use the Handwriting feature, an entry of your... |
| 21766 | When you attempt to start a Microsoft Office XP program, the Microsoft Windows Installer starts, and then you may receive the following message: Please wait while Windows configures Microsoft Office version Gathering required information... |
| 21767 | When you reset a customized toolbar button or menu command in any Microsoft Office program, if the control style has been changed, the reset operation may not change the item back to the original style as expected. This behavior occurs both when you... |
| 21768 | When you click Paste All on the Microsoft Office Clipboard, the items are not pasted into your document in the same order that they appear on the Clipboard. |
| 21769 | When you have multiple documents open in a Microsoft Office program, and you press ALT+TAB to switch to another document, there is one more document icon displayed than there are open documents. |
| 21770 | When you view the Application Error Reporting log in Microsoft System Information after an Office program stops responding (hangs or crashes), the date of the incident is not displayed as expected. This behavior occurs when you use Microsoft Office XP... |
| 21771 | When you attempt to import tables from an Access 2000 or 2002 database to Outlook 2000 or 2002, the following error message may appear: An ODBC error has occurred in the Microsoft Access translator while opening a file to build a field map.... |
| 21772 | When you try to send a Microsoft Access database table (.mdb) as an .XML format attachment by clicking Send To on the File menu in Access, you may receive the following error message: Microsoft Access Can't Send this format in a Mail Message. |
| 21773 | This article lists some of the technical resources available on the Microsoft World Wide Web site that can help you find answers to questions about Microsoft Office XP. |
| 21774 | When you start any of the Microsoft Office XP programs, for example, Microsoft Excel 2002, you receive an error message similar to the following: C:\Program Files\Microsoft Office\Office10\EXCEL.EXE There is not enough free memory to run |
| 21776 | When you reference hyperlinks in Visual Basic for Applications, you may receive the following error message: No program is registered to open this file. |
| 21777 | When you click one of the Help topics displayed by the Office Assistant, the following behavior may occur: The Office Assistant becomes hidden. When you click the window for the active Office program, the Office Assistant reappears. |
| 21778 | When a user who does not have the Office XP Web Components installed on their computer accesses a Web page that contains an Office XP Web Component, he or she may receive a message similar to the following: To use this Web page interactively, you must... |
| 21779 | This article lists the materials and software that are included in the North American product boxes for the Microsoft Office XP suites and the stand-alone versions of programs in Microsoft Office XP, such as Microsoft Excel 2002. |
| 21780 | Microsoft Office XP is available in two versions, a non-upgrade version that you can install on any compatible computer, and an upgrade version that requires that a qualifying product be installed on your computer or that the installation media from |
| 21781 | When you minimize or close an Office program, the Language bar may be minimized or may seem to disappear. NOTE : The Language bar does not disappear; it is minimized to an indicator button in the status area on the Microsoft Windows taskbar (to the... |
| 21782 | After converting a Microsoft Access 2002 database to Microsoft Access 97, you receive the following error message when you open a form or report in the new Microsoft Access 97 database: There is no object in this control. |
| 21783 | When you try to use a Microsoft Jet 3.x workgroup information file (system database) with the Microsoft Jet 4.0 OLE DB provider, you may receive the following error message: Run-time error '3251': Object or provider is not capable of performing... |
| 21784 | If you enter a partial date in a field that is assigned the Date/Time data type, Microsoft Access fills in the current year automatically. |
| 21785 | Microsoft Access has two options that force date fields and controls to display four-digit years. One option, This database , forces the display of four-digit years at the database level in a particular database or project. The other option, All |
| 21786 | This article shows you how to use code to embed a bitmap image in a report at run time. The example uses an image control instead of an OLE object frame to store the bitmap. You can use Visual Basic for Applications code to embed an OLE object |
| 21787 | Microsoft Office XP introduces two new properties to the CommandBarButton object: the Mask and Picture properties. You can use these properties to place pictures on custom generated command bar controls. Note These properties are also available in... |
| 21788 | When you view the event properties of a form in Design view, you do not see an OnRecordExit event property, even though this event is documented in the Access 2002 Help system. |
| 21789 | When you set the Filter property of an ActiveX Data Objects (ADO) recordset that is opened with the Microsoft Jet OLE DB provider, no records are returned. |
| 21790 | The Employees form module in the Northwind sample database and NorthwindCS sample project contains an event procedure for the RecordExit event that does not work. |
| 21791 | When you print a form that contains a subform in PivotChart view, the PivotChart ignores the right margin of the page, and some portions of the PivotChart are duplicated on subsequent pages. For example, a subform PivotChart that spans two pages will |
| 21792 | When you try to import XML, you may receive the following error message: Microsoft Access cannot create table(s) using the information contained in the document(s) you are trying to import. This article explains the possible causes of this error... |
| 21793 | This article describes how to access data in a Microsoft Visual FoxPro database (.dbc file) from Microsoft Access 2002. This article is divided into two parts. The first part explains how to set up a data source that points to a Visual FoxPro... |
| 21794 | This article shows you how to use a Microsoft Access form to specify the query criteria in an Access 2002 project. |
| 21795 | When you print a Microsoft Office XP document to an IBM InfoPrint 20 PS printer, and you choose to print hidden text, the hidden text is not printed as expected. |
| 21796 | After you try to programmatically export a Microsoft Graph object, you receive the following error message: The operation on the Chart object failed. The OLE server may not be registered. To register the OLE server, reinstall it. |
| 21797 | On a Microsoft Windows Millennium Edition (Me)-based computer, when you attempt to view the system information summary of a Microsoft Office XP program, you may receive an error message similar to the following: Microsoft program 2002 has not been... |
| 21798 | When you search for Help topics on any of the type conversion functions by name in Microsoft Visual Basic Help, you do not get the Help topic you were looking for. For example, if you type Cbool in the Office Assistant balloon or the Ask a Question... |
| 21799 | When you are setting a data-related property during one of the PivotTable- or PivotChart-related events in a form, you receive the following error message: Run-time error '2101' The setting you entered isn't valid for this property. |
| 21800 | When you start a Microsoft Office program with the /safe command-line switch, the Microsoft Windows Installer dialog box may appear. The Installer dialog box may remain on the screen for several minutes before the Office program starts. |
| 21801 | When you import a data access page from a Microsoft Access database or a Microsoft Access project (.mdb or .adp) into your current Access database or project, the ConnectionString property of the page still references the original source. |
| 21802 | When you call the ExportXML method in Visual Basic for Applications, you may receive the following error message: Runtime Error '2950': Reserved Error Runtime Error '2950': Reserved Error |
| 21803 | This article shows you how to use Microsoft Visual Basic for Applications to output a list of users who are logged onto a database. |
| 21804 | Silent design changes (minor design changes) that are made to Microsoft Access-specific objects, such as forms, reports, macros, modules, or commandbars, may be discarded without warning. |
| 21805 | Data Transformation Services (DTS) is an alternative method that you can use to move data from an Access database to Microsoft SQL Server. Note The previous version of Microsoft SQL Server 2000 Desktop Engine was called Microsoft Data Engine (MSDE).... |
| 21806 | When you scroll through records on a form that contains a linked subform in PivotChart view, you notice that the formatting for individual series in the PivotChart is lost. For example, trendlines, error bars, and data labels are discarded, and |
| 21807 | This article shows you how to use the DLookup() function, and includes examples and tips. The following topics are addressed in this article: The DLookup() function syntax and usage. The following DLookup() function |
| 21808 | When you open Microsoft Access and a form through Automation and set focus to the form's custom menu bar, you receive the following Microsoft Visual Basic error message: Run-time error '-2147467259 (80004005)': Method 'SetFocus' of object... |
| 21809 | When you perform an operation on a table, you may receive the following error message if the operation creates a large number of page locks: There isn't enough disk space or memory. There isn't enough disk space or memory. If you run an |
| 21810 | This article describes several tips for improving performance when you access data from an ODBC data source. |
| 21811 | In the Import , Export , and Link dialog boxes in Microsoft Access 2002, FoxPro is not listed as an option for file type. |
| 21812 | This article lists sample expressions that you can use to extract a portion of a text string. These expressions are commonly used in the Update To line of an update query to place a portion of a larger field into a new field. You can adapt these |
| 21813 | When you use the FindFirst method, you receive a No match or a run-time error message. This behavior occurs when you search for a value that contains an apostrophe ('). For example: rst.FindFirst [CompanyName] = 'B's Beverages' This behavior also... |
| 21815 | Vertical line controls do not increase in height when you place them in a report section even if you set the CanGrow property for the section to Yes . |
| 21816 | The Deploying Data Access Pages on the Internet or Your Intranet white paper is available in the MSDN Online Library. To view this white paper, visit the following Microsoft Web site: |
| 21817 | When you select a number in the DecimalPlaces property setting, it appears to have no effect when the Format property is set to General . |
| 21818 | This article lists words and symbols that you should not use in field, object, and variable names because they are reserved words. Reserved words have a specific meaning to Microsoft Access or to the Microsoft Jet database engine. If you use a... |
| 21819 | When you convert a Microsoft Access 1.x or a Microsoft Access 2.0 database to Microsoft Access 2002, the conversion process may display a warning message or stop altogether because of an incompatibility with the new features and enhancements. This... |
| 21820 | When you create a form or a report where the RecordSource property is set to a SELECT statement containing the at sign (@) in the WHERE condition, you receive an error message similar to this one: Closing delimiter not found for the string |
| 21821 | In Microsoft Access 2002, if you manipulate a main form and a subform in Design and Form views, you may receive the following error message, and then Access quits: Microsoft Access has encountered a problem and needs to close. We are sorry for the... |
| 21822 | In Microsoft Access, you may be unable to undo typing in a subform as expected by pressing CTRL+Z after you change the view of your subform. |
| 21823 | When you use code to select an index and open an ActiveX Data Objects (ADO) recordset, the procedure may fail with the following error message: Run-time error '-2147217687 (80040e35)' Specified index does not exist. Run-time error |
| 21824 | When you import any type of data into a database that you previously added to Microsoft Visual SourceSafe control, you receive the following error message: Microsoft Access To import tables, relationships, menus, toolbars, import/export specs or data... |
| 21825 | If you use the What's This Help feature (the question mark in the upper-right corner of a dialog box) in the Advanced Export XML dialog box, you may notice that the tooltips that are displayed do not seem to apply to the item that you clicked to |
| 21826 | When you modify an existing stored procedure, save the changes, and then attempt to run the procedure, you receive the following error message: Could not find stored procedure ' stored procedure name '. Could not find stored procedure ' |
| 21827 | When you create or modify a scalar function, and you then try to run the function without first closing it, the scalar function returns an empty column in the result set and displays the scalar function name in quotation marks as the column name. |
| 21828 | When you specify Calculate percent of total for sums on the Summary Options page of the Report Wizard, the caption of the label control reads Standard instead of Percent on the report that is created. |
| 21829 | When you export a table that includes a field with the currency data type formatted in the euro currency style to an Extensible Markup Language (XML) document, the euro currency symbol is not displayed when the exported data is viewed in a browser. |
| 21830 | When you right-click a PivotTable in a subform, the shortcut menu may not show all of the items that you expect to see. |
| 21831 | When you apply a filter to a table in a Microsoft Access project and switch to PivotTable or PivotChart view, the complete set of records is represented in that view instead of the filtered set. |
| 21832 | When you create a data access page, you may notice that stored procedures appear in the list of tables and queries in the New Data Access Page dialog box as well as in the Page Wizard. If you select one of these procedures when you use the wizard, |
| 21833 | After you install Microsoft Visual C++ 6.0, the only ActiveX calendar control available to insert in Design view of a data access page or a form is version 8.0. |
| 21834 | In Microsoft Access, when you use Microsoft Visual Basic for Applications (VBA) code to set the PaperSize property of a Generic / Text Only printer to acPRPSDSheet or acPRPSESheet while the report is open in Preview, you may receive the |
| 21835 | When you close a Microsoft Access table in PivotTable view after you change the width of its window, you receive the following message Do you want to save the changes to the layout of table ' tablename '? where tablename is the table that you have... |
| 21836 | In Microsoft Access, when you use the Expression Builder to create an expression that is longer than the width of the expression box, the text of the expression is not wrapped to the next line as expected. Instead, the expression continues in one long |
| 21837 | You are unable to expand subdatasheets in a table's datasheet view when you use a function as the source object for the subdatasheet. |
| 21838 | In Microsoft Access, after you set the Recordset property, the text box portion of a combo box may unexpectedly remain blank when you select items from that combo box. |
| 21840 | When you try to transfer a Microsoft SQL Server 2000 database that is connected to a Microsoft Access project (ADP), you receive the following error message: [Microsoft][ODBC SQL Server Driver][SQL Server]Windows NT user or group '\' not found. |
| 21841 | When you try to install Microsoft SQL Server 2000 Desktop Engine on a computer that already has SQL Server 2000 Desktop Engine installed, you receive the following error message. The installation package could not be opened. Verify that the package... |
| 21842 | ANSI-92 reserved words generate the following error in queries when the check boxes under SQL Server Compatibility Syntax (ANSI 92) are selected. Reserved Error (-1001); There is no message for this error. Reserved Error (-1001); There |
| 21843 | When you try to import or link a dBASE file to a Microsoft Access 2002 database or project, you receive the following error message: 3015 Index not found. 3015 Index not found. |
| 21844 | After you run a stored procedure that updates, appends, or deletes records from a table, you notice that not all of the records that match the specified criteria are updated, appended, or deleted. |
| 21845 | When you start a Microsoft Windows 98 or a Microsoft Windows Millennium (Me) computer after you have installed the Microsoft SQL Server 2000 Desktop Engine from the Microsoft Office XP CD1, you see the Windows splash screen, and then you are return to |
| 21846 | In the Microsoft Access Help topic Create a filter, step 4 of the subtopic Filter records by selecting values in a form or datasheet (Filter By Selection) may be confusing. This step instructs you to Repeat steps 2 and 3 until you have |
| 21847 | When you run a parameterized query, you receive two prompts for each parameter that is defined in the query. |
| 21848 | You notice that a Hyperlink field appears with a pound sign (#) preceding the URL in Form view. When you switch to Design view, the IsHyperlink field is set to No , even though it was set to Yes before you changed views. |
| 21849 | When you set or retrieve the Recordset property of a report in a Microsoft Access database (.mdb), you receive the following error message: Run-time error '2593': This feature is not available in an MDB. Run-time error '2593': |
| 21850 | When you use a PivotTable form as a subreport in a report in a Microsoft Access database or project, the subreport does not grow to accommodate all of its data. This behavior occurs even if both the subreport's Can Grow property and the report's |
| 21851 | When you try to open a form or a report in a replicated database, and if the database is in Microsoft Access 2000 format, and you if then try to open the Visual Basic Editor, you receive the following error message Microsoft Access failed to create... |
| 21852 | When you rest the mouse pointer over a report name in the Database window, you receive the following error message: Microsoft Access can't open the file 'Path to file'. |
| 21853 | When you bind a data access page that was saved from a grouped report to XML, only the lowest level group on the page is bound. Other groups on the page do not display data. |
| 21854 | When you change the ProductName field in the Order Details Extended view to a different value, the ProductName field is properly updated to the new value. However, the ProductID is still the product identification number for the original product name |
| 21855 | When you export a Microsoft Access object (a form or a report) by using the XML Documents setting, and you include an HTML 4.0 presentation file, you may receive an error message similar to the following when you attempt to view the HTML document |
| 21856 | When you attempt to change the icon for an object during any of the following operations Insert Object Convert Object Paste Special by using the From File option, you receive the following message: File mspaint.exe does not exist. |
| 21857 | When you use the Upsizing Wizard to convert a Microsoft Access database that contains data access pages to an Access project, you may receive the following error message: UT_HandleADPDataPages Bad file name or number 52 UT_HandleADPDataPages |
| 21858 | When you perform a search that uses the FindFirst method and LIKE without a wildcard character (*), you get different results in a DAO snapshot recordset and a DAO dynaset recordset. Using a DAO snapshot, the search acts as if the wildcard character... |
| 21859 | When you save a report containing a grand total as a data access page, the Grand Total box is blank. |
| 21860 | When you edit a record in a multi-user environment, you may receive the following error message when you attempt to commit your changes: Write Conflict This record has been changed by another user since you started editing it. If you save |
| 21861 | After you install a run-time version of Microsoft Access 2002 on a computer that has Microsoft Access 2000 or an earlier version installed, if you use Windows Explorer or a shortcut to open a file that was created in Access 2000 or in an earlier... |
| 21862 | When you try to evaluate an input parameter in a function that is referenced in the RecordSource property of a form, the InputParameter property is properly populated. However, you receive the following error message when you open the form and |
| 21863 | After you convert an Access 2000 replica set from the Access 2000 file format to the Access 2002 file format, some replica set members contain both an MSysAccessObjects table and an MSysAccessStorage table. |
| 21864 | The Maximum Records command on the Records menu of a form is not affected when you set the MaxRecButton property of a form. For example, when you set the MaxRecButton property of the form to No , the MaximumRecords command on the Records menu is still... |
| 21865 | In a Microsoft Access project, when you create a stored procedure and open it in Datasheet view, you expect Datasheet view to display the rows that are to be affected when you actually run the stored procedure. Instead, the stored procedure is |
| 21866 | When you attempt to programmatically delete a record in a data access page that is bound to Extensible Markup Language (XML), you may not receive a message that this operation is not permitted. Instead, it appears that you have deleted a record,... |
| 21867 | When you open a table in Datasheet view, the New Record line displays #Error instead of its default value as expected. |
| 21868 | In the PivotTable View of a table, you can create and format captions for the different data drop areas to assist users in displaying data as they would like to see it in a PivotTable. The areas to which you can assign captions are: Filter drop |
| 21869 | When you run Microsoft Access on a computer that is running Microsoft Windows Millennium Edition (Me) or Microsoft Windows 98, you receive the following error message when you try to print or modify a report: There was a problem retrieving printer... |
| 21870 | In the Expression Builder or Zoom dialog box, if you right-click to open the shortcut menu, the shortcut menu does not appear. |
| 21871 | When you view a form in PivotTable view or PivotChart view, some fields are not displayed in the PivotTable or PivotChart field list. |
| 21872 | When you save a form or a report to a data access page by using the OutputTo macro action or method, there are problems with the resulting page. These problems include: The script validation to verify the browser or Office Web |
| 21873 | When you add a new record to a Microsoft Access project (.adp) table, and the primary key identity column has an increment value of 2 or more, the value in the primary key column appears to be incremented only by 1 until you save the record. When you... |
| 21874 | When you double-click a Microsoft Access database or project file (MDB or ADP) in Microsoft Windows Explorer, the file does not open as expected. Instead, the focus returns to an existing instance of Access. |
| 21875 | When you open a table in a Microsoft Access project in Datasheet view, you may receive the following error message: The setting you entered isn't valid for this property. To see the valid settings for this property, search the Help index for the name... |
| 21876 | When you are working offline with a data access page that is bound to XML, the page is updateable, even though it should be read-only. You may also notice that the UseXMLData property of the DataSourceControl still returns True after the page |
| 21877 | When you create a query (whether it is a function, a view, or a stored procedure) based on a one-to-many relationship between two tables, and then you edit data in one record of the primary table (the one side), the changes are not propagated as |
| 21878 | When you open a linked Oracle 8i table and leave the database inactive for long periods of time, you receive the following error message, and then Access quits: Microsoft Access has encountered a problem and needs to close. We are sorry for any |
| 21879 | When you edit the PivotTable or PivotChart view of a Microsoft Access form, either manually or through code, Microsoft Access does not prompt you to save the changes when you close the form. Instead, Microsoft Access automatically saves any manual... |
| 21880 | When you import tables from a Microsoft Access project (*.adp), previously saved PivotTable and PivotChart views are not preserved as expected. |
| 21881 | When you attempt to create a new database diagram in a Japanese Microsoft Access project, the Japanese characters in the table name and the field names are displayed as boxes. |
| 21882 | When you use a Microsoft Visual Basic for Applications (VBA) procedure to seek matching numerical values in a table, Microsoft Access quits unexpectedly when you run the procedure. |
| 21883 | When you manipulate images in the Employees form in the sample database Northwind.mdb, the images may appear brown and patchy, or they may reappear after being deleted. |
| 21884 | When you are using the Convert Database utility to convert a workgroup information file (.mdw file) that was created in Microsoft Access 95 or Microsoft Access 97 to Microsoft Access 2002, you receive the following error messages: Record(s) cannot be... |
| 21885 | In Microsoft Access, after you set the Recordset property of a list box or combo box, the list is empty after you change between form views (such as Datasheet view, PivotTable view, or PivotChart view). |
| 21886 | When you use a stored procedure to query a table with a field formatted as Euro, the format of the output is unexpectedly converted to Currency. |
| 21887 | When you run a query that requires criteria to be entered, the field name for which the criteria is required in the Enter Parameter Value dialog box is displayed with square brackets, as it appears in the query design grid. |
| 21888 | When you view a table or query in PivotTable or PivotChart view and then save it as a data access page, the PivotChart toolbar is not displayed on the page as expected. |
| 21889 | When you add a new record in a data access page that contains an object with a ControlSource property that is a field with a default value, the default value does not appear in the new record as expected. Additionally, the DefaultValue |
| 21890 | In Design view, changes to the Printer properties are automatically saved with a form if the form is saved before it is closed. Conversely, although changes made in Browse view or Print Preview should not be saved, these changes may, in fact, be |
| 21891 | When you set any of the print margins of a form (such as left, right, top, or bottom) to 0 (zero) in a Microsoft Access database or project, Access may not accept that value, and may change the margin to a value greater than 0 without alerting the |
| 21892 | When you import data from an Excel spreadsheet into an Access database, dates in long date format, such as January 1, 2000; or medium date format, such as 1-Jan-2000, lose formatting and are displayed as short dates, such as 01-01-2000. |
| 21893 | In Microsoft Access, the borders of the controls on a data access page may not be affected by Special Effects (border style) settings. You may notice this behavior when you work with rectangles or labels. |
| 21894 | If you save a bound form or a bound report as a data access page, you may notice that the resulting page is not bound, and #Name? is displayed in all the bound controls. |
| 21895 | If you are working with XML data in Access in the user interface or in the Visual Basic Editor (VBE), you may notice that certain features are not available even though they are documented in the Access 2002 Help system. The following Help topics are... |
| 21896 | This article demonstrates how to use ActiveX Data Objects (ADO) and OLE DB to find records in a Microsoft Jet database . |
| 21897 | At times, you may need to transpose the data in a table or query so that the field names are listed vertically down the left column and the data extends across the page horizontally. For example, you may need to transpose the data for a report or |
| 21898 | This article explains database normalization terminology for beginners. A basic understanding of this terminology is helpful when discussing the design of a relational database. NOTE : Microsoft also offers a WebCast that discusses the basics of... |
| 21899 | If you try to import, export, or link a file by using an indexed sequential access method (ISAM) driver, you may receive an error message if Microsoft Access cannot find the ISAM driver. |
| 21902 | In the products listed at the beginning of this article, the Help topic Turn on or off transparent floating toolbars is incorrect. The topic states the following: Turn on or off transparent floating toolbars On the View menu, point to Toolbars , and... |
| 21903 | If you change data in an XML file to which a data access page is bound, requerying the page through script does not show the updated data. You may see this behavior if the page is bound at run time or by using the user interface. |
| 21904 | In most Microsoft Access objects, such as forms and reports, you can use a domain function to easily retrieve data from sources other than the record source of the object. Domain functions are intrinsic functions built into Microsoft Access. Because... |
| 21905 | This article discusses the causes of fatal system errors in Microsoft Access 2002 running on Windows Millennium Edition (Windows Me), and provides general troubleshooting steps for solving them. NOTE: This is a general article and |
| 21906 | When you click the File menu to choose a file from the most recently used file list, the most recently used file list is missing. When you click Options on the Tools menu and then click the General tab, you see that the Recently used file list check... |
| 21907 | When you click the Edit menu in Design view of a data access page, you receive the following error message, and then Access quits: Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience. Microsoft |
| 21908 | This article demonstrates how to create script that filters a data access page by setting the ServerFilter property. You can use this script even when the page is not stored on a Web server. |
| 21909 | When you import an XML document, at least one blank table is imported or not all of the data is imported. Depending on the structure of the XML document, more than one table may actually be imported. |
| 21910 | If you use the right mouse button to drag a table from the field list to the data access page, and you try to add the table above another section that has a caption, all of the choices on the shortcut menu are unavailable, and you cannot add the table. |
| 21911 | Access 2002 introduces a new feature that allows you to work with data access pages offline. This feature is useful when you are unable to connect to your network, but still need access to data. Offline data access pages may be updateable if you use |
| 21912 | This article shows you how to find a record in a data access page based on an entry that you select from a drop-down list. |
| 21913 | When you attempt to upsize your database, you may receive an error message similar to the following: Server Error 134: The variable name '@Forms......' has already been declared. Variable names must be unique within a query batch or stored procedure.... |
| 21914 | When you try to create an Update query that updates the values in one table with values from another table, the process cannot be completed because the source table disappears from the query grid. |
| 21915 | In Microsoft Access, when you set the focus to a subform in PivotTable or PivotChart view, the appropriate Pivot toolbars do not appear as expected. |
| 21916 | When you create a new Microsoft Access 2002 database or project, you find that the database references the ActiveX Data Objects (ADO) 2.1 library, instead of a newer version of this library. |
| 21917 | There appears to be no immediate effect when you programmatically set the ANSI Query Mode property. |
| 21918 | When you start Microsoft Access, the focus is on the task pane rather than on the main menu bar. As a result, the mouse pointer is not able to select the menu headings. |
| 21919 | When you run a Microsoft Office XP program, the file Ctfmon.exe (Ctfmon) runs in the background, even after you quit all Office programs. This article answers some of the frequently asked questions about the Microsoft Text Services Ctfmon.exe file,... |
| 21920 | Microsoft Visual Basic Help in Access 2000 states that the TextAlign property applies to list box controls. This property has been removed for list boxes in Access 2002 and is no longer valid for this control. The TextAlign property still |
| 21921 | When you try to omit fields from an export specification in the Export Text Wizard, you may receive the following error message: The number of fields in your export specification does not match the number in the table you have chosen to export. |
| 21922 | This article lists the references that you must set when you are working with databases that you create in Microsoft Access or when you access information in Microsoft Access databases from other applications. The following topics are covered in this... |
| 21923 | When you create an application, it is good design practice to limit the number of records brought over a network from a database server to the client computers. When you use an Access 2002 project (.adp), Access uses several methods behind the scenes |
| 21924 | In Access 2002, you can bind a data access page to XML embedded in the page or to an external XML file. Embedded XML is also referred to as an XML data island. If you open a page that is bound to a large XML data island, it may take a while for the |
| 21925 | When you try to customize toolbars or open a Microsoft Access form, report, macro, or module in Design view, you receive the following message: You do not have exclusive access to the database at this time. If you proceed to make changes, you may |
| 21926 | Microsoft Access can import or link data from other Microsoft Access databases (version 2.0, 7.0/95, 8.0/97, 9.0/2000, 10.0/2002), as well as data from other programs and file formats, such as Microsoft Excel, dBASE, Paradox, or XML (import only). You... |
| 21927 | This step-by-step article describes how to display or hide the Ask a Question box in Microsoft Office XP programs. The Ask a Question box is a new feature of Office XP that allows quicker access to Help topics. This box is located in the upper-right... |
| 21928 | The Reldes.doc Word document shows you how to plan and design a database from the ground up. For practical examples, it uses the database design of the Northwind Traders sample database included in Microsoft Access 2002. |
| 21929 | Microsoft Office XP offers a new, easy-to-use, crash-reporting tool called Application Error Reporting. If a Microsoft Office program crashes, the Application Error Reporting dialog box appears and requests your permission to send a detailed report of... |
| 21930 | There are several things that can happen, both inside and outside of Access, that may leave your database file damaged (corrupted). The symptoms of a corrupted database can range from #Deleted appearing in certain records, to you being unable to open |
| 21931 | When you start Microsoft Access, you may receive the following error message: Microsoft Access can't change the working directory to Microsoft Access can't change the working directory to where is the path that appears as the default |
| 21934 | A data access page is an HTML page that has an Office Web Component embedded into it. The Office Web Component stores connection information about a data source. This article describes how to use data access pages to connect an HTML page to tables in... |
| 21935 | In the Office XP programs listed at the beginning of this article, you can control whether the user sees a list of recently used documents on the File menu and how many file names are displayed in the list. This list is technically referred to as the... |
| 21936 | When you copy or import a table in a Microsoft Access project (.adp), the new table is created, but no data is copied to the new table, and the primary key may not have been created. Depending on the size of the table, you may also receive the... |
| 21937 | When you open one of the Microsoft Office programs listed at the beginning of this article, the program may open slowly. |
| 21938 | This step-by-step article describes how to call Office macros from a Visual C# .NET Automation client. You can use Microsoft Office Automation to open a document or create a new document that contains a Visual Basic for Applications (VBA) macro and... |
| 21939 | When you try to open a Microsoft Access table from the Database window, you receive the following error message: |
| 21940 | This article shows you two methods that you can use to programmatically convert Microsoft Access databases. The first method uses the ConvertAccessProject method to convert databases to the format that you specify. The second method uses the Shell... |
| 21941 | When you use a Microsoft Access or Microsoft FoxPro database in a Word document (for example, a Word mail merge), pictures in the database do not appear. |
| 21942 | When you install any of the Office products listed at the beginning of this article, you may receive an error message similar to the following: Internal Error 2889: Please contact product support for assistance. |
| 21943 | When you run Setup for Office, you may receive an error message similar to the following: |
| 21944 | After Microsoft Office has been installed, you can use the Setup program to reinstall your original Office configuration or to add or remove (install or uninstall) a single program or component of a program. |
| 21945 | With Microsoft Office Automation, you can open a document or create a new document that contains a Visual Basic for Applications (VBA) macro and execute the macro at run time. This article demonstrates how to call Office macros from a Visual C++ .NET... |
| 21946 | This article lists the minimum security settings that are required to connect to a remote Microsoft Access database from ASP.NET, including: Windows NT File System (NTFS) settings Microsoft Internet Information Services (IIS) settings Local security... |
| 21947 | When timing code to identify performance bottlenecks, you want to use the highest resolution timer the system has to offer. This article describes how to use the QueryPerformanceCounter function to time application code. |
| 21948 | This article describes how to completely remove Microsoft Office 2000 from your computer. This article includes files installed from CD1 and does not apply to other compact discs included with your edition of Microsoft Office 2000. |
| 21949 | Developers can use Automation to Microsoft Office to build custom solutions that utilize the capabilities and features that are built into the Office product. While such programmatic development can be implemented on a client system with relative... |
| 21950 | When you install Microsoft Office 2000, the following error message appears: |
| 21951 | When you uninstall Microsoft Access or Microsoft Office, the System.mdw file and the sample databases are removed, even if you have made changes to these files. |
| 21952 | When you start one of the Office programs, the following symptoms may occur: |
| 21953 | When you run Microsoft Office 2000 Setup, you may not see any dialog boxes where you can enter information or make Setup selections, and the only dialog box displayed is a |
| 21954 | When you install Office 2000, the following error message may appear: |
| 21955 | When you install Office 2000, you do not see the following features displayed in the |
| 21956 | When you run repair on your Microsoft Office XP installation, you may receive the following error message: |
| 21957 | This step-by-step article discusses how to use the object models for Office applications to avoid dialog boxes during Automation. It also provides an example of how to simulate user input to programmatically dismiss a dialog box that cannot be avoided... |
| 21958 | In many of the programs listed at the beginning of this article, you can prevent unauthorized users from opening a file by applying a password to the file. When you attempt to open the file, the program requests the password; if you do not enter the... |
| 21959 | If you want to troubleshoot a problem with your printer driver, try printing with a different printer driver. If you determine that the problem does not occur when you use a different driver, you may need to update or reinstall the original printer... |
| 21960 | When you upgrade from an earlier version of Microsoft Office 97 or Microsoft Office 2000 to Microsoft Office XP, you may experience the following symptoms: |
| 21961 | When you install Microsoft Office XP, if you click |
| 21962 | Microsoft has created the Windows Installer CleanUp Utility, which allows you to safely remove Windows Installer-related registry settings from your computer in the event of a problem. |
| 21963 | When you start one of the Microsoft Office XP programs for the first time, Windows Installer may start, and you are prompted to restart your computer. When you click |
| 21964 | This article describes how you can determine the exact version of your Microsoft Office XP product. |
| 21966 | When you automate an application such as a Microsoft Office application, the calls to the properties and methods of the Office application's objects must be connected in some way to those objects. The process of connecting property and method calls to... |
| 21967 | This article describes the resources and documentation available to you for automating Microsoft Office applications. This information can be applied regardless of the programming language you choose for automating an Office application. Th |
| 21968 | Microsoft has created new Paradox and dBASE ISAM drivers for Microsoft Jet 4.0 that do not require the installation of the Borland Database Engine (BDE) to provide full read/write access to Paradox and dBASE files. The current Jet 4.0-based Paradox... |
| 21969 | This article lists some of the resources available on the Microsoft World Wide Web site that can help you get the answers you need to questions about Microsoft Access. |
| 21970 | This article shows you how to use the |
| 21971 | If you try to gain access to an Access 2000 or Access 2002 database, you may receive one of the following errors within your Visual Basic program. If you are using Microsoft ActiveX Data Objects (ADO) (or the ADO Data Control), you receive the... |
| 21972 | Incorrect CREATE TABLE statements are created when Microsoft Jet database engine 4.0 exports tables through ODBC drivers that do not require identifier quote characters. If an ODBC trace is generated, a you see a statement similar to the following:... |
| 21973 | When you are automating an Office application from Visual Basic .NET, the Office application may display a dialog box. The dialog box causes the Visual Basic .NET application to appear to stop responding (hang) because the Visual Basic .NET... |
| 21974 | When you try to change the properties of your printer from one of the Microsoft Office XP programs listed at the beginning of this article, you may receive an error message similar to the following Microsoft program name has encountered a problem and... |
| 21975 | When you install one of the Office XP programs listed at the beginning of this article, or you upgrade one of the listed programs to Office XP Service Pack 1, and Norton SystemWorks is installed on your computer, the Office XP program may n |
| 21976 | When you attempt to link tables to the current Microsoft Access project (.adp), the |
| 21977 | This article describes how to use the HTML document object model to determine if a data access page is open in Microsoft Access or Microsoft Internet Explorer. |
| 21978 | An unhandled exception may occur under the following circumstances: |
| 21979 | When you open a form in browse mode, and then run any code on that form, you may receive the following error message |
| 21980 | When you view your database or project in the Database window, you may notice that your database object names appear underlined. |
| 21981 | When Office XP is distributed to many users as part of a hard disk image, those users should not have to activate the product. However, the first time that a user starts an Office program that was installed in this way, they may be prompted to... |
| 21982 | The information covered in this article is provided by: Microsoft Press . This article is part 6 of a series of eight articles that explain how to keep your information in Access accurate. To view the other articles in this series, please see the... |
| 21983 | The information covered in this article is provided by: Microsoft Press . This article is part 7 of a series of eight articles that explain how to keep your information in Access accurate. To view the other articles in this series, please see the... |
| 21984 | The information covered in this article is provided by: |
| 21985 | When you install Microsoft Office XP Developer Edition Service Pack 1 (SP-1), Service Pack 1 does not update the Access 2002 run-time components to the SP-1 level. Also, this service pack does not upgrade Access 2002 run-time applications t |
| 21986 | The information covered in this article is provided by: |
| 21987 | The information covered in this article is provided by: |
| 21988 | The information covered in this article is provided by: |
| 21989 | The information covered in this article is provided by: |
| 21990 | The information covered in this article is provided by: |
| 21991 | When you try to use GetObject or System.Runtime.InteropServices.Marshal.GetActiveObject from Microsoft Visual Basic .NET to automate a running Microsoft Office application, you may receive one of the following error messages: With GetObject : Cannot... |
| 21992 | This step-by-step article describes how to call Office macros from a Visual Basic .NET Automation client. You can use Microsoft Office Automation to open a document or create a new document that contains a Visual Basic for Applications (VBA) macro and... |
| 21993 | Changing the installation state of a program after it is installed on a user's computer is easier in Microsoft Office XP than in Microsoft Office 2000. By using the Custom Maintenance Wizard and the Office Profile Wizard in Office XP, you c |
| 21994 | When you click a hyperlink in a Microsoft Office document in an Office program, you may receive an error message similar to the following: This operation has been canceled due to restrictions on this computer. Please contact your system administrator. |
| 21995 | This article shows you how to use ActiveX Data Objects (ADO) to access the RecordsetDefs object of a data access page and to list its contents. |
| 21996 | There are a number of reasons corruption can occur in a Microsoft Access database. This article provides a list of references to Microsoft Knowledge Base articles that may assist you in resolving corruption in your database. |
| 21997 | This article shows you how to access the |
| 21998 | This article shows you how to programmatically create a table and to specify the display control for a field. The sample code in this article creates the following table in the Northwind sample database: |
| 21999 | In Microsoft Access (and other Microsoft Office applications), you can use the Shell command in Visual Basic for Applications (VBA) code to start another application. Although you can start most applications in this manner, the Shell command does not... |
| 22000 | This article presents the guidelines that Microsoft Product Support Services (PSS) support professionals follow when supporting Microsoft Access customers and also lists support options available for Microsoft Access. |
| 22001 | When you run the Setup program for Microsoft Office XP, you receive the following error message: |
| 22002 | When you install Office XP, you may receive one of the following error messages: |
| 22003 | This article shows you how to create an SQL pass-through query in Microsoft Visual Basic for Applications (VBA) with Microsoft ActiveX Data Objects (ADO). |
| 22004 | In Reduced Functionality mode, the Microsoft Office Activation Wizard is displayed. It lists Microsoft Access 2002 Runtime . This suggests that the Runtime version has to be activated. |
| 22005 | This article describes how to repair a damaged Microsoft Access database when the database cannot be recovered using the methods described in the following article |
| 22006 | This step-by-step article describes how to reset a menu in a Microsoft Office program back to its default first-run condition. In addition, this article describes the following: What the Personalized Menus and Toolbars feature is. Two methods for... |
| 22007 | You cannot update data in a view in a Microsoft Access project (ADP). |
| 22008 | This article describes how you can use Data Access Objects (DAO) to import all objects from one Microsoft Access database into the current Access database. In some situations, this code can be used to recover database objects from a corrupt |
| 22009 | If you have a procedure that contains a Visual Basic for Applications function and your database contains a reference to a missing object library or type library, you may receive one of the following error messages when you compile your mod |
| 22010 | When you try to link or embed a Word document, you may receive one of the following error messages: |
| 22011 | When you delete a Microsoft Access database object that is under Source Code control, and you then recover the object by using Visual SourceSafe Explorer, when you click Get Latest Version or Check Out , the object is not made available in the Access... |
| 22012 | You are using the Expression Builder to create an expression for an event property. The expression that you create is between 1,024 and 2,048 characters long. When you then do one of the following you click OK in the Expression Builder -or- you move... |
| 22013 | When you turn off the |
| 22014 | This article describes how to install Microsoft Office 2000 on a computer that is configured to start between Microsoft Windows NT and Microsoft Windows 98 (or Microsoft Windows 95). |
| 22015 | When you attempt to install one of the programs listed at the beginning of this article, your may receive the following error message Error file name GFVXD(01) + 00002F13 Error: OE:0028:C15E2953 installing program where program is the name of the... |
| 22017 | Use this step-by-step guide to set up an installation that chains the Multilingual User Interface (MUI) Pack to the core Office XP installation. Chaining is particularly useful for adding individual MUI Packs to the core Office XP installa |
| 22018 | After you click the Advanced button in the Text Import/Export Wizard to display the Specification dialog box, you notice that the Save As and Specs buttons are not available. |
| 22019 | When you use Microsoft Access, you receive the following error message: |
| 22020 | Advanced: Requires expert coding, interoperability, and multiuser skills. By using API calls in Visual Basic for Applications, you can programmatically hide the Microsoft Windows 98 or Microsoft Windows NT 4.0 taskbar. This article shows you how to... |
| 22021 | When you receive an error message in any Microsoft Office program, the customizable alert button may be missing. |