Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Trappable Microsoft Jet Errors (Read 7390 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Trappable Microsoft Jet Errors
17.08.14 at 10:05:11
 
Trappable Microsoft Jet Errors: 0-2999
 
Code      Message
2420      Syntax error in number.
2421      Syntax error in date.
2422      Syntax error in string.
2423      Invalid use of '.', '!', or '()'.
2424      Unknown name.
2425      Unknown function name.
2426      Function is not available in expressions.
2427      Object has no value.
2428      Invalid arguments used with domain function.
2429      In operator without ().
2430      Between operator without And.
2431      Syntax error (missing operator).
2432      Syntax error (comma).
2433      Syntax error.
2434      Syntax error (missing operator).
2435      Extra ).
2436      Missing ), ], or Item.
2437      Invalid use of vertical bars.
2438      Syntax error.
2439      Wrong number of arguments used with function.
2440      IIF function without ().
2442      Invalid use of parentheses.
2443      Invalid use of Is operator.
2445      Expression too complex.
2446      Out of memory during calculation.
2447      Invalid use of '.', '!', or '()'.
2448      Cannot set value.
 
Source:
http://msdn.microsoft.com/en-us/library/bb221208%28v=office.12%29.aspx
Back to top
 
« Last Edit: 17.08.14 at 10:06:22 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Trappable Microsoft Jet Errors (3000+)
Reply #1 - 17.08.14 at 10:11:26
 
Trappable Microsoft Jet Errors: 3000-3149
 
Code      Message
3000      Reserved error <Item>; there is no message for this error.
3001      Invalid argument.
3002      Could not start session.
3003      Could not start transaction; too many transactions already nested.
3005      <Database name> is not a valid database name.
3006      Database <name> is exclusively locked.
3007      Cannot open library database <name>.
3008      The table <name> is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically.
3009      You tried to lock table <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.
3010      Table <name> already exists.
3011      The Microsoft Jet database engine could not find the object <name>. Make sure the object exists and that you spell its name and the path name correctly.
3012      Object <name> already exists.
3013      Could not rename installable ISAM file.
3014      Cannot open any more tables.
3015      Index not found.
3016      Field will not fit in record.
3017      The size of a field is too long.
3018      Could not find field.
3019      Operation invalid without a current index.
3020      Update or CancelUpdate without AddNew or Edit.
3021      No current record.
3022      The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
3023      AddNew or Edit already used.
3024      Could not find file <name>.
3025      Cannot open any more files.
3026      Not enough space on disk.
3027      Cannot update. Database or object is read-only.
3028      Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
3029      Not a valid account name or password.
3030      <Account name> is not a valid account name.
3031      Not a valid password.
3032      Cannot perform this operation.
3033      You do not have the necessary permissions to use the <name> object. Have your system administrator or the person who created this object establish the appropriate permissions for you.
3034      You tried to commit or rollback a transaction without first beginning a transaction.
3036      Database has reached maximum size.
3037      Cannot open any more tables or queries.
3039      Could not create index; too many indexes already defined.
3040      Disk I/O error during read.
3041      Cannot open a database created with a previous version of your application.
3042      Out of MS-DOS file handles.
3043      Disk or network error.
3044      <Path> is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
3045      Could not use <name>; file already in use.
3046      Could not save; currently locked by another user.
3047      Record is too large.
3048      Cannot open any more databases.
3049      Cannot open database <name>. It may not be a database that your application recognizes, or the file may be corrupt.
3050      Could not lock file.
3051      The Microsoft Jet database engine cannot open the file <name>. It is already opened exclusively by another user, or you need permission to view its data.
3052      File sharing lock count exceeded. Increase MaxLocksPerFile registry entry.
3053      Too many client tasks.
3054      Too many Memo, OLE, or Hyperlink Object fields.
3055      Not a valid file name.
3056      Could not repair this database.
3057      Operation not supported on linked tables.
3058      Index or primary key cannot contain a Null value.
3059      Operation canceled by user.
3060      Wrong data type for parameter <parameter>.
3061      Too few parameters. Expected <number>.
3062      Duplicate output alias <name>.
3063      Duplicate output destination <name>.
3064      Cannot open action query <name>.
3065      Cannot execute a select query.
3066      Query must have at least one destination field.
3067      Query input must contain at least one table or query.
3068      Not a valid alias name.
3069      The action query <name> cannot be used as a row source.
3070      The Microsoft Jet database engine does not recognize <name> as a valid field name or expression.
3071      This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.
3072      There was a type mismatch when creating a table validation rule or a CHECK constraint on a column.
3073      Operation must use an updatable query.
3074      Cannot repeat table name <name> in FROM clause.
3075      <Message> in query expression <expression>.
3076      <Name> in criteria expression.
3077      <Message> in expression.
3078      The Microsoft Jet database engine cannot find the input table or query <name>. Make sure it exists and that its name is spelled correctly.
3079      The specified field <field> could refer to more than one table listed in the FROM clause of your SQL statement.
3080      Joined table <name> not listed in FROM clause.
3081      Cannot join more than one table with the same name <name>.
3082      JOIN operation <operation> refers to a field that is not in one of the joined tables.
3083      Cannot use internal report query.
3084      Cannot insert[/t] data with action query.
3085      Undefined function <name> in expression.
3086      Could not de[tt]
lete from specified tables.
3087      Too many expressions in GROUP BY clause.
3088      Too many expressions in ORDER BY clause.
3089      Too many expressions in DISTINCT output.
3090      Resultant table not allowed to have more than one AutoNumber field.
3091      HAVING clause <name> without grouping or aggregation.
3092      Cannot use HAVING clause in TRANSFORM statement.
3093      ORDER BY clause <clause> conflicts with DISTINCT.
3094      ORDER BY clause <clause> conflicts with GROUP BY clause.
3095      Cannot have aggregate function in expression <expression>.
3096      Cannot have aggregate function in WHERE clause <clause>.
3097      Cannot have aggregate function in ORDER BY clause <clause>.
3098      Cannot have aggregate function in GROUP BY clause <clause>.
3099      Cannot have aggregate function in JOIN operation <operation>.
3100      Cannot set field <name> in join key to Null.
3101      The Microsoft Jet database engine cannot find a record in the table <name> with key matching field(s) <name>.
3102      Circular reference caused by <query reference>.
3103      Circular reference caused by alias <name> in query definition's SELECT list.
3104      Cannot specify fixed column heading <value> in a crosstab query more than once.
3105      Missing destination field name in SELECT INTO statement <statement>.
3106      Missing destination field name in UPDATE statement <statement>.
3107      Record(s) cannot be added; no insert permission on <name>.
3108      Record(s) cannot be edited; no update permission on <name>.
3109      Record(s) cannot be deleted; no delete permission on <name>.
3110      Could not read definitions; no read definitions permission for table or query <name>.
3111      Could not create; no modify design permission for table or query <name>.
3112      Record(s) cannot be read; no read permission on <name>.
3113      Cannot update <field name>; field not updatable.
3114      Cannot include Memo, OLE, or Hyperlink Object when you select unique values <statement>.
3115      Cannot have Memo, OLE, or Hyperlink Object fields in aggregate argument <statement>.
3116      Cannot have Memo, OLE, or Hyperlink Object fields in criteria <criteria> for aggregate function.
3117      Cannot sort on Memo, OLE, or Hyperlink Object <clause>.
3118      Cannot join on Memo, OLE, or Hyperlink Object <name>.
3119      Cannot group on Memo, OLE, or Hyperlink Object <clause>.
3120      Cannot group on fields selected with '*' <table name>.
3121      Cannot group on fields selected with '*'.
3122      You tried to execute a query that does not include the specified expression <name> as part of an aggregate function.
3123      Cannot use '*' in crosstab query.
3124      Cannot input from internal report query <name>.
3125      <Name> is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
3126      Invalid bracketing of name <name>.
3127      The INSERT INTO statement contains the following unknown field name: <field name>. Make sure you have typed the name correctly, and try the operation again.
3128      Specify the table containing the records you want to delete.
3129      Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
3130      Syntax error in DELETE statement.
3131      Syntax error in FROM clause.
3132      Syntax error in GROUP BY clause.
3133      Syntax error in HAVING clause.
3134      Syntax error in INSERT INTO statement.
3135      Syntax error in JOIN operation.
3136      The LEVEL clause includes a reserved word or argument that is misspelled or missing, or the punctuation is incorrect.
3137      Missing semicolon (;) at end of SQL statement.
3138      Syntax error in ORDER BY clause.
3139      Syntax error in PARAMETER clause.
3140      Syntax error in PROCEDURE clause.
3141      The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
3142      Characters found after end of SQL statement.
3143      Syntax error in TRANSFORM statement.
3144      Syntax error in UPDATE statement.
3145      Syntax error in WHERE clause.
3146      ODBC— call failed.
Back to top
 
« Last Edit: 17.08.14 at 10:14:12 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Trappable Microsoft Jet Errors
Reply #2 - 17.08.14 at 10:13:21
 
Trappable Microsoft Jet Errors: 3150-3199
 
3151      ODBC— connection to <name> failed.
3154      ODBC— could not find DLL <name>.
3155      ODBC— insert on a linked table <table> failed.
3156      ODBC— delete on a linked table <table> failed.
3157      ODBC— update on a linked table <table> failed.
3158      Could not save record; currently locked by another user.
3159      Not a valid bookmark.
3160      Table is not open.
3161      Could not decrypt file.
3162      You tried to assign the Null value to a variable that is not a Variant data type.
3163      The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
3164      Field cannot be updated.
3165      Could not open .inf file.
3166      Cannot locate the requested Xbase memo file.
3167      Record is deleted.
3168      Invalid .inf file.
3169      The Microsoft Jet database engine could not execute the SQL statement because it contains a field that has an invalid data type.
3170      Could not find installable ISAM.
3171      Could not find network path or user name.
3172      Could not open Paradox.net.
3173      Could not open table 'MSysAccounts' in the workgroup information file.
3174      Could not open table 'MSysGroups' in the workgroup information file.
3175      Date is out of range or is in an invalid format.
3176      Could not open file <name>.
3177      Not a valid table name.
3179      Encountered unexpected end of file.
3180      Could not write to file <name>.
3181      Invalid range.
3182      Invalid file format.
3183      Not enough space on temporary disk.
3184      Could not execute query; could not find linked table.
3185      SELECT INTO on a remote database tried to produce too many fields.
3186      Could not save; currently locked by user <name> on machine <name>.
3187      Could not read; currently locked by user <name> on machine <name>.
3188      Could not update; currently locked by another session on this machine.
3189      Table <name> is exclusively locked by user <name> on machine <name>.
3190      Too many fields defined.
3191      Cannot define field more than once.
3192      Could not find output table <name>.
3196      The database <database name> is already in use by another person or process. When the database is available, try the operation again.
3197      The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
3198      Could not start session. Too many sessions already active.
3199      Could not find reference.
Back to top
 
« Last Edit: 17.08.14 at 10:13:51 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Trappable Microsoft Jet Errors
Reply #3 - 17.08.14 at 10:15:15
 
Trappable Microsoft Jet Errors: 3200-3299
 
3200      The record cannot be deleted or changed because table <name> includes related records.
3201      You cannot add or change a record because a related record is required in table <name>.
3202      Could not save; currently locked by another user.
3203      Subqueries cannot be used in the expression <expression>.
3204      Database already exists.
3205      Too many crosstab column headers <value>.
3206      Cannot create a relationship between a field and itself.
3207      Operation not supported on a Paradox table with no primary key.
3208      Invalid Deleted setting in the Xbase key of the Windows Registry.
3210      The connection string is too long.
3211      The database engine could not lock table <name> because it is already in use by another person or process.
3212      Could not lock table <name>; currently in use by user <name> on machine <name>.
3213      Invalid Date setting in the Xbase key of the Windows Registry.
3214      Invalid Mark setting in the Xbase key of the Windows Registry.
3216      Parameter <name> specified where a table name is required.
3217      Parameter <name> specified where a database name is required.
3218      Could not update; currently locked.
3219      Invalid operation.
3220      Incorrect collating sequence.
3222      Query cannot contain a Database parameter.
3223      <Parameter name> is invalid because it is too long or contains invalid characters.
3227      Invalid Century setting in the Xbase key of the Windows Registry.
3228      Selected collating sequence not supported by the operating system.
3230      Out-of-date Paradox lock file.
3231      ODBC— field would be too long; data truncated.
3232      ODBC— could not create table.
3234      ODBC— remote query timeout expired.
3235      ODBC— data type not supported on server.
3238      ODBC— data out of range.
3239      Too many active users.
3242      Invalid reference in SELECT statement.
3243      None of the import field names match fields in the appended table.
3244      Cannot import password-protected spreadsheet.
3245      Could not parse field names from the first row of the import table.
3246      Operation not supported in transactions.
3247      ODBC— linked table definition has changed.
3248      Invalid NetworkAccess setting in the Windows Registry.
3249      Invalid PageTimeout setting in the Windows Registry.
3250      Could not build key.
3251      Operation is not supported for this type of object.
3252      Cannot open a form whose underlying query contains a user-defined function that attempts to set or get the form's RecordsetClone property.
3254      ODBC— Cannot lock all records.
3256      Index file not found.
3257      Syntax error in WITH OWNERACCESS OPTION declaration.
3258      The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement.
3259      Invalid field data type.
3260      Could not update; currently locked by user <name> on machine <name>.
3261      Table <name> is exclusively locked by user <name> on machine <name>.
3262      Could not lock table.
3263      Invalid Database object.
3264      No field defined— cannot append TableDef or Index.
3265      Item not found in this collection.
3266      Cannot append a Field that is already a part of a Fields collection.
3267      Property can be set only when the Field is part of a Recordset object's Fields collection.
3268      Cannot set this property once the object is part of a collection.
3269      Cannot append an Index that is already a part of an Indexes collection.
3270      Property not found.
3271      Invalid property value.
3272      Object is not a collection.
3273      Method not applicable for this object.
3274      External table is not in the expected format.
3275      Unexpected error from external database driver <error number>.
3276      Invalid database object reference.
3277      Cannot have more than 10 fields in an index.
3278      The Microsoft Jet database engine has not been initialized.
3279      The Microsoft Jet database engine has already been initialized.
3280      Cannot delete a field that is part of an index or is needed by the system.
3281      Cannot delete this index or table. It is either the current index or is used in a relationship.
3282      Operation not supported on a table that contains data.
3283      Primary key already exists.
3284      Index already exists.
3285      Invalid index definition.
3286      Format of memo file does not match specified external database format.
3287      Cannot create index on the given field.
3288      Paradox index is not primary.
3289      Syntax error in CONSTRAINT clause.
3290      Syntax error in CREATE TABLE statement.
3291      Syntax error in CREATE INDEX statement.
3292      Syntax error in field definition.
3293      Syntax error in ALTER TABLE statement.
3294      Syntax error in DROP INDEX statement.
3295      Syntax error in DROP TABLE or DROP INDEX.
3296      Join expression not supported.
3297      Could not import table or query. No records found, or all records contain errors.
3298      There are several tables with that name. Please specify owner in the format 'owner.table'.
3299      ODBC Specification Conformance Error <message>. Report this error to the developer of your application.
Back to top
 
« Last Edit: 17.08.14 at 10:33:36 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Trappable Microsoft Jet Errors
Reply #4 - 17.08.14 at 10:16:49
 
Trappable Microsoft Jet Errors: 3300-3399
 
3300      Cannot create a relationship.
3301      Cannot perform this operation; features in this version are not available in databases with older formats.
3302      Cannot change a rule while the rules for this table are in use.
3303      Cannot delete this field. It is part of one or more relationships.
3304      You must enter a personal identifier (PID) consisting of at least 4 and no more than 20 characters and digits.
3305      Invalid connection string in pass-through query.
3306      You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field.
3307      The number of columns in the two selected tables or queries of a union query do not match.
3308      Invalid TOP argument in select query.
3309      Property value is too large.
3310      This property is not supported for external data sources or for databases created with a previous version of Microsoft Jet.
3311      Property specified already exists.
3312      Validation rules and default values cannot be placed on system or linked tables.
3313      Cannot place this validation expression on this field.
3314      The field <name> cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.
3315      Field <name> cannot be a zero-length string.
3316      <Table-level validation text>.
3317      One or more values are prohibited by the validation rule <rule> set for <name>. Enter a value that the expression for this field can accept.
3318      Values specified in a TOP clause are not allowed in delete queries or reports.
3319      Syntax error in union query.
3320      <Error> in table-level validation expression.
3321      No database specified in connection string or IN clause.
3322      Crosstab query contains one or more invalid fixed column headings.
3323      The query cannot be used as a row source.
3324      The query is a DDL query and cannot be used as a row source.
3325      Pass-through query with ReturnsRecords property set to True did not return any records.
3326      This result set is not updateable.
3327      Field <name> is based on an expression and cannot be edited.
3328      Table <name> is read-only.
3329      Record in table <name> was deleted by another user.
3330      Record in table <name> is locked by another user.
3331      To make changes to this field, first save the record.
3332      Cannot enter value into blank field on 'one' side of outer join.
3333      Records in table <name> would have no record on the 'one' side.
3334      Can be present only in version 1.0 format.
3337      Invalid DataCodePage option in initialization setting.
3340      Query <name> is corrupt.
3341      The current field must match the join key <name> in the table that serves as the 'one' side of one-to-many relationship. Enter a record in the 'one' side table with the desired key value, and then make the entry with the desired join key in the 'many-only' table.
3342      Invalid Memo, OLE, or Hyperlink Object in subquery <name>.
3343      Unrecognized database format <filename>.
3344      The database engine does not recognize either the field <name> in a validation expression, or the default value in the table <name>.
3345      Unknown or invalid field reference <name>.
3346      Number of query values and destination fields are not the same.
3347      Cannot add record(s); primary key for table <name> not in result set.
3348      Cannot add records(s); join key of table <name> not in result set.
3349      Numeric field overflow.
3350      Object is invalid for operation.
3351      The ORDER BY expression <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.
3352      No destination field name in INSERT INTO statement <statement>.
3354      At most one record can be returned by this subquery.
3355      Syntax error in default value.
3356      You attempted to open a database that is already opened exclusively by user <name> on machine <name>. Try again when the database is available.
3357      This query is not a properly formed data-definition query.
3358      Cannot open the Microsoft Jet engine workgroup information file.
3359      Pass-through query must contain at least one character.
3360      Query is too complex.
3361      Unions not allowed in a subquery.
3362      Single-row update/delete affected more than one row of a linked table. Unique index contains duplicate values.
3363      Record(s) cannot be added; no corresponding record on the 'one' side.
3364      Cannot use Memo, OLE, or Hyperlink Object field <name> in the SELECT clause of a union query.
3365      Cannot set this property for remote objects.
3366      Cannot append a relation with no fields defined.
3367      Cannot append. An object with that name already exists in the collection.
3368      Relationship must be on the same number of fields with the same data types.
3370      Cannot modify the design of table <name>. It is in a read-only database.
3371      Cannot find table or constraint.
3372      No such index <name> on table <name>.
3373      Cannot create relationship. Referenced table <name> does not have a primary key.
3374      The specified fields are not uniquely indexed in table <name>.
3375      Table <name> already has an index named <name>.
3376      Table <name> does not exist.
3377      No such relationship <name> on table <name>.
3378      There is already a relationship named <name> in the current database.
3379      Cannot create relationships to enforce referential integrity. Existing data in table <name> violates referential integrity rules in table <name>.
3380      Field <name> already exists in table <name>.
3381      There is no field named <name> in table <name>.
3382      Size of field <name> is too long.
3383      Cannot delete field <name>. It is part of one or more relationships.
3384      Cannot delete a built-in property.
3385      User-defined properties do not support a Null value.
3386      Property <name> must be set before using this method.
3388      Unknown function <name> in validation expression or default value on <name>.
3389      Query support unavailable.
3390      Account name already exists.
3393      Cannot perform join, group, sort, or indexed restriction. A value being searched or sorted on is too long.
3394      Cannot save property; property is a schema property.
3396      Cannot perform cascading operation. Since related records exist in table <name>, referential integrity rules would be violated.
3397      Cannot perform cascading operation. There must be a related record in table <name>.
3398      Cannot perform cascading operation. It would result in a null key in table <name>.
3399      Cannot perform cascading operation. It would result in a duplicate key in table <name>.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Trappable Microsoft Jet Errors
Reply #5 - 17.08.14 at 10:17:32
 
Trappable Microsoft Jet Errors: 3400-3499
 
3400      Cannot perform cascading operation. It would result in two updates to field <name> in table <name>.
3401      Cannot perform cascading operation. It would cause field <name> to become Null, which is not allowed.
3402      Cannot perform cascading operation. It would cause field <name> to become a zero-length string, which is not allowed.
3403      Cannot perform cascading operation: <validation text>.
3404      Cannot perform cascading operation. The value entered is prohibited by the validation rule <rule> set for <name>.
3405      Error <error text> in validation rule.
3406      The expression you are trying to use for the DefaultValue property is invalid because <error text>. Use a valid expression to set this property.
3407      The server's MSysConf table exists, but is in an incorrect format. Contact your system administrator.
3408      Too many FastFind Sessions were invoked.
3409      Invalid field name <name> in definition of index or relationship.
3411      Invalid entry. Cannot perform cascading operation in table <name> because the value entered is too large for field <name>.
3412      Cannot perform cascading update on the table because it is currently in use by another user.
3413      Cannot perform cascading operation on table <name> because it is currently in use by user <name> on machine <name>.
3414      Cannot perform cascading operation on table <name> because it is currently in use.
3415      Zero-length string is valid only in a Text or Memo field.
3416      <reserved error alert>
3417      An action query cannot be used as a row source.
3418      Cannot open <tablename>. Another user has the table open using a different network control file or locking style.
3419      Cannot open this Paradox 4.x or 5.x table because ParadoxNetStyle is set to 3.x in the Windows Registry.
3420      Object is invalid or no longer set.
3421      Data type conversion error.
3422      Cannot modify table structure. Another user has the table open.
3423      You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database.
3424      Cannot create database because the locale is invalid.
3428      A problem occurred in your database. Correct the problem by repairing and compacting the database.
3429      Incompatible version of an installable ISAM.
3430      While loading the Microsoft Excel installable ISAM, OLE was unable to initialize.
3431      This is not a Microsoft Excel 5.0 file.
3432      Error opening a Microsoft Excel 5.0 file.
3433      Invalid setting in Excel key of the Engines section of the Windows Registry.
3434      Cannot expand named range.
3435      Cannot delete spreadsheet cells.
3436      Failure creating file.
3437      Spreadsheet is full.
3438      The data being exported does not match the format described in the Schema.ini file.
3439      You attempted to link or import a Microsoft Word mail merge file. Although you can export such files, you cannot link or import them.
3440      An attempt was made to import or link an empty text file. To import or link a text file, the file must contain data.
3441      Text file specification field separator matches decimal separator or text delimiter.
3442      In the text file specification <name>, the <name> option is invalid.
3443      The fixed-width specification <name> contains no column widths.
3444      In the fixed width specification <name>, column <column> does not specify a width.
3445      Incorrect version of the DLL file <name> was found.
3446      Jet VBA file (VBAJET.dll for 16-bit versions, or VBAJET32.dll for 32-bit versions) is missing. Try reinstalling the application that returned the error.
3447      The Jet VBA file (VBAJET.dll for 16-bit versions, or VBAJET32.dll for 32-bit versions) failed to initialize when called. Try reinstalling the application that returned the error.
3448      A call to an OLE system function was not successful. Try reinstalling the application that returned the error.
3449      No country code found in the connection string.
3450      Syntax error in query. Incomplete query clause.
3451      Illegal reference in query.
3452      You cannot make changes to the design of the database at this replica.
3453      You cannot establish or maintain an enforced relationship between a replicated table and a local table.
3455      Cannot make the database replicable.
3456      Cannot make the <name> object in <name> container replicable.
3457      You cannot set the KeepLocal property for an object that is already replicated.
3458      The KeepLocal property cannot be set on a database; it can be set only on the objects in a database.
3459      After a database has been replicated, you cannot remove the replication features from the database.
3460      The operation you attempted conflicts with an existing operation involving this member of the replica set.
3461      The replication property you are attempting to set or delete is read-only and cannot be changed.
3462      Failure to load a DLL.
3463      Cannot find the .dll <name>.
3464      Data type mismatch in criteria expression.
3465      The disk drive you are attempting to access is unreadable.
3468      Access was denied while accessing dropbox folder <name>.
3469      The disk for dropbox folder <name> is full.
3470      Disk failure accessing dropbox folder <name>.
3471      Failure to write to the Synchronizer log file.
3472      Disk full for path <name>.
3473      Disk failure while accessing log file <name>.
3474      Cannot open the log file <name> for writing.
3475      Sharing violation while attempting to open log file <name> in Deny Write mode.
3476      Invalid dropbox path <name>.
3477      Dropbox address <name> is syntactically invalid.
3478      The replica is not a partial replica.
3479      Cannot designate a partial replica as the Design Master for the replica set.
3480      The relationship <name> in the partial filter expression is invalid.
3481      The table name <name> in the partial filter expression is invalid.
3482      The filter expression for the partial replica is invalid.
3483      The password supplied for the dropbox folder <name> is invalid.
3484      The password used by the Synchronizer to write to a destination dropbox folder is invalid.
3485      The object cannot be replicated because the database is not replicated.
3486      You cannot add a second Replication ID AutoNumber field to a table.
3487      The database you are attempting to replicate cannot be converted.
3488      The value specified is not a ReplicaID for any member in the replica set.
3489      The object specified cannot be replicated because it is missing a necessary resource.
3490      Cannot create a new replica because the <name> object in <name> container could not be replicated.
3491      The database must be opened in exclusive mode before it can be replicated.
3492      The synchronization failed because a design change could not be applied to one of the replicas.
3493      Cannot set the specified Registry parameter for the Synchronizer.
3494      Unable to retrieve the specified Registry parameter for the Synchronizer.
3495      There are no scheduled synchronizations between the two Synchronizers.
3496      Replication Manager cannot find the ExchangeID in the MSysExchangeLog table.
3497      Unable to set a schedule for the Synchronizer.
3499      Cannot retrieve the full path information for a member of the replica set.
Back to top
 
« Last Edit: 17.08.14 at 10:17:52 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Trappable Microsoft Jet Errors
Reply #6 - 17.08.14 at 10:18:42
 
Trappable Microsoft Jet Errors: 3500-3599
 
3500      You cannot specify two different Synchronizers to manage the same replica.
3502      The Design Master or replica is not being managed by a Synchronizer.
3503      The Synchronizer's Registry has no value set for the key you queried.
3504      The Synchronizer ID does not match an existing ID in the MSysTranspAddress table.
3505      You attempted to delete or get information about a partial filter that does not exist in MsysFilters.
3506      The Synchronizer is unable to open the Synchronizer log.
3507      Failure writing to the Synchronizer log.
3508      There is no active transport for the Synchronizer.
3509      Could not find a valid transport for this Synchronizer.
3510      The member of the replica set you are attempting to synchronize is currently being used in another synchronization.
3512      Failed to read the dropbox folder.
3513      Failed to write to the dropbox folder.
3514      Synchronizer could not find any scheduled or on-demand synchronizations to process.
3515      The Microsoft Jet database engine could not read the system clock on your computer.
3516      Destination synchronizer is not configured to support indirect synchronization, and the destination replica is unavailable for direct synchronization.
3517      Synchronizer could not find any messages to process.
3518      Could not find Synchronizer in the MSysTranspAddress table.
3519      Failed to send a message.
3520      The replica name or ID does not match a currently managed member of the replica set.
3521      Two members of the replica set cannot be synchronized because there is no common point to start the synchronization.
3522      Synchronizer cannot find the record of a specific synchronization in the MSysExchangeLog table.
3523      Synchronizer cannot find a specific version number in the MSysSchChange table.
3524      The history of design changes in the replica does not match the history in the Design Master.
3525      Synchronizer could not access the message database.
3526      The name selected for the system object is already in use.
3527      The Synchronizer or Replication Manager could not find the system object.
3528      There is no new data in shared memory for the Synchronizer or Replication Manager to read.
3529      The Synchronizer or Replication Manager found unread data in the shared memory. The existing data will be overwritten.
3530      The Synchronizer is already serving a client.
3531      The wait period for an event has timed out.
3532      Synchronizer could not be initialized.
3533      The system object used by a process still exists after the process has stopped.
3534      Synchronizer looked for a system event but did not find one to report to the client.
3535      Client has asked the Synchronizer to terminate operation.
3536      Synchronizer received an invalid message for a member of the replica set that it manages.
3537      The Synchronizer's client is no longer present and cannot be notified.
3538      Cannot initialize Synchronizer because there are too many applications running.
3539      A system error has occurred or your swap file has reached its limit.
3540      Your swap file has reached its limit or is corrupted.
3541      Synchronizer could not be shut down properly and is still active.
3542      Process stopped when attempting to terminate Synchronizer client.
3543      Synchronizer has not been set up.
3544      Synchronizer is already running.
3545      The two replicas you are attempting to synchronize are from different replica sets.
3546      The type of synchronization you are attempting is not valid.
3547      Synchronizer could not find a replica from the correct set to complete the synchronization.
3548      GUIDs do not match or the requested GUID could not be found.
3549      The file name you provided is too long.
3550      There is no index on the GUID column.
3551      Unable to delete the specified Registry parameter for the Synchronizer.
3552      The size of the Registry parameter exceeds the maximum allowed.
3553      The GUID could not be created.
3555      All valid nicknames for replicas are already in use.
3556      Invalid path for destination dropbox folder.
3557      Invalid address for destination dropbox folder.
3558      Disk I/O error at destination dropbox folder.
3559      Failure to write because destination disk is full.
3560      The two members of the replica set you are attempting to synchronize have the same ReplicaID.
3561      The two members of the replica set you are attempting to synchronize are both Design Masters.
3562      Access denied at destination dropbox folder.
3563      Fatal error accessing a local dropbox folder.
3564      Synchronizer cannot find the source file for messages.
3565      There is a sharing violation in the source dropbox folder because the message database is open in another application.
3566      Network I/O error.
3567      Message in dropbox folder belongs to the wrong Synchronizer.
3568      Synchronizer could not delete a file.
3569      This member of the replica set has been logically removed from the set and is no longer available.
3570      The filters defining a partial replica are out of synch with each other.
3571      The attempt to set a column in a partial replica violated a rule governing partial replicas.
3572      A disk I/O error occurred while reading or writing to the TEMP directory.
3573      The directory you queried for a list of replicas is not a managed directory.
3574      The ReplicaID for this member of the replica set was reassigned during a move or copy procedure.
3575      The disk drive you are attempting to write to is full.
3576      The database you are attempting to open is already in use by another application.
3577      Cannot update replication system column.
3578      Failure to replicate database; cannot determine whether the database is open in exclusive mode.
3579      Could not create replication system tables needed to make the database replicable.
3580      Could not add rows needed to make the database replicable.
3581      Cannot open replication system table <name> because the table is already in use.
3582      Cannot make a new replica because the <name> object in <name> container could not be made replicable.
3583      Cannot make the <name> object in <name> container replicable.
3584      Insufficient memory to complete operation.
3585      Cannot replicate the table; the number of columns exceeds the maximum allowed.
3586      Syntax error in partial filter expression on table <name>.
3587      Invalid expression in the ReplicaFilter property.
3588      Error when evaluating the partial filter expression.
3589      The partial filter expression contains an unknown function.
3590      Violates the rules for partial replicas.
3591      Log file path <name> is invalid.
3592      You cannot replicate a password-protected database or set password protection on a replicated database.
3593      You cannot change the data master attribute for the replica set.
3594      You cannot change the data master attribute for the replica set. It allows data changes only at the Design Master.
3595      The system tables in your replica are no longer reliable and the replica should not be used.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Trappable Microsoft Jet Errors
Reply #7 - 17.08.14 at 10:19:39
 
Trappable Microsoft Jet Errors: 3600-3699
 
3600      Aggregation expressions cannot use GUIDs.
3605      Synchronizing with a non-replicated database is not allowed. The <name> database is not a Design Master or replica.
3607      The replication property you are attempting to delete is read-only and cannot be removed.
3608      Record length is too long for an indexed Paradox table.
3609      No unique index found for the referenced field of the primary table.
3610      Same table <table> referenced as both the source and destination in a make-table query.
3611      Cannot execute data definition statements on linked data sources.
3612      Multi-level GROUP BY clause is not allowed in a subquery.
3613      Cannot create a relationship on linked ODBC tables.
3614      GUID not allowed in Find method criteria expression.
3615      Type mismatch in JOIN expression.
3616      Updating data in a linked table is not supported by this ISAM.
3617      Deleting data in a linked table is not supported by this ISAM.
3618      Exceptions table could not be created on import/export.
3619      Records could not be added to exceptions table.
3620      The connection for viewing your linked Microsoft Excel worksheet was lost.
3621      Cannot change password on a shared open database.
3622      You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column.
3623      Cannot access the FoxPro 3.0 bound DBF file <filename>.
3624      Could not read the record; currently locked by another user.
3625      The text file specification <name> does not exist. You cannot import, export, or link using the specification.
3626      The operation failed. There are too many indexes on table <name>. Delete some of the indexes on the table and try the operation again.
3627      Cannot find the executable file for the Synchronizer (mstran40.exe).
3628      Partner replica is not managed by a Synchronizer.
3629      Synchronizer <name> is also using the same File System dropbox <name>.
3630      Synchronizer <name> is also using the same File System dropbox <name>.
3631      Invalid table name in filter.
3632      Internet Transport not enabled on the remote Synchronizer.
3633      Cannot load DLL <name>.
3634      Cannot create a replica using a partial replica.
3635      Cannot create partial replica of a system database.
3636      Cannot populate the replica or change the replica's filter because the replica has conflicts or data errors.
3637      Cannot use the crosstab of a non-fixed column as a subquery.
3638      A Source Controlled database cannot be made replicable.
3639      Cannot create a replica of a System database.
3640      The fetch buffer was too small for the amount of data you requested.
3641      There are fewer records remaining in the Recordset than you requested.
3642      A cancel was performed on the operation.
3643      One of the records in the Recordset was deleted by another process.
3645      One of the binding parameters is incorrect.
3646      The specified row length is shorter than the sum of the column lengths.
3647      A column requested is not being returned to the Recordset.
3648      Cannot synchronize a partial replica with another partial replica.
3649      The language-specific code page was not specified or could not be found.
3650      Either the Internet is very slow or there is some problem in the replication manager setup on the internet server machine.
3651      Invalid Internet address.
3652      Internet login failure.
3653      Internet not set up.
3656      Error in evaluating a partial expression.
3657      Error in evaluating the Boolean filter expression for table <name>.
3658      Binary column <name> cannot be used in a Boolean filter.
3659      Relationship <name> is unenforced. Relationship in a partial filter expression must be enforced.
3660      Requested exchange failed because <description>.
3661      Requested exchange failed because <description>.
3663      This operation requires a different cursor library.
3664      An asynchronous OpenConnection call is not yet complete; you cannot yet reference the returned connection object unitl it is complete.
3665      You cannot modify the replication system object <name>.
3666      You cannot modify the replication system object <name>.
3667      A different operation is preventing this operation from being executed.
3668      Cannot perform this operation because there is no active connection.
3672      Failed to load RDOCURS.DLL
3673      This table contains cells that are outside the range of cells defined in this spreadsheet.
3674      Internet dll (wininet.dll) could not be found or loaded.
3675      Failure to read from an internet handle. Try the operation again.
3676      Failure to write to an internet handle. Try the operation again.
3677      Failure to execute the HTTP request to start the internet synchronizer or the internet server. Use Replication Manager to configure internet synchronizer on the internet server.
3678      Failure to connect to the FTP service on the internet server. Make sure that FTP service is running properly on the server and supports anonymous connections.
3679      Failure to open file using FTP service. Make Sure that FTP dropbox has read permission.
3680      Failure in getting a file from the server using FTP. Make sure that FTP dropbox has read permissions.
3681      Failure in putting a file to the server using FTP. Make sure that FTP dropbox has write permissions.
3682      Failure to delete a file on the server using FTP. Make sure that FTP dropbox has read and write permissions.
3683      Internet synchronizer exited unexpectedly on the server. Look at the partner replica exchange history on the internet server to figure out the problem.
3684      There is no suitable replica with which to exchange.
3685      Invalid HTTP address.
3686      Invalid replica path or name.
3689      Invalid SQL syntax - expected token: Privileges.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Trappable Microsoft Jet Errors
Reply #8 - 17.08.14 at 10:26:34
 
Trappable Microsoft Jet Errors: 3700-3808
 
3700      Invalid precision for decimal data type.
3701      Invalid scale for decimal data type.
3702      The width of a Unicode text column must be an even number of bytes.
3703      Operation not supported on replicable databases that have not been converted to the current version.
3704      You attempted to open a database that is already opened by user <name> on machine <name>. Try again when the database is available.
3705      Cannot make the <name> table replicable - too many columns.
3706      Cannot make the <name> table replicable - too many indexes.
3707      The cascading options for the new reference conflict with existing reference <name>.
3708      Syntax error in Transaction statement. Expected TRANSACTION, WORK, or nothing.
3709      The search key was not found in any record.
3710      MAPI folder or address book not found.
3711      Recovered replicable data. This row was recovered from a corrupted replicable database. Verify that the record contents are correct and then reinsert the record, or delete the conflict record.
3713      Update/update conflict. Another replica also updated this record. This record lost the conflict. Either resubmit your update or delete this conflict record.
3714      Locked table. This record could not be applied during synchronization since the table was locked by another user. Resubmit this conflict record.
3715      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.
3716      TLV violation. This record contains a field value that does not meet the table level validation constraint. Either update the field value that is violating the validation rule and then resubmit this conflict record, or delete this conflict record.
3717      Delete/RI conflict. The primary key record has been deleted by another replica, therefore this referencing record has been rejected. Either create a new primary key record that satisfies the referential integrity constraint and then resubmit your update, or delete this conflict record.
3718      Update/RI conflict. The primary key record has been updated by another replica, therefore this referencing record has been rejected. Either create a new primary key record that satisfies the referential integrity constraint, modify the foreign key value in this conflict record to match a valid primary key value and then resubmit your update, or delete this conflict record.
3719      Foreign key violation resulting from an invalid primary key record that was involved in a replication conflict. Either create a new primary key record that satisfies the referential integrity constraint, modify the foreign key value in this conflict record to match a valid primary key value and then resubmit this conflict record, or delete this conflict record.
3720      Cannot change field <name>. It is part of one or more relationships.
3721      Invalid SQL syntax - expected CONSTRAINT name.
3722      Invalid SQL syntax - expected token: DEFAULT.
3723      Invalid SQL syntax - expected token: COMPRESSION to follow WITH.
3724      Invalid SQL syntax - expected token: UPDATE or DELETE.
3725      Invalid SQL syntax - expected token: CASCADE, SET NULL, or NO ACTION.
3726      Invalid SQL syntax - expected token: NULL.
3727      Invalid SQL syntax - only one update rule and/or one delete rule allowed.
3728      Invalid SQL syntax - expected token: AS.
3729      Invalid SQL syntax - expected token: SELECT.
3730      VIEW cannot contain a parameter.
3731      The number of aliases specified shall be the same as the number of output columns.
3732      Expected query name after EXECUTE.
3733      The database has been placed in a state by an unknown user that prevents it from being opened or locked.
3734      The database has been placed in a state by user <name> on machine <name> that prevents it from being opened or locked.
3736      Update/delete conflict. This updated record was deleted at another replica. Either reinsert this conflict record or delete it.
3737      Cannot create this type of replica from the given source replica.
3738      Local or Anonymous replicas must synch only to their designated hub replica.
3740      Cannot add a new column to conflict table <name>. Delete obsolete columns and compact the database.
3741      Invalid partner synchronizer. Local or anonymous replica must synchronize with designated hub replica.
3742      An internet function has timed out.
3743      Replica has not been synchronized within the replica set retention period.
3745      The combined length of Internet Server Name, HTTP Share name, and FTP alias name should not be greater than 252 characters.
3746      Syntax error in query. Parameter value.
3747      Parameter has no default value.
3748      Parameter <name> has no default value.
3749      The object is not a stored procedure.
3750      Object <name> is not a stored procedure.
3751      Requested row locking, but DB is in page lock mode.
3752      Requested page locking, but DB is in row lock mode.
3753      Cannot create replica of a Jet SQL replica.
3754      Cannot delete from a Prevent Deletes Replica.
3755      CHECK Constraint <name> does not exist.
3756      CHECK constraint <name> already exists.
3757      The Jet sorting DLLs could not be loaded properly.
3758      Scaling of decimal value resulted in data truncation.
3759      Scaling of decimal value resulted in data truncation.
3760      Scaling of decimal value resulted in data overflow.
3761      The decimal field's precision is too small to accept the numeric you attempted to add.
3762      Invalid SQL syntax - expected token: ACTION.
3763      Concurrent schema changes caused the create replica operation to fail. Try again.
3765      Syntax error in CHECK CONSTRAINT clause.
3766      Only simple SELECT queries are allowed in VIEWS.
3767      Table <name> could not be made replicable because it could not be opened exclusively.
3768      FastFind cannot search on non-column references.
3769      Conflict tables cannot be renamed.
3770      Counter definition not in valid range.
3771      Local or Anonymous replicas cannot be made the Design Master.
3772      Without Administrator permission, replica priority must be in the range 0 - <number>.
3773      Cannot delete one or more objects: <name>.
3775      Unable to load Jet SQL Server Reconciler - MSRPJT40.dll
3777      Illegal Operation performed on a Jet SQL Server Replica.
3778      The Jet database is wrong or missing for this SQL/Jet replica set.
3779      Unable to change Column Level Tracking Property on objects that are already replicable.
3780      Invalid SQL syntax - expected a view name.
3781      Invalid SQL syntax - expected a procedure name.
3784      Database is already replicable.
3785      Invalid SQL syntax - expected token: Database.
3786      Invalid SQL syntax - expected a database privilege such as CREATEDB or CONNECT.
3787      This operation is not allowed in subqueries.
3788      3annot create an index on this MAPI folder/address book.
3789      Illegal column-level constraint.
3798      CHECK constraints are not allowed on replicable databases.
3799      Could not find field <name>.
3800      <Name> is not an index in this table.
3801      The object <name> cannot be used in a CHECK constraint clause.
3802      Error evaluating <name> CHECK constraint. <Additional information.>
3803      DDL cannot be completed on this table because it is referenced by constraint <name> on table <name>.
3804      There are no MAPI clients installed on this machine. Install a MAPI client, such as Outlook, on this machine.
3805      Check constraints on table <name> will not be transferred to this table. Check constraints can only be created via SQL DDL statements.
3806      Cannot set multiple NULL, NOT NULL attributes.
3807      Query <name> contains an ambiguous column name that is conflicting with the correlation (alias) name <name>. Either fully qualify the column name or change the correlation (alias) name.
3808      Need a version 4.x or greater format system database to perform this operation.
Back to top
 
« Last Edit: 17.08.14 at 10:33:06 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1