| 22023 | Issues that you may encounter when you open or are using a Microsoft Office Access database on a computer that is running Windows Vista |
| 22024 | Description of the Office 2003 post-Service Pack 2 hotfix package for Office 2003 Proofing Tools: March 12, 2007 |
| 22025 | Description of the Office 2003 post-Service Pack 2 hotfix package for the Italian thesaurus and for the Italian MUI: March 9, 2007 |
| 22027 | Description of the Office 2003 post-Service Pack 2 hotfix package for the Office 2003 proofing tools: February 21, 2007 |
| 22028 | Description of the Office 2003 post-Service Pack 2 hotfix package for the Italian version of Office 2003: March 1, 2007 |
| 22029 | Description of the Office 2003 post-Service Pack 2 hotfix package for the Italian MUI and for the Italian proofing tools: February 21, 2007 |
| 22030 | Description of the Office 2003 post-Service Pack 2 hotfix package for the Italian thesaurus, for the Italian MUI, and for Office 2003 Proofing Tools: March 6, 2007 |
| 22031 | The words Friendster, Klum, Nazr, Obama, and Racicot are not recognized when you check the spelling of English-language text in the Office 2003 programs |
| 22032 | 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 |
| 22033 | Description of the Office 2003 post-Service Pack 2 hotfix package: February 12, 2007 |
| 22034 | Plot lines that contain labels disappear when you edit a Microsoft Excel chart or a Microsoft Graph chart in an Office 2003 program |
| 22035 | Description of the Office 2003 post-Service Pack 2 hotfix package: January 26, 2007 |
| 22036 | Description of the Office 2003 post-Service Pack 2 hotfix package: January 30, 2007 |
| 22037 | Description of the Access 2003 post-Service Pack 2 hotfix package: January 26, 2007 |
| 22038 | Description of the security update for Office 2003: February 13, 2007 |
| 22039 | Description of the security update for Office 2003, for Project 2003, and for Visio 2003: February 13, 2007 |
| 22040 | 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 |
| 22041 | 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 |
| 22042 | Description of the Access 2003 post-Service Pack 2 hotfix package: January 3, 2007 |
| 22043 | Description of the Office 2003 post-Service Pack 2 hotfix package: January 4, 2007 |
| 22044 | MS07-001: Vulnerability in Microsoft Office 2003 Brazilian Portuguese Grammar Checker that could allow remote code execution |
| 22045 | You receive an out of memory error message in Access 2003 and Access 2002 when you use grouped controls |
| 22046 | 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 |
| 22047 | Description of the update for Office 2003: December 12, 2006 |
| 22048 | Description of the Access 2003 post-Service Pack 2 hotfix package: October 17, 2006 |
| 22049 | 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 |
| 22050 | Description of the Jet 4.0 Database Engine post-837001 hotfix package: April 12, 2005 |
| 22051 | Description of the Office 2003 post-Service Pack 2 hotfix package: October 23, 2006 |
| 22052 | Description of the Office 2003 post-Service Pack 2 hotfix package: October 11, 2006 |
| 22053 | Description of the update for Office 2003: November 14, 2006 |
| 22054 | Description of the update for Office 2003: October 10, 2006 |
| 22055 | Description of the security update for Office 2003: October 10, 2006 |
| 22056 | MS06-062: Vulnerabilities in Office could allow remote code execution |
| 22057 | A .tif file or a .tiff file unexpectedly opens in Microsoft Office Document Imaging |
| 22058 | Description of the security update for Office 2003: October 10, 2006 |
| 22059 | The icon is blank when you insert an object or a file into a document, presentation, spreadsheet, or other Microsoft Office file |
| 22060 | Description of the Office 2003 post-Service Pack 2 hotfix package for Office 2003, for Project 2003, and for Visio 2003: September 13, 2006 |
| 22061 | Description of the Office 2003 post-Service Pack 2 hotfix package for the Dutch proofing tools and for the Dutch Multilingual User Interface Pack in Office 2003, in Project 2003, and in Visio 2003: September 8, 2006 |
| 22062 | Description of the Access 2003 post-Service Pack 2 hotfix package: August 14, 2006 |
| 22063 | Description of the Office 2003 post-Service Pack 2 hotfix package: July 26, 2006 |
| 22064 | Description of the Jet 4.0 Database Engine post-837001 hotfix package: May 11, 2006 |
| 22065 | Description of the security update for Office 2003: August 8, 2006 |
| 22066 | Description of the Office 2003 post-Service Pack 2 hotfix package for the Dutch proofing tools and the Dutch Multilingual User Interface Pack in Office 2003, in Project 2003, and in Visio 2003: March 28, 2006 |
| 22067 | All the fields of a record display #Delete when you copy and paste a record that contains a Null field in Office Access 2003 |
| 22068 | Description of the Office 2003 post-Service Pack 2 hotfix package: July 3, 2006 |
| 22069 | Office 2003 icons appear fuzzy or have poor contrast after you change the DPI setting in Windows to Large size (120 DPI) |
| 22070 | Description of the Office 2003 post-Service Pack 2 hotfix package: July 17, 2006 |
| 22071 | Description of the Access 2003 post-Service Pack 2 hotfix package: June 26, 2006 |
| 22072 | Description of the security update for Office 2003, for Project 2003, and for OneNote 2003: July 11, 2006 |
| 22073 | Description of the security update for Office 2003: July 11, 2006 |
| 22074 | MS06-038: Vulnerabilities in Microsoft Office could allow remote code execution |
| 22075 | Error message when you use Access 2003 to open a database file: Error 1706. No valid source could be found |
| 22076 | You cannot open Access report snapshot (.snp) files in Internet Explorer after you install Windows XP Service Pack 2 |
| 22077 | You cannot use can the MSOLAP provider name to reference the Analysis Services 9.0 OLE DB Provider after you install or repair an Office 2003 program |
| 22078 | Description of the Office 2003 post-Service Pack 2 hotfix package: April 24, 2006 |
| 22079 | A file does not open in the program that you expect when you try to open the file in Office |
| 22080 | Description of the Office 2003 hotfix package: April 5, 2006 |
| 22081 | Description of the Office 2003 post-Service Pack 2 hotfix package: April 17, 2006 |
| 22082 | Description of the Access 2003 post-Service Pack 2 hotfix package: April 18, 2006 |
| 22083 | Description of the Office 2003 post-Service Pack 2 hotfix package: April 26, 2006 |
| 22084 | Description of the Office 2003 post-Service Pack 2 hotfix package: April 21, 2006 |
| 22085 | You are prompted for credentials every two weeks when you try to view a Web resource in Office 2003 |
| 22086 | Description of the Access 2003 post-Service Pack 2 hotfix package: April 18, 2006 |
| 22087 | Error message when you use an .odc file to connect to a specific table in a mail merge data source in Office 2003: Record 'number' contained too few data fields |
| 22088 | Description of the Office 2003 post-Service Pack 2 hotfix package: April 12, 2006 |
| 22089 | Description of the Office 2003 post-Service Pack 2 hotfix package: April 5, 2006 |
| 22090 | Error message when you use Office Genuine Advantage to validate Office 2003 or Office XP: Validation Incomplete or Error code: 0x8018103 |
| 22091 | Relative hyperlinks are changed and no longer work correctly in a file that is saved in Office 2003 |
| 22092 | Error message when you try to validate Office 2003 or Office XP by using Office Genuine Advantage: Unable to Validate or Error code: 0x8018111 |
| 22093 | Error message when you use Office Genuine Advantage to validate Office 2003 or Office XP: Validation Incomplete or Error code: 0x8018101 |
| 22094 | Error message when you use Office Genuine Advantage to validate Office 2003 or Office XP: Validation Incomplete or Error code: 0x8018110 |
| 22095 | 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 |
| 22096 | You receive an error message when you start Visual Basic for Applications code in an Access database |
| 22097 | Description of the Office 2003 post-Service Pack 2 hotfix package: April 12, 2006 |
| 22098 | 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 |
| 22099 | #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 |
| 22100 | 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 |
| 22101 | Description of the Office 2003 post-Service Pack 2 hotfix package: February 27, 2006 |
| 22102 | Description of the updates for Office 2003: March 14, 2006 |
| 22103 | Description of the Office 2003 post-Service Pack 2 hotfix package: February 24, 2006 |
| 22104 | Error message when you try to repair, reinstall, or add a component to an Office 2003 program and you use a Local Installation Source: Installation Error: File Not Found |
| 22105 | The installation of an update for an Office 2003 program may not be completed successfully after you run the Disk Cleanup tool |
| 22106 | Description of the Office 2003 post-Service Pack 2 hotfix package for the Portuguese (Brazilian) version of Office 2003: February 1, 2006 |
| 22107 | Description of the Security Update for Office 2003: February 14, 2006 |
| 22108 | Description of the Access 2003 post-Service Pack 2 hotfix package: January 24, 2006 |
| 22109 | Access 2003 may not start as expected after you install Office 2003 SP2 |
| 22110 | Jet 4.0 data engine update fixes issues that may occur on a Windows XP-based computer |
| 22111 | Description of the Access 2003 post-Service Pack 2 hotfix package for the Swedish version of Microsoft Office Access 2003: January 10, 2006 |
| 22112 | You cannot access Microsoft Office Online from a Microsoft Office 2003 program |
| 22113 | Description of the Office 2003 post-Service Pack 2 hotfix package: January 11, 2006 |
| 22114 | Description of the Office 2003 post-Service Pack 2 hotfix package: January 18, 2006 |
| 22115 | The plus sign (+) may not appear when you try to click the plus sign (+) to drill down into the related records of a child table in Office Access 2003 |
| 22116 | The first lines or the last lines of some report pages may not appear or may be truncated in Access 2003 |
| 22117 | Description of the Microsoft Office 2003 post-Service Pack 2 hotfix package: December 8, 2005 |
| 22118 | Description of the Dutch Multilingual User Interface Pack for Office 2003 post-Service Pack 2 hotfix package: December 15, 2005 |
| 22119 | Description of the Office 2003 post-Service Pack 2 hotfix package: December 6, 2005 |
| 22120 | Description of the Office 2003 post-Service Pack 2 hotfix package: December 19, 2005 |
| 22121 | Error message when you try to view or print a report in Access 2003: Error 2501 The Open Report Action was canceled |
| 22122 | Description of the Office 2003 post-Service Pack 2 hotfix package: December 16, 2005 |
| 22123 | An Office 2003 program unexpectedly quits with an unrecoverable error when the program is started by another program that is running under a non-interactive account |
| 22124 | Description of the Office 2003 post-Service Pack 2 hotfix package: December 15, 2005 |
| 22125 | Description of the Office 2003 post-Service Pack 2 hotfix package for the Brazilian version of Office 2003: December 7, 2005 |
| 22126 | Description of the Microsoft Office 2003 post-Service Pack 2 hotfix package: November 22, 2005 |
| 22127 | Description of the Office 2003 post-Service Pack 2 hotfix package: December 2, 2005 |
| 22128 | Description of the Dutch spelling checker for the Dutch version of Office 2003 post-Service Pack 2 hotfix package: December 9, 2005 |
| 22129 | Description of the Office 2003 post-Service Pack 2 Proofing Tools Kit for the Dutch spelling checker hotfix package: November 23, 2005 |
| 22130 | Description of the Office 2003 post-Service Pack 2 hotfix package: December 2, 2005 |
| 22131 | The security level is reset to its original level after a user changes the security level in an Office 2003 program |
| 22132 | Error message when you try to open an Office 2003 file from an FTP site in Internet Explorer: Could not open URL |
| 22133 | Description of the Microsoft Office 2003 post-Service Pack 2 hotfix package: November 15, 2005 |
| 22134 | Describes the Word was unable to open the data source error message. You may receive this error message when you mail merge to Word by using an Access parameter query. |
| 22135 | You cannot embed an Adobe OpenType font in a document that is in an Office program |
| 22136 | How to troubleshoot video issues in Office programs |
| 22137 | You cannot change, add, or delete data in tables that are linked to an Excel workbook in Office Access 2003 or in Access 2002 |
| 22138 | You receive an Unable to open URL error message when you try to access the Office Online Web site in an Office 2003 program |
| 22139 | When you try to install Office 2003 Service Pack 2, you receive a The upgrade patch cannot be installed by the windows installer service error message, or the Setup program may not be completed, and you do not receive notification |
| 22140 | Issues that are fixed in Access 2003 by Office 2003 Service Pack 2 |
| 22141 | The fixes that are included in Office 2003 Service Pack 2 that require a registry key |
| 22142 | Description of Office 2003 Service Pack 2 |
| 22143 | You cannot update the data in a view that you created in Office Access 2003 |
| 22144 | 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 |
| 22145 | You are unexpectedly prompted to restart the computer after you install an Office service pack or an Office update |
| 22146 | Describes the error message that you may receive when you try to activate Office 2003. |
| 22147 | Description of Photo Editor support with Office 2003 programs |
| 22148 | How to perform a chain installation of Office 2003 and Office 2003 updates |
| 22149 | 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 |
| 22150 | A record in a linked SQL Server 2000 database table is not correctly updated when you modify the record in an Access 2003 database table |
| 22151 | When you create a database or a table, an error occurs and Access unexpectedly closes in Office Access 2003 or in Access 2002 |
| 22152 | Custom changes that you made in the HKEY_CLASSES_ROOT subtree are overwritten after you update or repair the Office installation |
| 22153 | Office updates are not successfully installed on some client computers when you deploy updates by using Windows Server Update Services |
| 22154 | You receive an Error 80070643 error message when you try to update Office 2003 by using Software Update Services |
| 22155 | 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 |
| 22156 | How to troubleshoot problems that you may experience when you try to activate an Office product |
| 22157 | Description of the Microsoft Office 2003 Web Components post-Service Pack 1 hotfix package: April 28, 2005 |
| 22158 | The Office 2003 spelling checker incorrectly identifies the word Iqaluit as misspelled |
| 22159 | Description of the Microsoft Office 2003 post-Service Pack 1 hotfix package: Date October 15, 2004 |
| 22160 | The Microsoft Office 2003 Service Pack 1 (SP1) white paper for Microsoft Office 2003 is available |
| 22161 | 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. |
| 22162 | Describes an error message that you may receive when you start an Office 2003 program. |
| 22163 | Discusses a problem in Windows XP where you experience poor performance when you append records to a shared database that is located on a file server. You must add a registry subkey, verify the Shell32.dll file version, and then apply a hotfix. |
| 22164 | Text that uses umlaut characters may not correctly import in Office Access 2003 |
| 22165 | The Script Editor unexpectedly quits when you use the Script Editor for the first time in an Office program |
| 22166 | 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 |
| 22167 | Description of the Access 2003 post-Service Pack 1 hotfix package: April 28, 2005 |
| 22168 | Description of the Office 2003 post-Service Pack 1 hotfix package: April 28, 2005 |
| 22170 | Description of the Microsoft Office Access 2003 post-Service Pack 1 hotfix package: March 26, 2005 |
| 22172 | The Office 2003 Setup program unexpectedly quits, and you do not receive an error message |
| 22173 | Describes a problem where the Office Assistant starts in Office 2003 and the animations for the assistant are turned on after you click to clear the Menu and window animation check box in Remote Desktop Connection in Windows Server 2003. |
| 22174 | Describes the Microsoft Office Access 2003 issues that are fixed in the French version of the Access 2003 post-Service Pack 1 hotfix package that is dated September 30, 2004. |
| 22175 | Describes the Access 2003 issue that is fixed in the Access 2003 post-Service Pack 1 hotfix package that is dated November 1, 2004. |
| 22176 | You may receive a The OLE server may not be registered error message when you try to create a blank data access page in Access 2002 or Office Access 2003 |
| 22177 | Describes the problem where hyperlinks in Office 2003 documents to Adobe Acrobat PDF files do not work. |
| 22178 | Describes the Office 2003 Primary Interop Assemblies (PIAs) redistributable that contains the Primary Interop Assemblies for Office 2003 products. |
| 22179 | 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. |
| 22180 | Describes the Microsoft Office 2003 issue that is fixed in the proofing tools for the Czech version of Office 2003 post-Service Pack 1 hotfix package that is dated March 3, 2005. |
| 22181 | Describes how to print a check box without borders on a pre-printed form in Access. |
| 22182 | Describes a problem that occurs when you run a Documenter report in Access. The DELETE query does not appear in the Documenter dialog box selection. |
| 22183 | Describes the Microsoft Office Access issues that are fixed in the Access 2003 post-Service Pack 1 hotfix package that is dated November 12, 2004. |
| 22184 | Describes a problem that occurs when you use the GROUP BY clause on a Memo field in Microsoft Access. The contents of the Memo field are incorrect and may appear as control characters. |
| 22185 | Describes the Microsoft Office Access 2003 issue that is fixed in the Italian version of Access 2003 post-Service Pack 1 hotfix package that is dated December 17, 2004. |
| 22186 | Describes a problem that may occur when you import XML data. Importing XML data may not work as you expect in Microsoft Office Access 2003. You have to increase cell height to see your data. |
| 22187 | Describes the issue that is fixed in the Office 2003 post-Service Pack 1 hotfix package that was released on January 18, 2005. |
| 22188 | Describes update that increases the reliability of Smart Tags by additionally restricting the way that Web sites are associated with the Smart Tag actions. |
| 22189 | Describes methods that you can use to disable Office Online featured links in Office 2003. |
| 22190 | Describes the Microsoft Office 2003 issue that is fixed in the Office 2003 post-Service Pack 1 hotfix package that is dated December 16, 2004. |
| 22191 | Describes the Access 2003 issue that is fixed by the Access 2003 post-Service Pack 1 hotfix package that is dated January 31, 2005. |
| 22192 | Describes a problem that may occur in Access 2003. You may receive the Syntax error in INSERT INTO statement error message. Jet 4.0 reserved words that are used in the column names of your database table may cause this problem to occur. |
| 22193 | Describes methods for how to create a DSN-less connection to SQL Server for linked tables in Microsoft Access. |
| 22194 | 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. |
| 22195 | Fixes a problem in Windows 2000 where you experience decreased performance when you access network resources or when you use Microsoft Access. |
| 22196 | Describes a problem that occurs when you use the DAO library to convert a database that you created in Access 97 or an earlier version by using the CompactDatabase method. Describes three methods to resolve the problem. |
| 22197 | Describes a problem where the installation log file may incorrectly list the Install return code: 0 error message when you install Microsoft Office 2003 on a client computer. |
| 22198 | Describes how to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients. |
| 22199 | Describes a problem that may occur when you try to start an Office 2003 program and you receive the Invalid product key error message. The workaround includes steps to correctly enter the product key and remove and reinstall Office. |
| 22200 | Describes a problem that occurs in Office 2003 documents when you click a hyperlink that opens another document. |
| 22201 | Describes a problem that may occur when you run the Form Wizard or the Database Wizard in Access 2000 or a later version. You may receive the Method 'CurrentDB' Of object '_Application' failed error message. |
| 22202 | Describes how to make sure that Office 2000 shortcuts and Office XP shortcuts are removed when you upgrade to Office 2003 by using an administrative installation point or by using a copy of the installation CD on a computer network. |
| 22203 | Describes the location of templates in Microsoft Office 2003, how the Templates dialog box displays the available templates, and the registry settings that control where to find your custom templates. |
| 22204 | Describes the issues that are fixed in the Office 2003 post-Service Pack 1 hotfix package that is dated August 20, 2004. |
| 22205 | Describes the French Microsoft Office 2003 post-Service Pack 1 hotfix package that is dated November 4, 2004. |
| 22206 | Describes a problem that may occur in Access when you convert an Access 2000 or a later version database to an Access 97 database. You may receive the Invalid field data type error message. |
| 22207 | Describes a problem that occurs when you move between the pages in an Access report while you are trying to print or preview the report, and then you move between the report pages. You receive a No current record error message. |
| 22208 | Describes the issue that is fixed in the Access 2003 post-Service Pack 1 hotfix package that is dated September 24, 2004. |
| 22209 | 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. |
| 22210 | 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... |
| 22211 | Describes the issues that are fixed in the German Multilingual User Interface Pack for Office 2003 post-Service Pack 1 hotfix package that is dated December 1, 2004. |
| 22212 | Describes a problem that may occur when you use the SendObject macro action or the SendObject method in Access 2003. |
| 22213 | Explains how to deploy an Access 2003 project that connects to an existing SQL Server 2000 database. |
| 22214 | Explains The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. error message. The Autonumber field seed is not correctly reset after compacting the database. |
| 22215 | Describes how to run multiple versions of Access on a single computer. This article also describes problems that may occur when you run multiple versions of Access, and what you can do to help resolve the problems. |
| 22216 | Explains that a control on a form or on a report appears blank if the control refers to a control on the subform or on the subreport without providing its full reference in the Control Source property. Resolve the problem by installing Office 2003 SP1. |
| 22217 | Describes the Microsoft Jet 4.0 Database Engine issues that are fixed in the Jet 4.0 Database Engine post-837001 hotfix package. Requires that you install the hotfix package to resolve those issues. |
| 22218 | Describes two methods that you can use to add a digital signature to an Access 2003 run-time application. Method 1 is Use the Custom Startup Wizard to add a digital signature. Method 2 is Add a digital signature manually. |
| 22219 | Describes that you will receive an error when you try to run the Access Conversion Scanning Tool, ADScanner.exe, from the command prompt if you use not valid command-line arguments. Provides sample scenarios that may cause the problem. |
| 22220 | Describes how to use the Access Conversion Scanning Tool, Adscanner.exe, as a command-line utility. This article describes each argument that is available with this tool. Default settings for the arguments are explained. |
| 22221 | Describes that the information about Access properties for Access databases may not be collected by the scanning tool. This problem occurs when the computer does not have the correct version of Access installed. Install the correct version of Access. |
| 22222 | Describes the RecordCount property, the NoConvertDialog property, and the Compiled State property that are collected by the scanning tool. This article describes what the the property values mean when you view them in the report tool. |
| 22223 | Describes the issues that are fixed in Microsoft Office Access 2003 by Office 2003 Service Pack 1. |
| 22224 | This article discusses the references that you may have to set when you work with databases that you create in Access 2003. |
| 22225 | Explains that you cannot analyze databases by using the Scan for Databases form in the report tool after you mark a database to suppress the Conversion dialog box. Re-open the Scan for Databases form to work around this problem. |
| 22226 | Describes the issues that are fixed in the Access 2003 post-Service Pack 1 hotfix package that is dated August 20, 2004. |
| 22227 | 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. |
| 22228 | Describes the issues that you must consider when you create a distributable Access run-time application by using Microsoft Office Access 2003 Developer Extensions. |
| 22229 | Describes how to resolve a problem that occurs with Access 2003 Developer Extensions. The first page of the Package Wizard or the Custom Startup Wizard appears blank, and the Next button may not be available. |
| 22230 | Describes that when you open an existing Access database or an Access project, the Database window may not appear. This occurs if Norton Antivirus or related software packages are installed on your computer. You have to upgrade the software packages. |
| 22231 | Explains the error that occurs when you try to locate a data access page by using the UseRemoteProvider property set and the controls bound to the data in a security-enhanced Access database or in an SQL Server database. A workaround is provided. |
| 22232 | Describes that the display of data access pages is blocked in Web Page Preview mode on a Windows XP SP2 computer. This problem occurs because of the Local Machine Zone Lockdown feature. Work around this problem by adding Mark of the Web comment. |
| 22233 | Explains that when you export an Access query whose criteria contains a Jet wildcard character to an XML document in Access 2003, no data is exported. Three methods are described to workaround this problem. |
| 22234 | Describes how to troubleshoot printing problems in Microsoft Windows Server 2003 when you use Microsoft Office products. |
| 22235 | 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. |
| 22236 | Explains that the Office 2003 Service Pack 1 for Proofing Tools ensures that Office 2003 performs with complete functionality when you use the Office 2003 Proofing Tools. |
| 22237 | Describes how to troubleshoot printing problems in Windows 2000. |
| 22238 | Describes an issue where you receive a This update has already been applied or is included in an update that has already been applied error message when you try to install an update for Office. |
| 22239 | Describes an installation error message that you may receive when you try to update your Office 2003 installation from the Office Update Web site. |
| 22240 | Describes the issues that are fixed in Office 2003 SP1. |
| 22241 | 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. |
| 22242 | Provides troubleshooting tips for printing problems with Office programs in Windows XP. |
| 22243 | This article contains definitions for the most frequently used terms in an Access database environment. |
| 22244 | 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. |
| 22245 | 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. |
| 22246 | Discusses the problem where you cannot open Office XP or Office 2003 files in Internet Explorer. |
| 22247 | Describes a problem that occurs when you copy and then paste a table that has fields greater than 256 characters in an Access project. The fields are truncated when you view the the fields in the resulting table. Workarounds are provided. |
| 22248 | 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... |
| 22249 | Describes the issue that is fixed in the description of the proofing tools for the Dutch version of Office 2003 hotfix package that is dated May 24, 2004. |
| 22250 | Describes the issue that is fixed in the Office 2003 hotfix package that is dated May 14, 2004. |
| 22251 | Describes the issue that is fixed in the description of the proofing tools for the Russian version of Office 2003 hotfix package that is dated May 21, 2004. |
| 22252 | Describes the issue that is fixed in the proofing tools for the Swedish version of Office 2003 hotfix package that is dated May 24, 2004. |
| 22253 | Fixes the issue that occurs where an Office 2003 program abruptly quits when you try to use the proofing tools for the Italian version of Office 2003. |
| 22254 | The Choose.exe file contains a document called Choosing the Right Database Tools that discusses Microsoft's database products: Microsoft Access, Microsoft FoxPro, Microsoft SQL Server, Microsoft Visual Basic, and Open Database Connectivity (ODBC).... |
| 22255 | Describes the issue that is fixed in the Office 2003 Proofing Tools hotfix package that is dated May 24, 2004. |
| 22256 | Explains why you may receive an error messge when you use a Microsoft Jet 3.0 and later Workgroup Information file with Microsoft Jet 4.0 OLE DB provider. This article provides a workaround for the problem. |
| 22257 | Describes an issue when you perform an administrative installation of the Access run-time application, the Setup program quits and the run-time application is not installed. You do not receive an error message when the Setup program quits. |
| 22258 | 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. |
| 22259 | Describes the problem that modifying an action query in a digital signed Access database by way of code does not re-sign the database, which can lead to an error message when you open the database after the modification. |
| 22260 | 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 . |
| 22261 | 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. |
| 22263 | Describes the issue that occurs when you search for a topic in Help, some topic titles may appear incorrectly with questions marks. |
| 22264 | Describes an error message you may receive when you open a data access page by using Internet Explorer, and that page contains a function that is not available outside Access. Requires basic macro, coding, and interoperability skills. |
| 22265 | 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. |
| 22266 | Describes a problem that occurs when you have an Office Chart 11.0 control in a data access page. You may not be able to use Microsoft Office Data Source Control (MSODSC) to connect to a data source. Includes 3 resolution methods. Requires basic skills |
| 22267 | Explains that setting the Visible property of a form object, a check box object, or a bound object frame object by using the SetValue action in a macro may cause an error. Instead, use the macro to run a function that sets the Visible property. |
| 22268 | Describes an issue that occurs when you open an Access database as read-only. If you then try to view the object dependencies for database objects, the listed object dependencies information may be incorrect. Includes workaround and steps to reproduce. |
| 22269 | 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. |
| 22270 | Describes an error message that you may receive when you try to open an existing Access database by using a shortcut. A solution to this problem is provided. |
| 22271 | Discusses problems that occur when you try to remove an Access 2003 runtime application. To resolve the problems, specify the source of the installation or manually remove the installation. |
| 22272 | Describes a problem where Office 2003 documents do not appear as thumbnails in Windows 2000 Explorer. |
| 22273 | 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. |
| 22274 | 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. |
| 22276 | When you use the MsgBox function with the vbMsgBoxRtlReading constant, a message does not appear in right-to-left reading order. |
| 22277 | 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. |
| 22278 | 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. |
| 22279 | 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. |
| 22280 | Fixes the problem where the File Open dialog box and the Save as dialog box take as a long as fifteen seconds for the File list box to show any files or folders. |
| 22281 | Describes the issues that are fixed in the Office 2003 hotfix package that is dated March 19, 2004. |
| 22282 | Microsoft has released security bulletin MS04-014. The security bulletin contains all the relevant information about the security patch, including file manifest information and deployment options. To view the complete security bulletin, visit the... |
| 22283 | Explains that the AutoDialer feature ignores the dialing rules that are set in Access. This article also provides the workaround for resolving the problem. |
| 22284 | 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. |
| 22285 | 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... |
| 22286 | Describes an issue that occurs when you start an Office XP program on a computer that also has Office 2003 programs installed. You receive an error message about the Office Assistant. |
| 22287 | 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. |
| 22288 | Fixes the problem that occurs when Office documents, Word documents, Excel workbooks, or PowerPoint presentations, take longer than expected to open in the Internet Explorer browser window. |
| 22289 | Describes an issue that occurs when you use the Import Spreadsheet Wizard to import an Excel file into Access 2003 and you can change only the first field name. Contains a link to a hotfix. |
| 22290 | 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. |
| 22291 | Describes the issues that are fixed in the Microsoft Office 2003 hotfix package that is dated March 18, 2004. |
| 22292 | Describes the issues that are fixed in the Office 2003 hotfix package that is dated March 5, 2004. |
| 22293 | Describes how linked tables may become local tables in Microsoft Office Access 2003 when you use the Visual SourceSafe add-in from Office XP Developer Edition. |
| 22294 | 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. |
| 22295 | Describes issues that are fixed in the Access 2003 hotfix package that is dated February 29, 2004. |
| 22296 | Explains that you may receive an error message when you try to start a wizard, such as the Form Wizard, the Table Wizard, or the Report Wizard in Access 2003. To resolve this problem, install the latest Jet service pack. |
| 22297 | Describes an issue where you receive an exception error message when you run a custom program that uses managed code with an Office 2003 Datagrid control. |
| 22298 | 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. |
| 22299 | 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. |
| 22300 | 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... |
| 22301 | When you open a signed database, you may receive a message that says that you do not have Read Design permissions for one of the queries. You may also receive another message that indicates that the database cannot be opened because of security... |
| 22302 | If you install two packages that are based on the same template on one computer, there are two instances of the application name in the Add/Remove Programs dialog box. If you install these two packages to the same file location, the second... |
| 22303 | When you use the spelling checker feature to try to check the spelling in one of the Dutch versions of the programs that are listed in the Applies to section of this article, you may receive an error message that is similar to the following (where... |
| 22304 | When you build or run a client application (such as a Microsoft Visual C++ application) that runs an SQL statement on a Microsoft Jet data source, the client application may fail with an unhandled exception. You may receive an error message that is... |
| 22305 | When you try to start a wizard in Microsoft Office Access 2003, such as the Link Table wizard, the Import Text wizard, or the Form wizard, the wizards may not start successfully, and you may receive the following error message: Microsoft Access can't... |
| 22306 | 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. |
| 22307 | When you start Linked Table Manager Wizard in a Microsoft Office Access 2003 database that contains linked tables, you may notice that the list of currently linked tables, together with their paths, do not appear in the Select the linked tables to be... |
| 22308 | When you try to send a Microsoft Office 2003 document as an e-mail message for review or as an attachment in an e-mail message in one of the Office 2003 programs that are listed in the Applies to section of this article, the menu command to send the... |
| 22309 | 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... |
| 22310 | This article describes how to display images on your Web site by using information from a Microsoft Access database. Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not... |
| 22311 | When you click File and then click Open to bring up the Open dialog box in a Microsoft Office 2003 program, such as Microsoft Office Word 2003, the program does not automatically select the first available document that is listed in the Open dialog... |
| 22312 | When you open a digitally-signed database or a database project in Microsoft Office Access 2003, and the database or the database project contains forms that have grouped controls or reports that have grouped controls, Access 2003 may quit... |
| 22313 | When you upgrade an earlier version of Microsoft Access to Microsoft Office Access 2003, the following menu items may be missing: The macro Security menu item may be missing. To determine whether the macro Security menu item is missing, point to Macro... |
| 22314 | You may try to merge the data from a Microsoft Office Access 2003 parameter query into a Microsoft Office Word 2003 Mail Merge document by using Microsoft Word Mail Merge Wizard. When you do this, you may receive the following error message: Word was... |
| 22315 | This article lists some of the resources that are available to help you learn Microsoft Visual Basic programming in Microsoft Office 2003. This article contains the following sections: Online Help The Object Browser Microsoft Press books Microsoft... |
| 22316 | When you try to a customize a toolbar or when you try to open a Microsoft Office Access 2003-specific object such as a form, a report, a macro, or a module in Design view, you may receive the following error message: You do not have exclusive access... |
| 22317 | Microsoft HTML Help Workshop is a Help authoring tool with an easy-to-use graphical interface. You can use HTML Help Workshop to create the following kinds of files: Help project files Topic files Content files Index files You can put these files... |
| 22318 | This article discusses the different data types that are available for you to use for the fields in a table in a Microsoft Office Access 2003 database. This article also discusses the field properties that are available for you to use when you design... |
| 22319 | 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... |
| 22321 | This article describes the functions and the operators that are available in Microsoft Office Access 2003. You can use the functions and the operators to make a change to the Date/Time data type by using example queries. The example queries that you... |
| 22322 | This article discusses the Microsoft Office 2003 Application Error Reporting tool. You can use the Application Error Reporting tool to report to Microsoft the fatal system errors that occur in Microsoft Office Access 2003. This article discusses the... |
| 22323 | When you try to save design changes that are made to a Microsoft Office Access 2003 object and that object contains a module (a form, a report, or a standard module), Access 2003 may take more time to save the object than in earlier versions of... |
| 22324 | You can edit a single registry entry to clear the most recently used files list that appears in most Microsoft Office 2003 programs. Many Office 2003 programs maintain a list of the most recently used (MRU) files and display that list on the File menu... |
| 22325 | In a Microsoft Office Access 2003 database project (.adp), you can link data from other programs and from other file formats such as Microsoft Excel, dBase, Paradox, or XML (import only). You can also import or you can also link Access databases... |
| 22326 | When you add a digital certificate to a Microsoft Office Access 2003 database, you may experience a delay when you open the database. A delay may also occur when you close the database, when you save the database, or when you save the database objects. |
| 22327 | When you try to edit a field in an ADO recordset by using Microsoft Office Access 2003 and Microsoft Jet OLE DB Provider, you may receive the following error message: Run-time error '3251': Current Recordset does not support updating. This may be a... |
| 22328 | Microsoft has released the Bookshelf Symbol 7 Font Removal Tool. This tool removes the Bssym7.ttf font that is included in Microsoft Office 2003. This font has been found to contain unacceptable symbols. |
| 22329 | Microsoft has addressed a variety of customer requests by making enhancements and by making behavior fixes to Microsoft Office Access 2003. There are also new features that are available in Access 2003. back to the top Enhanced-security features The... |
| 22330 | When you try to convert an uncompiled, read-only database to Microsoft Office Access 2003, 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,... |
| 22331 | In Microsoft Office Access 2003, when you view the Products by Category report in Print Preview in the Northwind.mdb sample database or the NorthwindCS.adp sample Access project, you may not be able to see all the data that is contained in the report.... |
| 22332 | When you try to open a password-protected database by using the shortcut that is created during the Microsoft Office Access 2003 distribution package installation and the password for the database contains quotation marks (), you may receive the... |
| 22333 | When you click a feature in one of the Microsoft Office programs that are listed at the end of this article, you may receive the following error message: The feature you are trying to use is on a network resource that is unavailable. Click OK to try... |
| 22334 | When you use the Convert Database utility to convert a Workgroup Information (.mdw) file that was created in Microsoft Access 95 or in Microsoft Access 97, and you perform this conversion in Access 2003 by using the To Access 2002 - 2003 File Format... |
| 22335 | The names of the default fields in a Microsoft Windows SharePoint Services list may be preceded by an underscore character if both of the following conditions are true: You export a table from Microsoft Office Access 2003 to a list in Microsoft... |
| 22336 | If you are working with a Microsoft Office Access 2003 database project, and you try to import data from a Microsoft Exchange file or a Microsoft Outlook (.pst) file on a computer where Microsoft Office Outlook 2003 is installed, the data may not be... |
| 22337 | 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... |
| 22338 | 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. |
| 22339 | 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... |
| 22340 | When you store an image file in a table as an OLE object in Microsoft Office Access 2003, and then you try to display the stored image by embedding or by linking the image file in a form, a report, or a data access page, you may not be able to view... |
| 22341 | The Security Level tab in the Security dialog box implies what the security level is for macros. The security level setting also changes how the Microsoft Office 2003 products listed in the Applies To section of this article handle other types of... |
| 22342 | When you create a new Microsoft Office Access 2003 database or project, the database references the Microsoft ActiveX Data Objects (ADO) 2.1 Library instead of referencing a newer version of the ADO Library. However, if you use Access 2003 to create... |
| 22343 | Microsoft Office Access 2003 can import or link data from Access databases that were created in different versions of Access (Access version 2.0, Access version 7.0, Access version 8.0, Access version 9.0, Access version 10.0, and Access version... |
| 22344 | 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... |
| 22345 | 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... |
| 22346 | 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... |
| 22347 | You remove Microsoft Office Access 2003, including an Access 2003 run-time application. When you start a Microsoft Access 2000 run-time application, you cannot run the Visual Basic for Applications (VBA) code in your run-time application. You may also... |
| 22348 | 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. |
| 22349 | In a Microsoft Office Access 2003 database, corruption in your database may occur for a number of reasons. This article contains a list of references to Microsoft Knowledge Base articles that may help you to resolve corruption in your database. |
| 22350 | 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... |
| 22351 | 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... |
| 22352 | 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... |
| 22353 | This article lists the locations where you can find out if your current software qualifies you for the upgrade version of Microsoft Office 2003. The retail versions of Microsoft Office 2003 Editions and individual products are available in the... |
| 22354 | 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... |
| 22355 | 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... |
| 22356 | When you open a workbook in Excel, and the workbook contains links to other Excel workbooks that are generated when a report in Access is exported to Excel, you may receive the following error message when you update the links in the workbook: Unable... |
| 22357 | 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. |
| 22358 | 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. |
| 22359 | Microsoft Office Professional Edition 2003, Microsoft Office FrontPage 2003, and Microsoft Visual Studio Tools for the Microsoft Office System 2003 are the recommended suite of products and the recommended tools for Microsoft Office 2003 developers.... |
| 22360 | 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. |
| 22361 | 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 . |
| 22362 | 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... |
| 22363 | This article discusses the licensing and the use of Microsoft Office 2003 Web Components. If you create a Web page that contains an Office 2003 Web component, the component is not visible to visitors to your site unless they install the Office 2003... |
| 22364 | 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... |
| 22365 | 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... |
| 22366 | In Microsoft Office Access 2003, you may not be able to import, export, or link to Microsoft FoxPro databases directly because the Import , Export , and Link dialog boxes do not include the FoxPro database as an option in the Files of type list. |
| 22367 | 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]... |
| 22368 | When you use the New operator or the CreateObject function in Microsoft Visual Basic 6.0 to create an instance of a Microsoft Office Access 2003 application, you may receive the following error message: Run-time error '429': ActiveX component can't... |
| 22369 | After you try to programmatically export a Microsoft Graph object, you may 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. When you click OK... |
| 22370 | In a Microsoft Office Access 2003 environment, you may not be able to determine who opened an Access 2003 database in the exclusive mode. However, you can use the operating system utilities to determine who is using shared resources on your computer. |
| 22371 | If you try to edit an existing Web page in Microsoft Office Access 2003 and the Web page has Microsoft Office 2003 Web Components, such as a Pivot Table, the Web page cannot connect to the component data source. You may receive the following error... |
| 22372 | This article discusses the sequence of tasks that Microsoft Office Access 2003 performs to resolve the references that are in Microsoft Visual Basic for Applications (VBA). |
| 22373 | When you create a linked table in a Microsoft Office Access 2003 database by linking a Windows SharePoint Services list from a Microsoft Windows SharePoint Services site, you may not be able to edit the lookup field in the linked table if the Windows... |
| 22374 | Selfcert is not included in Access Stand-Alone Setup. |
| 22375 | This step-by-step article shows you how to create a Visual C# .NET client that gets an Automation Reference to a running instance of an Office program. Create a Visual C# .NET Application That Automates a Running Instance of an Office Program Client... |
| 22376 | 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... |
| 22377 | 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... |
| 22378 | 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... |
| 22379 | 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... |
| 22380 | 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... |
| 22381 | 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. |
| 22382 | 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. |
| 22383 | 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. |
| 22384 | 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. |
| 22385 | 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... |
| 22386 | This article contains a list of the references that you must set when you use Microsoft Office Access 2003 databases or when you gain access to information that is in Microsoft Office Access 2003 databases from other applications. This article... |
| 22387 | When you run a Left Outer Join or Right Outer Join query, Microsoft Access may return incorrect data. |
| 22388 | 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... |
| 22389 | A Microsoft Access database has begun to bloat (or grow rapidly in size) after you implement Data Access Objects (DAO) to open a recordset. |
| 22390 | 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... |
| 22391 | 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... |
| 22392 | This article describes how to customize the My Places bar in Microsoft Office 2003. The My Places bar appears in the left pane of both the Open and the Save As dialog boxes in Microsoft Office programs. The following customizations are available for... |
| 22393 | If you open a Microsoft Office Access 2003 database while you press the shift key to suppress the startup form or the startup page in the Access 2003 database, the startup form or the startup page may be displayed if the Security Warning dialog box is... |
| 22394 | When you convert a Microsoft Office Access 2003 database to a Microsoft Access 97 database and then you open a form or a report in the new Access 97 database, you may receive the following error message: There is no object in this control. |
| 22395 | 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... |
| 22396 | 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... |
| 22397 | 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. |
| 22398 | 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,... |
| 22399 | When you run Setup for any of the programs listed in the Applies to section of this article, you may receive the following error message: Error 1919. Error configuring ODBC data source: MS Access Database. ODBC error 6: Component not found in the... |
| 22400 | When a user who does not have the Microsoft Office 2003 Web Components installed on their computer accesses a Web page that contains an Office 2003 Web Component, he or she may receive a message that is similar to the following: To use this Web page... |
| 22401 | 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. |
| 22402 | This article discusses the differences between the CurrentProject.Connection and the CurrentProject.AccessConnection properties in Microsoft Access 2002 or later. |
| 22403 | When you use Microsoft Windows Explorer or when you use a shortcut to open a Microsoft Access database file or to open an Access database project file that was created in Microsoft Access 2002 or in an earlier version, the file opens in the... |
| 22404 | 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 |
| 22405 | 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. |
| 22406 | 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... |
| 22407 | 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... |
| 22408 | This article shows you how to dynamically build criteria for a query string with values from a search form. |
| 22409 | 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,... |
| 22410 | If you try to preview a report that is grouped on one or more fields that have many unique values in a Microsoft Access database project, Access may stop responding, and the preview window may display the status as Formatting Page . Note You may still... |
| 22411 | 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. |
| 22412 | When you try to make an MDE file or an ADE file in the Microsoft Access database (MDB) file or in the Microsoft Access project (ADP) file, one of the following behaviors occur: The command to make the MDE file or the ADE file may not be available.... |
| 22413 | 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... |
| 22414 | When you try to open a Microsoft Binder file, you may receive an error message that is similar to the following: This file does not have a program associated with it for performing this action. Create an association in the Folder Options control... |
| 22415 | 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... |
| 22416 | When you create a COM add-in for a Microsoft Office program (for example, Microsoft Visio), the appearance of that add-in will conform by default to the standard Office appearance. However, with Microsoft Windows XP, you can choose from a number of... |
| 22417 | This article discusses how to use the new FileDialog method in Microsoft Access to display the built-in File dialog box and to determine the files that the user selects. Note The FileDialog method works only in the full retail version of Microsoft... |
| 22418 | After you install Microsoft Office 2003, when you try to connect to your Microsoft SharePoint Portal Server 2001 document library or to your backward-compatible Web storage-based document library for Microsoft Office SharePoint Portal Server 2003, you... |
| 22419 | After you install Project 2002 on a computer that Office 2003 is already installed on, Windows Installer unexpectedly starts when you start an Office 2003 program for the first time. Note After Windows Installer has completed updating the... |
| 22420 | 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... |
| 22421 | 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... |
| 22422 | 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... |
| 22423 | 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... |
| 22424 | 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... |
| 22425 | 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... |
| 22426 | 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... |
| 22427 | 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... |
| 22428 | When you try to create a new document in a Microsoft Office 2003 program, you may receive one of the following error messages: Microsoft Office program can't display the template used in this document. An error occurred and this feature is no longer... |
| 22429 | When you run the RegClean utility after installing one of the products listed at the beginning of this article, you may experience one of the following symptoms: RegClean finds errors in the System Registry, and you receive the option to Fix Errors in... |
| 22430 | When you run Setup for Office, you may receive the following error message: This patch package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer patch package. |
| 22431 | This step-by-step article describes how to activate the perpetual license version of Microsoft Office 2003. The same procedure can also be used for any stand-alone version of Microsoft Office Access 2003, Microsoft Office Excel 2003, Microsoft Office... |
| 22432 | This article demonstrates how to obtain the window handle of a Microsoft Office application while automating that application from Microsoft Visual Basic .NET. |
| 22433 | This article demonstrates how to obtain the window handle of a Microsoft Office application while automating that application from Microsoft Visual C# .NET. |
| 22434 | 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... |
| 22435 | 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... |
| 22436 | When you run the Activation Wizard for Microsoft Office 2003, and then you click I want to activate the software over the Internet , you may receive one of the following error messages: The Activation Wizard is unable to find a connection to the... |
| 22437 | After you install Office 2003, you may receive an error message that is similar to the following when you view Web pages in Microsoft Internet Explorer: Error A Runtime Error has occurred. Do you wish to Debug? Line: line number Error: nature of... |
| 22438 | When you try to install the upgrade version of any of the products that are listed in the Applies To section at the beginning of this article, you may receive the following error message: The product key you entered requires a version of Microsoft... |
| 22439 | 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... |
| 22440 | 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.... |
| 22441 | 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... |
| 22442 | 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... |
| 22443 | 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... |
| 22444 | 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. |
| 22445 | 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... |
| 22446 | 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... |
| 22447 | When you connect to a Microsoft Access database from a Microsoft ASP.NET application, you receive the following error message: System.Data.OleDb.OleDbException: Unspecified error |
| 22448 | When you try to install any of the Microsoft products listed at the beginning of this article, you may receive an error message similar to the following: The MSIEXEC file is linked to missing export MSI.DLL:222. |
| 22449 | 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.... |
| 22450 | 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). |
| 22451 | This article lists some of the most common specifications for Microsoft Access. |
| 22452 | When you try to upsize a Microsoft Access database (.mdb) to Microsoft SQL Server, the Upsizing Wizard fails to export data for large tables. |
| 22453 | 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... |
| 22454 | 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... |
| 22455 | 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. |
| 22456 | 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... |
| 22457 | 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... |
| 22458 | 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... |
| 22459 | 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... |
| 22460 | 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. |
| 22461 | 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. |
| 22462 | 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... |
| 22463 | 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. |
| 22464 | 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.... |
| 22465 | 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... |
| 22466 | This article describes what is required to create an updateable form that is bound to an ActiveX Data Objects (ADO) Recordset object. |
| 22467 | 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... |
| 22468 | This article describes several tips for improving performance when you access data from an ODBC data source. |
| 22469 | 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... |
| 22470 | 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... |
| 22471 | 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... |
| 22472 | 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... |
| 22473 | 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,... |
| 22474 | This article discusses and explains how COM (Component Object Model) determines which version of an Office application is loaded when you use Office Automation. |
| 22475 | 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... |
| 22476 | 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.... |
| 22477 | 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... |
| 22478 | 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. |
| 22479 | 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. |
| 22480 | 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... |
| 22481 | 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... |
| 22482 | 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... |
| 22483 | When you have the Name AutoCorrect feature enabled, and you make changes to a query's record source, such as changing a table name, a query name, or a field name, and you then run the query, the query may: Prompt for the old field name value. Return... |
| 22484 | If you call a procedure in a form class module from the OnAction property of a command bar control, the function runs three times. |
| 22485 | One alternative to displaying your application's online Help system in a separate window is to display it in a small, shaded pop-up window within your application. To do this, you can use the Windows API WinHelp() function with its HELP_CONTEXTPOPUP... |
| 22486 | 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... |
| 22487 | 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... |
| 22488 | 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. |
| 22489 | 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... |
| 22490 | 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++. |
| 22491 | 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. |
| 22492 | 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... |
| 22493 | 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. |
| 22494 | 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. |
| 22495 | 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... |
| 22496 | 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... |
| 22497 | 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. |
| 22498 | When you run a procedure in Microsoft Access 2000 or later, you may receive the following error message: The expression Event_Name you entered as the event property setting produced the following error: Ambiguous name detected: EventProcedure_Name . |
| 22499 | When you query a table that is linked to a Microsoft Excel spreadsheet, you may receive the following error message: Numeric field overflow. |
| 22500 | 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... |
| 22501 | 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... |
| 22502 | 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... |
| 22503 | 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 |
| 22504 | 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... |
| 22505 | 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... |
| 22506 | 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... |
| 22507 | 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... |
| 22508 | 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... |
| 22509 | 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.... |
| 22510 | 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... |
| 22511 | When you try to open a Microsoft Visual Basic for Applications (VBA) project in Access 2000, and that project was created by using Office Access 2003, you may receive the following error message: Project is unviewable When you open the same VBA... |
| 22512 | 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... |
| 22513 | 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).... |
| 22514 | 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. |
| 22515 | This article shows you how to programmatically change the connection of a Microsoft Access project (ADP) file. |
| 22516 | 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... |
| 22517 | This step-by-step article describes how to determine the exact version of your Office 2003 product. Note The version for each product is frequently updated when you apply a product update or Office service pack. However, all programs may not display... |
| 22518 | 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... |
| 22519 | 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... |
| 22520 | 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... |
| 22521 | When you try to open or to convert a Microsoft Access 2.0 database file in Microsoft Office Access 2003, you receive the following message: You must install the Microsoft Access 2.0 Converter in order to convert this file. To get the Access 2.0... |
| 22522 | 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:... |
| 22523 | 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... |
| 22524 | 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... |
| 22526 | This article contains information about the Northwind sample files that Microsoft Office Access 2003 creates. |
| 22527 | A Btrieve ISAM is no longer available starting from Microsoft Access 2002. |
| 22528 | You cannot import from the Exchange Public Folder more than once for each Access session. |
| 22529 | 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... |
| 22530 | 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... |
| 22531 | Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb). Access 2002 290291 For a Microsoft Access 2002 version of this article, see 290291 . Access 2000 275164 For a... |
| 22532 | When you try to start one of the Microsoft Office 2003 programs, you receive the following message: Your beta software has expired. Please upgrade or use the Add or Remove Programs utility under Control Panel to remove the software from your computer. |
| 22533 | 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... |
| 22534 | When you try to open a query that contains a function, you receive the following error message: Your Microsoft Access database or project contains a missing or broken reference to the file FileName. To ensure that your database or project works... |
| 22535 | When you try to open a Microsoft Access project (.adp) file or a Microsoft Access project extension (.ade) file in a multiuser environment, you may receive the following error message: The Microsoft OfficeAccess project ProjectName will be opened... |
| 22536 | This article describes the minimum system requirements for Office 2003. |
| 22537 | When you try to save an Office 2003 file to a Novell Netware network location, you may receive an error message that indicates that the file (or the folder that contains it) is marked as read-only. Note Word 2003 will save a Word document correctly.... |
| 22538 | 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. |
| 22539 | 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. |
| 22540 | 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... |
| 22541 | 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'. |
| 22542 | 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... |
| 22543 | This article shows you how to use a form to specify the criteria for a query. This technique is called query by form (QBF). |
| 22544 | 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... |
| 22545 | If a database has the Name AutoCorrect feature enabled, users may experience a delay when they try to open database objects. |
| 22546 | This article describes how to convert data values of Text data type to Proper Case format (Title case format). |
| 22547 | 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... |
| 22548 | This article describes how to install or how to repair and reinstall individual programs and features in Microsoft Office 2003. The information that is contained in this article is also available in Microsoft Office Help. For instructions about how to... |
| 22549 | 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... |
| 22550 | Each Knowledge Base (KB) Help file contains all the current KB articles for a particular version of Microsoft Access, the Microsoft Access Distribution Kit, the Microsoft Access Developer's Toolkit, and the Microsoft Office Developer Edition Tools. As... |
| 22551 | 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... |
| 22553 | 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. |
| 22554 | 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... |
| 22555 | This article describes errors that may occur in Access 2000 when you update data in queries and in forms. This article also describes the causes of the errors and how to troubleshoot those errors. When you try to update data in a query or in a form,... |
| 22556 | 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 |
| 22557 | 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 |
| 22558 | 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... |
| 22559 | 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. |
| 22560 | This article contains a listing of all the Open Database Connectivity (ODBC) drivers installed by Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97, the Microsoft Data Access Components versions 1.5c and 2.1, the Microsoft ODBC 3.0 drivers for Windows... |
| 22561 | 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. |
| 22562 | When you install Microsoft Project 2002 on a computer that has Microsoft Office XP with no service pack installed, you open a Microsoft Office program, click Help, click About Microsoft Program, and the program incorrectly reports that Service Pack 1... |
| 22563 | 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 |
| 22564 | SYMPTOMS When you try to run a query, a form, or a report, the Enter Parameter Value dialog box may appear unexpectedly. |
| 22565 | 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 |
| 22566 | 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 |
| 22567 | 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. |
| 22568 | Unlike with a form, you cannot use the |
| 22569 | Microsoft Access has no built-in method for disabling the |
| 22570 | This article describes a method that you can use to collate and print two reports. This method alternates two reports between the |
| 22571 | When you use the Export Text Wizard to import, export, or link a text file, you may receive the following error message: |
| 22572 | When you convert a database from an earlier version of Microsoft Access, you may receive the following error message: |
| 22573 | You can improve the performance of Microsoft Access if you periodically defragment your hard disk and compact your database. |
| 22574 | You can install multiple versions of Microsoft Access 97 and earlier on the same computer, and you can even run the separate versions simultaneously with one exception: you cannot run Microsoft Access 1.x and Microsoft Access 2.0 at the sam |
| 22575 | 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 |
| 22576 | 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. |
| 22577 | After you programmatically change properties of the Application.Printer object, forms and reports that use the default printer do not automatically inherit these settings. |
| 22578 | 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 |
| 22579 | This article shows you how to use the Seek method with an ActiveX Data Objects (ADO) recordset. |
| 22580 | 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 |
| 22581 | 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. |
| 22582 | 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 |
| 22583 | 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. |
| 22584 | 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 |
| 22585 | When you open a table or view in a Microsoft Access project (.adp) file, the following error occurs: |
| 22586 | When you run Setup for Microsoft Office XP, you may receive an error message similar to one of the following: |
| 22587 | When you try to import dBASE files into Access, you may receive the following error message: |
| 22588 | Microsoft occasionally releases hotfixes to resolve one or more critical problems with Office programs. Each of these hotfixes is cumulative. This means that all hotfixes contain all the hotfixes in earlier versions of the affected files. Y |
| 22589 | 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. |
| 22590 | 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 |
| 22591 | 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 |
| 22592 | 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 |
| 22593 | 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, |
| 22594 | 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 |
| 22595 | 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 |
| 22596 | 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. |
| 22597 | 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. |
| 22598 | 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 . |
| 22599 | 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? |
| 22600 | 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. |
| 22601 | 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. |
| 22602 | 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 |
| 22603 | 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. |
| 22604 | 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. |
| 22605 | 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 |
| 22606 | This article explains the role and relationship of the workgroup information file in Microsoft Access security. |
| 22607 | 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. |
| 22608 | 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 . |
| 22609 | 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 |
| 22610 | This article explains the capabilities, the limitations, and the workarounds for using Microsoft SQL Server Application roles in a Microsoft Access project (ADP). |
| 22611 | 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 |
| 22612 | This article shows you how to use a Microsoft Access form to specify the query criteria in an Access 2002 project. |
| 22613 | This article shows you how to use Microsoft Visual Basic for Applications to output a list of users who are logged onto a database. |
| 22614 | 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 |
| 22615 | 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 |
| 22616 | 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 |
| 22617 | 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': |
| 22618 | This article demonstrates how to use ActiveX Data Objects (ADO) and OLE DB to find records in a Microsoft Jet database . |
| 22619 | 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. |
| 22620 | 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. |
| 22621 | 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 |
| 22622 | This article shows you how to reset the |
| 22623 | 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. |
| 22624 | This article shows you how to use the |
| 22625 | 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. |
| 22626 | This article explains how to retrieve the Database window if the Database window seems to be lost or is hidden from view. |
| 22627 | The information covered in this article is provided by: |
| 22628 | The information covered in this article is provided by: |
| 22629 | The information covered in this article is provided by: |
| 22630 | The information covered in this article is provided by: |
| 22631 | The information covered in this article is provided by: |
| 22632 | The information covered in this article is provided by: |
| 22633 | When you try to link or embed a Word document, you may receive one of the following error messages: |
| 22634 | 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 |
| 22635 | 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 |
| 22636 | 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 |