Access 2002 and Jet 4 Errors APPENDIX E
Appendixes for Web Site PART VI Access lets you trap some errors that can occur during program execution. By using the errortrapping commands mentioned in Chapter 7, “Handling Your Errors in Access with VBA,” you can anticipate errors and handle them accordingly. The following table lists both Access 2002 application/VBA errors and Jet 4.0 errors. The error numbers can potentially go up to 32767, with user-definable errors from 30000 on. The code in Listing E.1 creates the data in the upcoming table.
Access 2002 and Jet 4 Errors APPENDIX E 3 • Errors not listed here are either application-defined or object-defined errors, or are reserved for future use in new versions of Access or with the Jet engine.
Appendixes for Web Site PART VI ErrorCode ErrorString 74 75 76 93 96 Can’t rename with different drive Path/File access error Path not found Invalid pattern string Unable to sink events of object because the object is already firing events to the maximum number of event receivers that it supports Can not call friend function on object which is not an instance of defining class A property or method call cannot include a reference to a private object, either as an argument or as a return value Invalid
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 445 446 447 448 449 450 451 Object doesn’t support this action Object doesn’t support named arguments Object doesn’t support current locale setting Named argument not found Argument not optional Wrong number of arguments or invalid property assignment Property let procedure not defined and property get procedure did not return an object Invalid ordinal Specified DLL function not found Code resource not found Code resource lock error This key is already
Appendixes for Web Site PART VI ErrorCode ErrorString 2006 The object name ‘|’ you entered doesn’t follow Microsoft Access object-naming rules. For more information about naming objects, click Help. You already have an open database object named ‘|.’ Use a different name for each database object of the same type. If you want this object to replace the original object, close the original object, and then save this object using the same name.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2022 You entered an expression that requires a data access page to be the active window. The file name you specified for the data access page already exists. The report snapshot was not created because you don’t have enough free disk space for temporary work files. To fix this, free up disk space (for example, empty the Recycle Bin or delete unnecessary files). The file is not in the correct format for a Microsoft Access project.
Appendixes for Web Site PART VI ErrorCode ErrorString 2040 2041 2042 Microsoft Access can’t run. Microsoft Access couldn’t find file ‘|’. This file is required for startup. A system error occurred, or there isn’t enough free memory to start Microsoft Access. Close unneeded programs and try again. Microsoft Access can’t find the database file ‘|.’ Make sure you entered the correct path and file name. You can’t exit Microsoft Access now.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2058 The file ‘|’ is incompatible. Microsoft Access needs to be reinstalled. Run Setup to reinstall Microsoft Access. If you want to preserve your security or custom settings, back up the Microsoft Access workgroup information file. For more information on backing up files, search the Microsoft Windows Help index for ‘backing up files’. Microsoft Access cannot find the object ‘|’. Make sure the object exists and that you spell its name correctly.
Appendixes for Web Site PART VI ErrorCode 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081 2082 ErrorString • The Menu Bar or Shortcut Menu Bar option in the Startup dialog box. This error also occurs if Microsoft Access attempts to run a menu bar macro containing an AddMenu action that follows an action that makes some other object the active object. For example, the OpenForm action. The selected item is customized and doesn’t have context-sensitive Help.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2083 The database ‘|’ is read-only. You can’t save changes made to data or object definitions in this database. Field ‘|’ is based on an expression and can’t be edited. The ODBC Refresh Interval setting must be from 1 through 32,766 seconds. Recordset requires a form to be updateable. Microsoft Access can’t display the Add-ins submenu. The Add-ins submenu expression ‘|’ you entered exceeds the 256-character limit.
Appendixes for Web Site PART VI ErrorCode ErrorString 2093 The numeric value for the setting argument in the SetOption method doesn’t correspond to any list box or option group settings in the Options dialog box. Valid settings are 0 (the first item in the list) through | (the last item in the list). Microsoft Access can’t find the toolbar ‘|.’ You tried to run a macro that includes a ShowToolbar action or a Visual Basic procedure that includes a ShowToolbar method.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2103 The report name ‘|’ you entered in either the property sheet or macro is misspelled or refers to a report that doesn’t exist. If the invalid report name is in a macro, an Action Failed dialog box will display the macro name and the macro’s arguments after you click OK. Open the Macro window, and enter the correct report name. You entered the control name ‘|,’ which is already in use.
Appendixes for Web Site PART VI ErrorCode ErrorString 2112 2113 The item on the Clipboard can’t be pasted into this control. The value you entered isn’t valid for this field. For example, you may have entered text in a numeric field or a number that is larger than the FieldSize setting permits. Microsoft Access doesn’t support the format of the file ‘|,’ or file is too large. Try converting the file to BMP or GIF format.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2121 Microsoft Access can’t open the form ‘|.’ It contains data that Microsoft Access doesn’t recognize. Re-create the form or, if you maintain backup copies of your database, retrieve a copy of the form. You can’t view a form as a continuous form if it contains a subform, an ActiveX control, or a bound chart. Set the DefaultView property of the form to Single Form, Datasheet, PivotTable, or PivotChart.
Appendixes for Web Site PART VI ErrorCode ErrorString 2138 You can’t search the field for the specified value. Resolve the error given in the previous error message before you attempt to search again. You can’t replace the current value of the field with the replacement text. Resolve any errors before making further replacements. Microsoft Access can’t save the change you made to the record in the Replace operation for the reason given in the previous error message.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2152 2153 2154 You can set group levels for reports only, not for forms. You can’t specify more than 10 group levels. You can’t call this function when the Sorting and Grouping box is open. Microsoft Access has encountered an error in compiling the Visual Basic code. You don’t have permission to edit code; inform someone who does have permission about this error. Microsoft Access has encountered an error in compiling the Visual Basic code.
Appendixes for Web Site PART VI ErrorCode ErrorString 2163 The page number you used as an argument for the GoToPage action or method doesn’t exist in this form. You can’t disable a control while it has the focus. You can’t hide a control that has the focus. You can’t lock a control while it has unsaved changes. This property is read-only and can’t be modified. You can’t save this record at this time. Microsoft Access may have encountered an error while trying to save a record.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2178 You can’t add another section now. The maximum total height for all sections in a report, including the section headers, is 200 inches (508 cm). Remove or reduce the height of at least one section, and then add the new section. You can’t sort on a calculated field in a form. You can sort on a calculated field only in a query. Create a calculated field in a query, sort the field, and then base the form on the query.
Appendixes for Web Site PART VI ErrorCode ErrorString 2190 This property has been replaced by a new property; use the new property instead. You can’t set the | property in print preview or after printing has started. Try setting this property in the OnOpen event. The bitmap you specified is not in a device-independent bitmap (.dib) format. You tried to set the PictureData property of a form, report, button, or image control.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2205 The default printer driver isn’t set up correctly. For information on setting a default printer, search the Microsoft Windows Help index for ‘default printer, setting’. The page number you entered is invalid. For example, it may be a negative number or an invalid range, such as 6 to 3. Microsoft Access can’t print macros. You tried to use the PrintOut action or method, but the active object is a macro.
Appendixes for Web Site PART VI ErrorCode ErrorString 2229 Microsoft Access can’t start the OLE server. You tried to use a form, report, or datasheet that contains an OLE object, but the OLE server (the application used to create the object) may not be registered properly. Reinstall the OLE server to register it correctly. Microsoft Access can’t paste the OLE object. The text you entered isn’t an item in the list. Select an item from the list, or enter text that matches one of the listed items.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2262 2263 2264 This value must be a number. The number is too large. Microsoft Access didn’t recognize the unit of measurement. Type a valid unit, such as inches (in) or centimeters (cm). You must specify a unit of measurement, such as inches (in) or centimeters (cm). ‘|’ may not be a valid setting for the RowSourceType property, or there was a compile error in the function. For information on valid settings for the RowSourceType property, click Help.
Appendixes for Web Site PART VI ErrorCode ErrorString 2281 The formats that enable you to output data as a Microsoft Excel, richtext format, MS-DOS text, or HTML file are missing or incorrectly registered in the Windows Registry. Run Setup to reinstall Microsoft Access or, if you’re familiar with the settings in the Registry, try to correct them yourself. For more information about the Registry, click Help. The format in which you are attempting to output the current object is not available.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2288 Microsoft Access can’t load the ‘|’ format. The setting for this format in the Windows Registry is incorrect. You can’t save the output data to a file in this format until you correct the setting in the Registry. Run Setup to reinstall Microsoft Access or, if you’re familiar with the settings in the Registry, try to correct them yourself. For more information on the Registry, click Help.
Appendixes for Web Site PART VI ErrorCode ErrorString 2300 Microsoft Access can’t output because there are too many controls selected that have different styles, such as color and font. Select fewer controls, and then try again. There are not enough system resources to output the data. Close one or more Microsoft Access windows and close other applications. Then try to output the data again. Microsoft Access can’t save the output data to the file you’ve selected. • The file may be open.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2315 2316 The input string is too long. This table or query can’t be opened because it has no visible fields. This can result if the table or query has only system fields, and the Show System Objects option is off. To turn on the Show System Objects option, click Options on the Tools menu, click the View tab, and select the System Objects check box. The database ‘|’ can’t be repaired or isn’t a Microsoft Access database file.
Appendixes for Web Site PART VI ErrorCode ErrorString 2326 You can’t specify Group By, Expression, or Where in the Total row for this column. Specify an aggregate function, such as Sum or Count, for the field or expression you designate as the Value in the crosstab query. For more information on aggregate functions, click Help. You must enter Group By in the Total row for a field that has Column Heading in the Crosstab row.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2335 You must use the same number of fields when you set the LinkChildFields and LinkMasterFields properties. You entered a different number of fields for one property than you did for the other. If you use the Relationships command (Tools menu) to define a relationship between the tables underlying the form and subform, Microsoft Access will link the form and subform automatically and then set the LinkChildFields and LinkMasterFields properties.
Appendixes for Web Site PART VI ErrorCode ErrorString 2349 For the TopValues property in the query property sheet, you must enter a number smaller than 2,147,483,647. Microsoft Access can’t save the query. • The query is a pass-through query and can’t be represented as a simple SQL string. Save the query as a named query from the Query Builder. When you close the Query Builder, Microsoft Access will fill the RecordSource or RowSource property with the saved query name.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2373 2374 2375 The setting for the FieldSize property must be from 0 through 255. You can’t create an index or primary key on more than 10 fields. You can’t paste beyond the end of a table. You have attempted to paste fields beyond the 255th row in a table in Design view. Microsoft Access can’t create a primary key. You have selected too many fields for a multiple-field primary key.
Appendixes for Web Site PART VI ErrorCode ErrorString 2388 You can’t change the primary key. This table is the primary table in one or more relationships. If you want to change or remove the primary key, first delete the relationship in the Relationships window. You can’t delete the field ‘|.’ It is part of one or more relationships. If you want to delete this field, first delete its relationships in the Relationships window.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2423 The expression you entered has an invalid . (dot) or ! operator or invalid parentheses. You may have entered an invalid identifier or typed parentheses following the Null constant. The expression you entered has a field, control, or property name that Microsoft Access can’t find. The expression you entered has a function name that Microsoft Access can’t find. The function you entered can’t be used in this expression.
Appendixes for Web Site PART VI ErrorCode ErrorString 2436 The expression you entered is missing a closing parenthesis, bracket (]), or vertical bar (|). The expression you entered has invalid vertical bars (|). The expression you entered contains invalid syntax. You omitted an operand or operator, you entered an invalid character or comma, or you entered text without surrounding it in quotation marks. The expression you entered has a function containing the wrong number of arguments.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2451 The report name ‘|’ you entered is misspelled or refers to a report that isn’t open or doesn’t exist. The expression you entered has an invalid reference to the Parent property. For example, you may be using the Parent property with a control on a main form or report rather than with a control on a subform or subreport.
Appendixes for Web Site PART VI ErrorCode ErrorString 2466 The expression you entered has an invalid reference to the Dynaset property. For example, you may have used the Dynaset property with a form that isn’t based on a table or query. The expression you entered refers to an object that is closed or doesn’t exist. For example, you may have assigned a form to a Form object variable, closed the form, and then referred to the object variable.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2475 2476 You entered an expression that requires a form to be the active window. You entered an expression that requires a report to be the active window. You entered an invalid objecttype value ‘|’ in an If TypeOf object Is objecttype condition of an If…Then…Else statement.
Appendixes for Web Site PART VI ErrorCode ErrorString 2486 You can’t carry out this action at the present time. You tried to run a macro or used the DoCmd object in Visual Basic to carry out an action. However, Microsoft Access is performing another activity that prevents this action from being carried out now. For example, no actions on a form can be carried out while Microsoft Access is repainting a control or calculating an expression. Carry out the action later.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2491 The action or method is invalid because the form or report isn’t bound to a table or query. You tried to use the ApplyFilter action or method. However, the form or report you applied the filter to is not based on a table or query, so the form or report doesn’t have any records to apply a filter to. Use the SelectObject action or method to select the desired form or report before you run the ApplyFilter action.
Appendixes for Web Site PART VI ErrorCode ErrorString 2499 You can’t use the GoToRecord action or method on an object in Design view. Try one of the following: • Switch to Form or Datasheet view for a form. • Switch to Datasheet view for a query or table. • If you are running a macro or Visual Basic procedure containing an action that opens the object, set the View argument to the correct view before you carry out the GoToRecord action.
Access 2002 and Jet 4 Errors APPENDIX E ErrorCode 2506 2507 2508 2509 2510 2511 2512 ErrorString • Select a setting from the drop-down list box in each argument. • Use an intrinsic constant equating to a valid object type. • Substitute the correct corresponding expression. A value you entered for the Transfer Type argument is invalid. An expression in the Transfer Type argument doesn’t evaluate to a valid numeric value.
Appendixes for Web Site PART VI ErrorCode ErrorString 2514 The action or method requires a Control Name argument. You tried to use the GoToControl action or method, but you left the control name blank. In the Control Name argument, enter a control or field name from the active form or datasheet. Microsoft Access can’t open the macro ‘|’ because it was saved using a different version of Microsoft Access. Re-create the macro in the current version of Microsoft Access.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2525 A macro can call itself a maximum of 20 times. Your macro contains a RunMacro action that calls the same macro more than 20 times. Use a condition to stop the macro after it has been run 20 times, or call another macro with the RunMacro action. The SendKeys action requires the Microsoft Access Utility Add-in to be loaded. Rerun Microsoft Access or Microsoft Office Setup to reinstall Microsoft Access and the Microsoft Access Utility Add-in. Lotus .
Appendixes for Web Site PART VI ErrorCode ErrorString 2541 The contents of the Clipboard have been deleted and can’t be pasted. Some applications do not put large objects on the Clipboard. Instead, they put a pointer to the object on the Clipboard. The pointer may vanish before the paste happens. Specify the database name in the command line so that Microsoft Access can find the macro. You can’t paste a database object onto itself.
Access 2002 and Jet 4 Errors APPENDIX E ErrorCode 2551 2552 2553 2554 2556 2557 2559 2560 2561 2562 2563 2565 ErrorString read-only status, delete the original database, and then rename the new database using the original name. If you can’t remove the read-only status, inform your workgroup administrator. Microsoft Access can’t delete |1 after decrypting it. The decrypted database has been named |2.
Appendixes for Web Site PART VI ErrorCode ErrorString 2566 Microsoft Access is unable to set the application’s icon to the file ‘|’. Make sure the file is a valid icon (.ico) file. If you’re using Microsoft Windows, you can also use .bmp files. Microsoft Access can’t open or convert this previous version database. The database was created in an earlier version of Microsoft Access. You don’t have appropriate security permissions to open or convert databases created in earlier versions.
Access 2002 and Jet 4 Errors APPENDIX E 2574 2575 2576 2577 2578 2579 2580 2581 2582 2583 E ACCESS 2002 AND JET 4 ERRORS You can’t create another Microsoft Access database with the same name and location as an existing database. You carried out the Make MDE File command, but tried to give the new database the same extension as the old one. Accept the default .mde extension for your new MDE database. You can’t create a Microsoft Access MDE database from a database replica.
Appendixes for Web Site PART VI ErrorCode 2584 2585 2586 2587 2588 2589 2590 2591 2592 ErrorString • You may have tried to run a macro or event procedure on a report that is already open. To use the ApplyFilter action in a report, set the OnOpen property to the name of the macro, close the report, and then reopen it. You can’t use aggregate functions in a page header or footer.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2593 2594 This feature is not available in an MDB. You cannot Filter By Form when form record source is a recordset object. Microsoft Access cannot set this property when DefaultSize property is set to True. Printer object is not available on subforms and subreports. Unable to bind the report to the specified recordset because the shape does not match the sorting and grouping specified on the report.
Appendixes for Web Site PART VI ErrorCode ErrorString 2608 You don’t have permission to copy ‘|.’ To copy this object, you must have Read Design permission for it. If the object is a table, you must also have Read Data permission for it. For more information on permissions and who can set them, click Help. You don’t have permission to delete ‘|.’ To delete this object, you must have Modify Design permission for it. If the object is a table, you must also have Delete Data permission for it.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2618 You need to have the database open for exclusive use to set or unset the database password. To open the database exclusively, close the database, and then reopen it using the Open command on the File menu. In the Open dialog box, click the arrow to the right of the Open button, and then choose Open Exclusive. You can’t change permissions for ‘|’ in a replica. Permissions may only be changed in the Design Master for the replica set.
Appendixes for Web Site PART VI ErrorCode ErrorString 2637 Unable to start SQL Server service. To restart the SQL Server service, double click on the SQL Server System Manager icon in the system tray and click Start/Continue. Once the service is started, point to Connection on the File menu in Access and click OK. Unable to start SQL Server service. To restart the SQL Server service, double click on the SQL Server System Manager icon in the system tray and click Start/Continue.
Access 2002 and Jet 4 Errors APPENDIX E ErrorCode 2651 2652 2680 2683 2684 2685 2686 2687 2690 2691 ErrorString If you want to create the relationship without following the rules of referential integrity, clear the Enforce Referential Integrity check box. You can’t create a relationship between fields with the Memo, OLE Object, Yes/No, or Hyperlink data type.
Appendixes for Web Site PART VI ErrorCode ErrorString 2695 Microsoft Access is unable to display the converted | object. Delete the object in the bound object frame, and then re-create it. Microsoft Access can’t read the OLE object. Delete the object in the bound object frame, and then re-create it. There was a problem loading the | object. The object you tried to create or edit is not a valid OLE object. Re-create the object, and then embed or link it again.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2711 The file name argument in the GetObject function of the Visual Basic procedure you ran is invalid. • You may not have entered, or may have misspelled, the file name. • The unit of data (such as a range of cells from a worksheet) may not be valid. Try one of the following: • Make sure the file is installed on your computer and that you used the correct file name.
Appendixes for Web Site PART VI ErrorCode 2723 2724 2725 2726 2727 2729 ErrorString • The OLE object may be stored in a linked file, but the file isn’t available. Activate the OLE server outside of Microsoft Access, and then open the file containing the OLE object to verify that it still exists and can be accessed. The | object doesn’t support the attempted operation. The OLE object was changed to a picture, or the link to the object was broken.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2730 There was a problem communicating with the OLE server. Try again later. If you still can’t access the object, try one or more of the following: • Free up system memory. For information on freeing memory, search the Microsoft Windows Help index for ‘memory, troubleshooting’. • Reinstall the OLE server to make sure it’s registered. • Check the OLE server’s documentation for information about the syntax to use when specifying an OLE object’s data.
Appendixes for Web Site PART VI ErrorCode ErrorString 2742 Microsoft Access was unable to create more files. Your computer may be low on memory or disk space. Close unneeded programs and try the operation again. For information on freeing memory or disk space, search the Microsoft Windows Help index for ‘memory, troubleshooting’ or ‘disk space, freeing’. The | object is stored in a format that is incompatible with the version of OLE on your computer. Microsoft Access can’t find the OLE server.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2751 The Exit or Update operation failed. You pressed the ESC key (or another key used in the OLE server to stop an operation) while Microsoft Access was saving the changes you made to an OLE object in a form or report. Try to exit or update again. A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control. Close the OLE server and restart it outside of Microsoft Access.
Appendixes for Web Site PART VI ErrorCode 2759 2760 2761 2762 2763 2764 ErrorString • You may have too many Microsoft applications open. Close Windows applications other than Microsoft Access, and try the OLE operation again. • Your computer may have an older version of the dynamic-link library Msole20, in which case you will need to run Setup to reinstall Microsoft Access.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2765 Visual Basic can’t convert the data type of one of the arguments you entered. You tried to run a Visual Basic procedure that executes a method or sets a property of an object. Check the component’s documentation for information on the properties and methods it makes available for Automation operations. The object doesn’t contain the Automation object ‘|.’ You tried to run a Visual Basic procedure to set a property or method for an object.
Appendixes for Web Site PART VI ErrorCode ErrorString 2777 The class argument in the CreateObject function of the Visual Basic procedure you’re trying to run is invalid. Try one of the following: • Make sure the file is installed on your computer and that you used the correct file name. • Check the OLE server’s documentation for information about the syntax to use when specifying an OLE object’s data. Microsoft Access tried to create an OLE link, but there was no source document for this object.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2792 2793 You can’t save a locked OLE object. Microsoft Access can’t perform the operation specified in the Action property of the Visual Basic procedure you’re trying to run. The object frame may be locked or disabled. Set the Locked property to No and the Enabled property to Yes. The ActiveX control you tried to insert isn’t registered. For information on registering an ActiveX control, click Help.
Appendixes for Web Site PART VI ErrorCode ErrorString 2804 You can’t create an ActiveX control in an unbound object frame. ActiveX controls are automatically contained in ActiveX control frames. There was an error loading an ActiveX control on one of your forms or reports. Make sure all the controls that you are using are properly registered. For information on registering an ActiveX control, click Help. Microsoft Access doesn’t support this ActiveX control.
Access 2002 and Jet 4 Errors APPENDIX E ErrorCode ErrorString 2828 2832 | File write error. The disk may be full. | Check file permissions and delete them from their location in your computer’s file system. | An unexpected error has occurred. | An attempt to create this file has failed. Please select another location and retry the operation. | There was not enough memory. Please close other applications and try the operation again. Microsoft Access is unable to preview the selected theme.
Appendixes for Web Site PART VI ErrorCode ErrorString 2860 You cannot insert a bound field to a caption or record navigation s ection. Microsoft Access is unable to preview the selected web page. The file you attempted to load was not recognized as HTML. You may have selected the wrong file, or tried to open a database file off of a web server. | Unable to create or load a file due to network or access permission problems.
Access 2002 and Jet 4 Errors APPENDIX E ErrorCode 2878 2879 2880 2881 2882 2883 2884 2885 2886 2887 2888 2889 2890 2892 ErrorString2877 In a Microsoft Access database (.mdb), you can’t group on a control bound to a field that has a Memo or OLE Object data type. In a Microsoft Access project (.adp), you can’t group on a control bound to a field that has an Image or Text data type. You cannot add a bound field to a caption or record navigation section.
Appendixes for Web Site PART VI ErrorCode ErrorString 2894 The link to the data access page specified could not be updated because the database cannot be exclusively locked. To update the link, open this page again when you are the only person using the database. This page was designed with a later version of the Microsoft Office Web Components than those currently installed on your machine.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 2911 You cannot change the data access page path while it is open. Please close the page and try again. If you create a data access page in this version of Microsoft Access, you can’t open it in Design view in Access 2000. However, you can open the page in Page view in Access 2000, if you have installed the Microsoft Office 2002 Web Components. Cannot save to a URL address with a bookmark. Please specify a valid path.
Appendixes for Web Site PART VI ErrorCode ErrorString 3009 You tried to lock table ‘|’ while opening it, but the table cannot be locked because it is currently in use. Wait a moment, and then try the operation again. Table ‘|’ already exists. The Microsoft Jet database engine could not find the object ‘|’. Make sure the object exists and that you spell its name and the path name correctly. Object ‘|’ already exists. Could not rename installable ISAM file. Cannot open any more tables.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 3034 You tried to commit or rollback a transaction without first beginning a transaction. System resource exceeded. Database has reached maximum size. Cannot open any more tables or queries. System resource exceeded. Could not create index; too many indexes already defined. Disk I/O error during read. Cannot open a database created with a previous version of your application. Out of MS-DOS file handles. Disk or network error. ‘|’ is not a valid path.
Appendixes for Web Site PART VI ErrorCode ErrorString 3061 3062 3063 3064 3065 3066 3067 3068 3069 3070 Too few parameters. Expected |. Duplicate output alias ‘|’. Duplicate output destination ‘|’. Cannot open action query ‘|’. Cannot execute a select query. Query must have at least one destination field. Query input must contain at least one table or query. Not a valid alias name. The action query ‘|’ cannot be used as a row source.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 3088 3089 3090 3091 3092 3093 3094 3095 3096 3097 3098 3099 3100 3101 Too many expressions in ORDER BY clause. Too many expressions in DISTINCT output. Resultant table not allowed to have more than one AutoNumber field. HAVING clause (|) without grouping or aggregation. Cannot use HAVING clause in TRANSFORM statement. ORDER BY clause (|) conflicts with DISTINCT. ORDER BY clause (|) conflicts with GROUP BY clause.
Appendixes for Web Site PART VI ErrorCode ErrorString 3116 Cannot have Memo, OLE, or Hyperlink Object fields in criteria (|) for aggregate function. Cannot sort on Memo, OLE, or Hyperlink Object (|). Cannot join on Memo, OLE, or Hyperlink Object (|). Cannot group on Memo, OLE, or Hyperlink Object (|). Cannot group on fields selected with ‘•’ (|). Cannot group on fields selected with ‘•’. You tried to execute a query that does not include the specified expression ‘|’ as part of an aggregate function.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 3142 3143 3144 3145 3146 3151 3154 3155 3156 3157 3158 3159 3160 3161 3162 Characters found after end of SQL statement. Syntax error in TRANSFORM statement. Syntax error in UPDATE statement. Syntax error in WHERE clause. ODBC—call failed. ODBC—connection to ‘|’ failed. ODBC—could not find DLL ‘|’. ODBC—insert on a linked table ‘|’ failed. ODBC—delete on a linked table ‘|’ failed. ODBC—update on a linked table ‘|’ failed.
Appendixes for Web Site PART VI ErrorCode ErrorString 3177 3179 3180 3181 3182 3183 3184 3185 3186 3187 3188 3189 3190 3191 3192 3193 3194 3195 3196 Not a valid table name. Encountered unexpected end of file. Could not write to file ‘|’. Invalid range. Invalid file format. Not enough space on temporary disk. Could not execute query; could not find linked table. SELECT INTO on a remote database tried to produce too many fields. Could not save; currently locked by user ‘|2’ on machine ‘|1’.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 3206 3207 3208 3209 3210 3211 Cannot create a relationship between a field and itself. Operation not supported on a Paradox table with no primary key. Invalid Deleted setting in the Xbase key of the Windows Registry. •••••••••• The connection string is too long. The database engine could not lock table ‘|’ because it is already in use by another person or process. Could not lock table ‘|1’; currently in use by user ‘|3’ on machine ‘|2’.
Appendixes for Web Site PART VI ErrorCode ErrorString 3240 3241 3242 3243 3244 3245 3246 3247 3248 3249 3250 3251 3252 Btrieve—missing Btrieve engine. Btrieve—out of resources. Invalid reference in SELECT statement. None of the import field names match fields in the appended table. Cannot import password-protected spreadsheet. Could not parse field names from the first row of the import table. Operation not supported in transactions. ODBC—linked table definition has changed.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 3270 3271 3272 3273 3274 3275 3276 3277 3278 3279 3280 Property not found. Invalid property value. Object is not a collection. Method not applicable for this object. External table is not in the expected format. Unexpected error from external database driver (|). Invalid database object reference. Cannot have more than 10 fields in an index. The Microsoft Jet database engine has not been initialized.
Appendixes for Web Site PART VI ErrorCode ErrorString 3299 ODBC Specification Conformance Error (|). Report this error to the developer of your application. Cannot create a relationship. Cannot perform this operation; features in this version are not available in databases with older formats. Cannot change a rule while the rules for this table are in use. Cannot delete this field. It is part of one or more relationships.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 3322 3323 3324 3325 Crosstab query contains one or more invalid fixed column headings. The query cannot be used as a row source. The query is a DDL query and cannot be used as a row source. Pass-through query with ReturnsRecords property set to True did not return any records. This Recordset is not updateable. Field ‘|’ is based on an expression and cannot be edited. Table ‘|2’ is read-only. Record in table ‘|’ was deleted by another user.
Appendixes for Web Site PART VI ErrorCode ErrorString 3350 3351 Object is invalid for operation. The ORDER BY expression (|) includes fields that are not selected by the query. Only those fields requested in the first query can be included in an ORDER BY expression. No destination field name in INSERT INTO statement (|). Btrieve: Cannot find file Field.ddf. At most one record can be returned by this subquery. Syntax error in default value.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 3376 3377 3378 3379 Table ‘|’ does not exist. No such relationship ‘|2’ on table ‘|1’. There is already a relationship named ‘|’ in the current database. Cannot create relationships to enforce referential integrity. Existing data in table ‘|2’ violates referential integrity rules in table ‘|1’. Field ‘|2’ already exists in table ‘|1’. There is no field named ‘|2’ in table ‘|1’. Size of field ‘|’ is too long. Cannot delete field ‘|’.
Appendixes for Web Site PART VI ErrorCode ErrorString 3402 Cannot perform cascading operation. It would cause field ‘|’ to become a zero-length string, which is not allowed. Cannot perform cascading operation: ‘|’. Cannot perform cascading operation. The value entered is prohibited by the validation rule ‘|2’ set for ‘|1’. Error ‘|’ in validation rule. The expression you are trying to use for the DefaultValue property is invalid because ‘|’. Use a valid expression to set this property.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 3426 3427 3428 This action was cancelled by an associated object. Error in DAO automation. A problem occurred in your database. Correct the problem by repairing and compacting the database. Incompatible version of an installable ISAM. While loading the Microsoft Excel installable ISAM, OLE was unable to initialize. This is not a Microsoft Excel 5.0 file. Error opening a Microsoft Excel 5.0 file.
Appendixes for Web Site PART VI ErrorCode ErrorString 3448 A call to an OLE system function was not successful. Try reinstalling the application that returned the error. No country code found in connection string for a linked table. Syntax error in query. Incomplete query clause. Illegal reference in query. You cannot make changes to the design of the database at this replica. You cannot establish or maintain an enforced relationship between a replicated table and a local table.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 3477 3478 3479 Dropbox address ‘|2’ is syntactically invalid. The replica is not a partial replica. Cannot designate a partial replica as the Design Master for the replica set. The relationship ‘|’ in the partial filter expression is invalid. The table name ‘|’ in the partial filter expression is invalid. The filter expression for the partial replica is invalid. The password supplied for the dropbox folder ‘|2’ is invalid.
Appendixes for Web Site PART VI ErrorCode ErrorString 3502 3503 3504 The Design Master or replica is not being managed by a Synchronizer. The Synchronizer’s Registry has no value set for the key you queried. The Synchronizer ID does not match an existing ID in the MSysTranspAddress table. You attempted to delete or get information about a partial filter that does not exist in MSysFilters. The Synchronizer is unable to open the Synchronizer log. Failure writing to the Synchronizer log.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 3526 3527 The name selected for the system object is already in use. The Synchronizer or Replication Manager could not find the system object. There is no new data in shared memory for the Synchronizer or Replication Manager to read. The Synchronizer or Replication Manager found unread data in the shared memory. The existing data will be overwritten. The Synchronizer is already serving a client. The wait period for an event has timed out.
Appendixes for Web Site PART VI ErrorCode ErrorString 3551 3552 3553 3555 3556 3557 3558 3559 3560 Unable to delete the specified Registry parameter for the Synchronizer. The size of the Registry parameter exceeds the maximum allowed. The GUID could not be created. All valid nicknames for replicas are already in use. Invalid path for destination dropbox folder. Invalid address for destination dropbox folder. Disk I/O error at destination dropbox folder.
Access 2002 and Jet 4 Errors APPENDIX E ErrorCode ErrorString 3577 3578 Cannot update replication system column. Failure to replicate database; cannot determine whether the database is open in exclusive mode. Could not create replication system tables needed to make the database replicable. Could not add rows needed to make the database replicable. Cannot open replication system table ‘|’ because the table is already in use.
Appendixes for Web Site PART VI ErrorCode ErrorString 3610 Same table ‘|’ referenced as both the source and destination in maketable query. Cannot execute data definition statements on linked data sources. Multi-level GROUP BY clause is not allowed in a subquery. Cannot create a relationship on linked ODBC tables. GUID not allowed in Find method criteria expression. Type mismatch in expression. Updating data in a linked table is not supported by this ISAM.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 3637 3638 3639 3640 3641 3642 3643 3645 3646 3647 3648 3649 Cannot use the crosstab of a non-fixed column as a subquery. A Source Controlled database cannot be made replicable. Cannot create a replica of a System database. The fetch buffer was too small for the amount of data you requested. There are fewer records remaining in the recordset than you requested. A cancel was performed on the operation.
Appendixes for Web Site PART VI ErrorCode ErrorString 3668 3669 3670 3671 3672 3673 Cannot perform this operation because there is no active connection. Execution cancelled. Cursor is not valid. Cannot find table to update. Failed to load RDOCURS.DLL. This table contains cells that are outside the range of cells defined in this spreadsheet. Internet dll (wininet.dll) could not be found or loaded. Failure to read from an internet handle. Try the operation again.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 3691 3692 Invalid SQL syntax—expected an object name. Invalid SQL syntax—related tokens did not match. Jet expected GRANT…TO, REVOKE…FROM, ADD…TO, or DROP…FROM. Invalid SQL syntax—expected user or group name. Invalid SQL syntax—expected token: Grant. Invalid SQL syntax—GRANT/REVOKE syntax error. Invalid SQL syntax—expected token: User (or) Group. Invalid SQL syntax—expected token: Password. Invalid SQL syntax—expected password.
Appendixes for Web Site PART VI ErrorCode ErrorString 3714 Locked table. This record could not be applied during synchronization since the table was locked by another user. Resubmit this conflict record. Unique key violation. This record has the same key value as another record, whereas only unique values are permitted. Either change the key value in this conflict record or the winning record and then resubmit this record, or delete this conflict record. TLV violation.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 3727 Invalid SQL syntax—only one update rule and/or one delete rule allowed. Invalid SQL syntax—expected token: AS. Invalid SQL syntax—expected token: SELECT. VIEW cannot contain a parameter. The number of aliases specified shall be the same as the number of output columns. Expected query name after EXECUTE. The database has been placed in a state by an unknown user that prevents it from being opened or locked.
Appendixes for Web Site PART VI ErrorCode ErrorString 3750 3751 3752 3753 3754 3755 3756 3757 3758 3759 3760 3761 Object | is not a stored procedure. Requested row locking, but DB is in page lock mode. Requested page locking, but DB is in row lock mode. Cannot create replica of a Jet SQL replica. Cannot delete from a Prevent Deletes Replica. CHECK constraint ‘|’ does not exist. CHECK constraint ‘|’ already exists. The Jet sorting DLLs could not be loaded properly.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 3779 Unable to change Column Level Tracking Property on objects that are already Replicable. Invalid SQL syntax—expected a view name. Invalid SQL syntax—expected a procedure name. Invalid SQL syntax—currently only one column-level CHECK constraint is allowed. Invalid SQL syntax—cannot use multiple columns in a column-level CHECK constraint. Database is already replicable. Invalid SQL syntax—expected token: Database.
Appendixes for Web Site PART VI ErrorCode ErrorString 3804 There are no MAPI clients installed on this machine. Install a MAPI client (like Outlook) on this machine. CHECK constraints on table | will not be transferred to this table. CHECK constraints can only be created via SQL DDL statements. Cannot set multiple NULL, NOT NULL attributes. Query | contains an ambiguous column name that is conflicting with the correlation (alias) name |.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 6013 6014 Unable to remove item. ‘|’ not found in list. The RowSourceType property must be set to ‘Value List’ to use this method. Can’t add this item. The index is too large. Microsoft Access is unable to switch to PivotTable or PivotChart view right now. You must set the Record Source property of the form before attempting to PivotTable or PivotChart view. Microsoft Access doesn’t support the requested property for this type of database object.
Appendixes for Web Site PART VI ErrorCode ErrorString 7701 Microsoft Access can’t synchronize with Synchronizer ‘|1.’ A possible reason for the failure to synchronize with ‘|1’ is that both the Synchronizer and Microsoft Access were trying to write to the current database at the same time. Try synchronizing with ‘|1’ again.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 7712 This member of the replica set has exceeded the maximum number of days allowed between synchronizations and can’t be synchronized with any other member of the replica set. Delete this replica set member and create a new replica. This member of the replica set will expire in | days because it hasn’t been synchronized with another member of the replica set.
Appendixes for Web Site PART VI ErrorCode ErrorString 7722 All open objects must be closed before creating a replica. Do you want Microsoft Access to close the objects? Microsoft Access couldn’t close one or more objects. Close all objects manually and try again. Microsoft Access has converted ‘|1’ to the Design Master for the replica set. Only the Design Master can accept changes to the database structure; however, data changes can be made at the Design Master or any replica.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 7735 Changes to this object can be made only at the Design Master. Any changes you make will be discarded when the form is closed. To save your changes, click Save As on the File menu and save the object under a different name. Microsoft Access has deleted ‘|’ and removed it from the replica set. This change isn’t reflected until the database is closed and reopened.
Appendixes for Web Site PART VI ErrorCode ErrorString 7747 Database Replicas cannot be converted to prior versions of Microsoft Access. This stage of the conversion process is finished. To complete the conversion process, synchronize this replica to the (converted) Design Master. Open the Design Master and sync to this replica before opening. In Datasheet view, you can’t set a control property if the control is part of an option group.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 7759 This ActiveX control isn’t visible in Form view. You can’t set the Visible or TabStop properties to True. This property is locked and can’t be changed. An error occurred when you changed the control. The pattern string is invalid. This feature isn’t installed, or has been disabled. To install this feature, rerun the Microsoft Access or Microsoft Office Setup program or, if you’re using a third-party add-in, reinstall the add-in.
Appendixes for Web Site PART VI ErrorCode ErrorString 7773 Microsoft Access can’t set the LimitToList property to No right now. The first visible column, which is determined by the ColumnWidths property, isn’t equal to the bound column. Adjust the ColumnWidths property first, and then set the LimitToList property. You can’t set the MenuBar property while an OLE object is in-place active. There are too many controls on the form to allow Filter By Form. You’ve used the ListIndex property incorrectly.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 7792 7793 7794 7795 You can’t open a subform when it is also open in Design view. You must save the form ‘|’ before you can embed it. Microsoft Access couldn’t find the toolbar ‘|’. The custom toolbar ‘|’ is the wrong type (menu, shortcut menu, or toolbar) for the property it’s being used in. The process failed because there is no printer installed.
Appendixes for Web Site PART VI ErrorCode ErrorString 7809 You can’t rename a | object in the client/server version of Microsoft Access. You can’t compact the open database while running a macro or Visual Basic code. Instead of using a macro or code, on the Tools menu, point to Database Utilities, and then click Compact/Repair Database. Microsoft Access requires Microsoft SQL Server 6.5 or later for Access projects. You need to upgrade the selected SQL database to Microsoft SQL Server 6.5 or later.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 7825 7826 Microsoft Access can’t find the server ‘|’. The database object type isn’t supported by the Microsoft Access transfer operation. The current database ‘|1’ has |2 active connections. Microsoft Access must disconnect all applications before you can copy the database file. What do you want to do to all the active connections? The object ‘|’ is not a valid Microsoft SQL Server database object. Microsoft Access can’t transfer this object.
Appendixes for Web Site PART VI ErrorCode ErrorString 7843 You can only copy the database file when the current database is on your local computer. If you want to make a copy of a database on a remote server point to Database Utilities on the Tools menu, and then click Transfer Database. Microsoft Access can’t copy the database file because there are active connections to the current database. | Microsoft Access can’t compact and repair the current database. ‘|’ already exists.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 7855 You must have a database open to create custom toolbars, and the database can’t be read-only. ‘|’ cannot be imported, exported, or copied to Access project files. The Tab Width setting in the Options dialog box (Tools menu) for the Module or Debug window must be from 1 through 32. Microsoft Access can’t start because there is no license for it on this machine.
Appendixes for Web Site PART VI ErrorCode ErrorString 7874 Microsoft Access can’t find the object ‘|.’ • You misspelled the object name. Check for missing underscores ( _ ) or other punctuation, and make sure you didn’t enter leading spaces. • You tried to open a linked table, but the file containing the table isn’t on the path you specified. Use the Linked Table Manager to update the link and point to the correct path. The table ‘|’ already exists.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 7885 7886 The source database has no import/export specifications to copy. Microsoft Access can’t find the dynamic-link library (DLL) Mso. Rerun the Microsoft Access or Microsoft Office Setup program. A unique record identifier can’t consist of more than 10 fields. You must set the default font size to a number from |1 through |2. For more information on the FontSize property, click Help. The file ‘|’ does not exist.
Appendixes for Web Site PART VI ErrorCode ErrorString 7903 Microsoft Access can’t insert this field. There are too many fields in the table. The limit is 255. An error occurred in the Field Builder. You’ve replaced or modified the default Field Builder, and Microsoft Access is unable to run the new version. Reinstall Microsoft Access to correct the error. Microsoft Access can’t change these field data types. Some data in this table violates the record validation rule.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 7917 ‘|’ cannot be created due to the project being disconnected. Use the Connection… command under the File menu to connect the project to a database. The Object Name argument for the ‘Save’ macro action is not supported within an Access Project for Table or Query objects. You cannot save these objects with a new name in an Access Project. The default data type you selected is not supported in all versions of Microsoft SQL Server.
Appendixes for Web Site PART VI ErrorCode ErrorString 7959 The expression contains an ambiguous name. You may have two or more functions with the same name in different modules. Rename the functions so that each one has a unique name. There was an error compiling this function. The Visual Basic module contains a syntax error. Check the code, and then recompile it. Microsoft Access can’t find the module ‘|’ referred to in a macro expression or Visual Basic code.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 7974 7975 Microsoft Access failed to insert a hyperlink at the current location. You chose an invalid control type for use with hyperlinks. You can only use hyperlinks with labels, images, command buttons, or bound text boxes. There is no stored hyperlink in this control. Microsoft Access is unable to paste the data on the clipboard as a hyperlink. Microsoft Access is unable to add the current hyperlink to the favorites folder.
Appendixes for Web Site PART VI ErrorCode 7997 7998 7999 8000 8001 8002 8003 8004 ErrorString Objects, use the Linked Table Manager (Tools menu, Add-ins submenu) to update the link to the source table or file, or delete the link from your current database. You can’t save the standard module ‘|’ over a class module with the same name. Save the standard module to a different name, or delete the class module first. You can’t save the class module ‘|’ over a standard module with the same name.
Access 2002 and Jet 4 Errors APPENDIX E ErrorCode ErrorString 8005 You can’t save this object. You must have Administer permission for the Database object in order to save modules, forms, or reports in a Design Master. The name you entered already exists for another object of the same type in this database. Do you want to replace the existing |? You will not be able to undo this operation.
Appendixes for Web Site PART VI ErrorCode ErrorString 8063 The source application isn’t responding. Do you want to continue waiting? The DDE channel is established, but the data exchange wasn’t completed in the amount of time specified in the OLE/DDE Timeout setting in the Options dialog box (Tools menu). • To continue waiting for the data exchange to be completed, click Yes. • To cancel the data exchange and try again later, click No.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 8077 8078 Are you sure you want to cut the |? This object will be removed from your local database, but not from source code control. The next time you get this database from source code control, the object will reappear. Are you sure that you want to delete the local object? Microsoft Access was not able to add a reference to the type library for this control because Data and Misc. Objects is not checked out. Check out the Data and Misc.
Appendixes for Web Site PART VI ErrorCode ErrorString 8093 Send a pointer to the data access page? To send an e-mail message that contains a pointer to your data access page, click Send Pointer. This is the recommended method. The e-mail recipient must have access to the server or public share to view the page. To send a copy of the page, click Send Copy. To cancel sending the page, click Cancel. For more information, click Help.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 8403 The setting you entered is invalid. The database’s sort order can’t be updated. The setting you entered in the New Database Sort Order option of the Options dialog box (Tools menu) isn’t a valid sort order for the version of the database you are compacting. You can’t open ‘|’ for exclusive use because another user has the database open or because you do not have permissions to open exclusively.
Appendixes for Web Site PART VI ErrorCode ErrorString 8416 Renaming this user-defined function removes any existing permissions and extended properties. Do you want to complete the rename action? A form with a subform object can’t have its DefaultView property set to Continuous Forms. You tried to add a subform to a form in Design view. Microsoft Access will reset the property to Single Form. You can’t modify this field because it is read-only.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 8512 None of the field names you pasted onto the Clipboard match the field names on the form. Microsoft Access treats the data in the first row on the Clipboard as field names. If you copied the data from another application, the first row of data may have taken the place of the field names.
Appendixes for Web Site PART VI ErrorCode ErrorString 8523 Do you want to delete the custom palette information from this form or report and revert to the default palette? Do you want to delete the graphic from this button? The remote data isn’t accessible. You tried to open a form or report that includes a DDE or DDESend function in a calculated control that specifies an OLE server application.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 8538 You are about to delete this section. If you click Yes, the controls you placed in this section will be deleted. Are you sure you want to delete these controls? Relationships that specify cascading deletes are about to cause record(s) in this table and in related tables to be deleted. Are you sure you want to delete these records? You are about to delete one or more records. If you click Yes, you won’t be able to undo this Delete operation.
Appendixes for Web Site PART VI ErrorCode ErrorString 9508 Microsoft Access couldn’t close database ‘|.’ Your last change may not have been saved because an internal buffer was locked by another user (whose name was given in the previous message). To avoid losing data, wait for the other user to finish using the record, and then click OK again. If you click Cancel, you may lose changes that haven’t been saved.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 9525 Microsoft Access can’t open the main dictionary file. Verify that this file has been correctly installed. The spelling checker only works on text fields that contain text data. You’re trying to check a field with a data type other than Text or Memo. The spelling checker can’t proceed; you must first select data from a table, query, view, stored procedure, or form. The spelling checker can’t proceed; form data is not updateable.
Appendixes for Web Site PART VI ErrorCode ErrorString 9543 The Hangul Hanja Converter can’t proceed. There is no Hangul or Hanja data to convert. Microsoft Access can’t register the ‘|’ custom dictionary. After you have converted this file to Access 2002 File Format, the new file cannot be shared with Access 2000 users or Access 97 users. For more information about conversion, click Help. This data access page was created in a previous version of Microsoft Access.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 10009 You can’t open the table ‘|’ for modification. A query or form bound to the table is open, you may not have permission to open this table in Design view, or another user has the table open. Do you want to open this table as read-only? If you have opened a query or form bound to this table, close it, and then try again to open the table in Design view. Table ‘|’ is a linked table with some properties that can’t be modified.
Appendixes for Web Site PART VI ErrorCode ErrorString 10017 Your computer is out of disk space. You won’t be able to undo this paste append. Do you want to continue anyway? Microsoft Access was unable to append all the data to the table. The contents of fields in |1 record(s) were deleted, and |2 record(s) were lost due to key violations. • If data was deleted, the data you pasted or imported doesn’t match the field data types or the FieldSize property in the destination table.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 10027 Existing data violates the new record validation rule. Do you want to continue testing data with this new rule? • To continue testing for other new rule violations, click Yes. • To continue to test only the old validation rules, click No. • To stop testing, click Cancel. The existing data violates the ‘|1’ property for field ‘|2.’ If you continue testing, Microsoft Access will inform you if data violates any other property settings in the table.
Appendixes for Web Site PART VI ErrorCode ErrorString 10252 At least one column is too wide to fit on the page. Data in that column will be cut off. Do you want to print the column with incomplete data? To prevent data from being cut off, try one or more of the following: • Decrease the column width and increase the row height. • Change the page orientation to Landscape in the printer Properties dialog box. • Decrease the size of the left and right page margins in the Page Setup dialog box.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 10506 You are about to append | row(s). Once you click Yes, you can’t use the Undo command to reverse the changes. Are you sure you want to append the selected rows? You are about to paste | row(s) into a new table. Once you click Yes, you can’t use the Undo command to reverse the changes. Are you sure you want to create a new table with the selected records? You are about to delete | row(s) from the specified table.
Appendixes for Web Site PART VI ErrorCode ErrorString 10513 The existing | will be deleted before you run the query. Do you want to continue anyway? You won’t be able to undo the changes this action query is about to make to the data in a linked table or tables. Do you want to run this action query anyway? Microsoft Access was unable to update all the records in the update query.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 10522 You invoked the Query Builder on a table. Do you want to create a query based on the table? You are about to run a pass-through query that may modify data in your table. Are you sure you want to run this type of an SQL query? For information on how to prevent this message from displaying every time you run an SQL query, click Help. | output column(s) in the query were unnamed and will not show any data.
Appendixes for Web Site PART VI ErrorCode ErrorString 10608 To create a relationship, use the mouse to drag a field from one table to another. This document was previously formatted for the printer |1 on |2, but that printer isn’t available. Do you want to use the default printer |3 on |4? This document was previously formatted for the printer ‘|1 on |2’, but that printer isn’t available. The page settings shown in the Print Setup dialog box are for the current default printer ‘|3 on |4’.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 10892 A form with a bound ActiveX control or an embedded object bound to a data source can’t have its DefaultView property set to Continuous Forms. You tried to add a bound ActiveX control to a form in Design view. Microsoft Access will reset the DefaultView property to Single Form. Either the data access page file has been opened by another user or you don’t have write permission to the file.
Appendixes for Web Site PART VI ErrorCode ErrorString 10905 You have opened a page that was last designed using Access 2000. The page must be saved using Office 2002 Office Web Components before you can edit this document. Would you like to convert this page? Are you sure you want to delete this account? You can’t undo the deletion of a user or group account. To restore a user or group account that has been deleted, you must recreate the account using the same name and personal identifier (PID).
Access 2002 and Jet 4 Errors APPENDIX E ErrorCode ErrorString 10965 It is strongly recommended that you change the system administrator (SA) password when this operation is complete. To change the SA password point to Security on the Tools menu, and then click Set Login Password. There isn’t enough memory to create an input area. Close unneeded programs. Then try to create the input area again. For more information on freeing memory, search the Microsoft Windows Help index for ‘memory, troubleshooting’.
Appendixes for Web Site PART VI ErrorCode ErrorString 29013 This action will reset the current code in break mode. Do you want to stop the running code? • To halt the execution of the program so the Module window can be closed, select Yes. • To leave the code in the current state, select No. You can’t add a reference to a Microsoft Access workgroup. You can’t remove this reference. Microsoft Access needs this reference in order to work properly. You can’t add a reference to the open database.
Access 2002 and Jet 4 Errors APPENDIX E ErrorCode 29025 29026 29027 29028 29029 ErrorString • Your user account must have Open/Run and Open Exclusive permissions for the database object. • Your user account must have Modify Design or Administer permissions for all tables in the database, or it must be the owner of all tables in the database. • Your user account must have Read Design permission for all objects in the database. • Request that other users close the database.
Appendixes for Web Site PART VI ErrorCode ErrorString 29031 Microsoft Access can’t create or open the requested database now. The database may be locked exclusively by another user. The ‘|’ module is open; Microsoft Access can’t set the permissions on an open module. Microsoft Access can’t add references to a replicated database; changes will be ignored. Microsoft Access is unable to import the module from the source replica. Synchronize the source database.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 29049 You can’t refer to a form or report module from Form view or Report preview if the form’s or report’s HasModule property is set to No. Switch to Design view or set the HasModule property to Yes in order to refer to the module. Microsoft Access couldn’t compile this database because one or more references couldn’t be resolved. The database has not been saved in a compiled state.
Appendixes for Web Site PART VI ErrorCode ErrorString 29057 The database ‘|’ is read-only and the Visual Basic for Applications project does not match your version of Visual Basic. You need to open the database read-write in order to upgrade the Visual Basic for Applications project in this database. You can’t create a module for a form or report while an instance of the form or report is in browse mode. Microsoft Access was unable do display the module. File not found.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 29071 29072 Missing or broken VBE reference to the file ‘|1’. Microsoft Access has detected corruption in this file. To try to repair the corruption, first make a backup copy of the file. Then, on the Tools menu, point to Database Utilities and click Compact and Repair Database. If you are currently trying to repair this corruption then you will need to recreate this file or restore it from a previous backup.
Appendixes for Web Site PART VI ErrorCode ErrorString 30014 The data was added to the database but the data won’t be displayed in the form because it doesn’t satisfy the criteria in the underlying record source. The specified record source contains duplicate names for some output fields. Use aliases in your SELECT statement to give each field a unique name. The field ‘|’ is read only. This database is not enabled for publication. Cannot create objects of type ‘|’ against current SQL backend.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 31500 Microsoft Access can’t send this format in a mail message. To send this format in a mail message, click Export on the File menu, or use the OutputTo method to create the files and attach them to a mail message. Microsoft Access can’t find the Microsoft Office international dynamic-link library (DLL). Reinstall Microsoft Office. Invalid field data type. Cannot load the Office Web Components.
Appendixes for Web Site PART VI ErrorCode 31516 31517 31518 31519 31520 31521 31522 31523 31524 31525 31526 ErrorString It is recommended that you change the SQL Server Compatible Syntax (ANSI 92) setting before converting this database to the Access 2000 file format. Select Cancel to abort the conversion process and change the SQL Server Compatible Syntax (ANSI 92) setting.
Access 2002 and Jet 4 Errors APPENDIX E ErrorString 31527 31528 31529 31530 31531 Path not found: |. Table ‘|’ is in use. Please close the table and retry import. View ‘|’ is in use. Please close the view and retry import. Procedure ‘|’ is in use. Please close the procedure and retry import. Microsoft Access cannot create table(s) using the information contained in the document(s) you are trying to import. Microsoft Access was unable to export the data. Invalid filename.
Appendixes for Web Site PART VI ErrorCode ErrorString 31543 The startup action associated with this file may not be safe. If you choose not to execute the startup action, Microsoft Access will not open the file. Do you want to execute the startup action and open the file? Microsoft Access cannot open this file. The author of this file has set it to open only when a startup action is executed, and Microsoft Access is currently set to disable startup actions.