Trappable errors from the Microsoft Jet database engine can occur while an application is running, either within the development environment or as a stand-alone executable file. You can test and respond to trappable errors using the Error object.
CodeMessage
2423Invalid use of '.', '!', or '()'.
2426Function isn't available in expressions.
2428Invalid arguments used with domain function.
2430Between operator without And.
2431Syntax error (missing operator).
2434Syntax error (missing operator).
2437Invalid use of vertical bars.
2439Wrong number of arguments used with function.
2442Invalid use of parentheses.
2443Invalid use of Is operator.
2446Out of memory during calculation.
2447Invalid use of '.', '!', or '()'.
3000Reserved error <Item>; there is no message for this error.
3003Couldn't start transaction; too many transactions already nested.
3005<Database name> isn't a valid database name.
3006Database <name> is exclusively locked.
3007Can't open library database <name>.
3010Table <name> already exists.
3012Object <name> already exists.
3013Couldn't rename installable ISAM file.
3014Can't open any more tables.
3016Field won't fit in record.
3017The size of a field is too long.
3018Couldn't find field <name>.
3019Operation invalid without a current index.
3023AddNew or Edit already used.
3024Couldn't find file <name>.
3025Can't open any more files.
3027Can't update. Database or object is read-only.
3029Not a valid account name or password.
3030<Account name> isn't a valid account name.
3032Can't perform this operation.
3034You tried to commit or roll back a transaction without first using BeginTrans.
3036Database has reached maximum size.
3037Can't open any more tables or queries.
3039Couldn't create index; too many indexes already defined.
3040Disk I/O error during read.
3041Can't open a database created with a previous version of your application.
3042Out of MS-DOS file handles.
3045Couldn't use <name>; file already in use.
3046Couldn't save; currently locked by another user.
3048Can't open any more databases.
3052File sharing lock count exceeded.
3054Too many Memo or OLE Object fields.
3056Couldn't repair this database.
3057Operation not supported on linked tables.
3058Index or primary key can't contain a Null value.
3059Operation canceled by user.
3060Wrong data type for parameter <parameter>.
3061Too few parameters. Expected <number>.
3062Duplicate output alias <name>.
3063Duplicate output destination <name>.
3064Can't open action query <name>.
3065Can't execute a select query.
3066Query must have at least one destination field.
3067Query input must contain at least one table or query.
3069The action query <name> cannot be used as a row source.
3070The Microsoft Jet database engine does not recognize <name> as a valid field name or expression.
3073Operation must use an updatable query.
3074Can't repeat table name <name> in FROM clause.
3075<Message> in query expression <expression>.
3076<Name> in criteria expression.
3080Joined table <name> not listed in FROM clause.
3081Can't join more than one table with the same name <name>.
3082JOIN operation <operation> refers to a field that isn't in one of the joined tables.
3083Can't use internal report query.
3084Can't insert data with action query.
3085Undefined function <name> in expression.
3086Couldn't delete from specified tables.
3087Too many expressions in GROUP BY clause.
3088Too many expressions in ORDER BY clause.
3089Too many expressions in DISTINCT output.
3090Resultant table not allowed to have more than one AutoNumber field.
3092Can't use HAVING clause in TRANSFORM statement.
3093ORDER BY clause <clause> conflicts with DISTINCT.
3094ORDER BY clause <clause> conflicts with GROUP BY clause.
3095Can't have aggregate function in expression <expression>.
3096Can't have aggregate function in WHERE clause <clause>.
3097Can't have aggregate function in ORDER BY clause <clause>.
3098Can't have aggregate function in GROUP BY clause <clause>.
3099Can't have aggregate function in JOIN operation <operation>.
3100Can't set field <name> in join key to Null.
3102Circular reference caused by <query reference>.
3103Circular reference caused by alias <name> in query definition's SELECT list.
3104Can't specify fixed column heading <value> in a crosstab query more than once.
3105Missing destination field name in SELECT INTO statement <statement>.
3106Missing destination field name in UPDATE statement <statement>.
3107Record(s) can't be added; no insert permission on <name>.
3108Record(s) can't be edited; no update permission on <name>.
3109Record(s) can't be deleted; no delete permission on <name>.
3110Couldn't read definitions; no read definitions permission for table or query <name>.
3111Couldn't create; no modify design permission for table or query <name>.
3112Record(s) can't be read; no read permission on <name>.
3113Can't update <field name>; field not updatable.
3114Can't include Memo or OLE Object when you select unique values <statement>.
3115Can't have Memo or OLE Object fields in aggregate argument <statement>.
3116Can't have Memo or OLE Object fields in criteria <criteria> for aggregate function.
3117Can't sort on Memo or OLE Object <clause>.
3118Can't join on Memo or OLE Object <name>.
3119Can't group on Memo or OLE Object <clause>.
3120Can't group on fields selected with '*' <table name>.
3121Can't group on fields selected with '*'.
3123Can't use '*' in crosstab query.
3124Can't input from internal report query <name>.
3126Invalid bracketing of name <name>.
3128Specify the table containing the records you want to delete.
3129Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
3130Syntax error in DELETE statement.
3131Syntax error in FROM clause.
3132Syntax error in GROUP BY clause.
3133Syntax error in HAVING clause.
3134Syntax error in INSERT INTO statement.
3135Syntax error in JOIN operation.
3138Syntax error in ORDER BY clause.
3139Syntax error in PARAMETER clause.
3140Syntax error in PROCEDURE clause.
3143Syntax error in TRANSFORM statement.
3144Syntax error in UPDATE statement.
3145Syntax error in WHERE clause.
3151ODBC – connection to <name> failed.
3154ODBC – couldn't find DLL <name>.
3155ODBC – insert on a linked table <table> failed.
3156ODBC – delete on a linked table <table> failed.
3157ODBC – update on a linked table <table> failed.
3158Couldn't save record; currently locked by another user.
3162You tried to assign the Null value to a variable that isn't a Variant data type.
3166Cannot locate the requested Xbase memo file.
3170Couldn't find installable ISAM.
3171Couldn't find network path or user name.
3172Couldn't open Paradox.net.
3173Couldn't open table 'MSysAccounts' in the workgroup information file.
3174Couldn't open table 'MSysGroups' in the workgroup information file.
3175Date is out of range or is in an invalid format.
3176Couldn't open file <name>.
3179Encountered unexpected end of file.
3180Couldn't write to file <name>.
3183Not enough space on temporary disk.
3184Couldn't execute query; couldn't find linked table.
3185SELECT INTO on a remote database tried to produce too many fields.
3186Couldn't save; currently locked by user <name> on machine <name>.
3187Couldn't read; currently locked by user <name> on machine <name>.
3188Couldn't update; currently locked by another session on this machine.
3189Table <name> is exclusively locked by user <name> on machine <name>.
3191Can't define field more than once.
3192Couldn't find output table <name>.
3198Couldn't start session. Too many sessions already active.
3200The record cannot be deleted or changed because table <name> includes related records.
3201You can't add or change a record because a related record is required in table <name>.
3202Couldn't save; currently locked by another user.
3203Subqueries cannot be used in the expression <expression>.
3205Too many crosstab column headers <value>.
3206Can't create a relationship between a field and itself.
3207Operation not supported on a Paradox table with no primary key.
3208Invalid Deleted setting in the Xbase key of the Windows Registry.
3210The connection string is too long.
3212Couldn't lock table <name>; currently in use by user <name> on machine <name>.
3213Invalid Date setting in the Xbase key of the Windows Registry.
3214Invalid Mark setting in the Xbase key of the Windows Registry.
3216Parameter <name> specified where a table name is required.
3217Parameter <name> specified where a database name is required.
3218Couldn't update; currently locked.
3220Incorrect collating sequence.
3221Invalid settings in the Btrieve key of the Windows Registry.
3222Query can't contain a Database parameter.
3223<Parameter name> is invalid because it is too long or contains invalid characters.
3224Can't read Btrieve data dictionary.
3225Encountered a record locking deadlock while performing a Btrieve operation.
3226Errors encountered while using the Btrieve DLL.
3227Invalid Century setting in the Xbase key of the Windows Registry.
3228Selected collating sequence not supported by the operating system.
3229Btrieve–can't change field.
3230Out-of-date Paradox lock file.
3231ODBC–field would be too long; data truncated.
3232ODBC–couldn't create table.
3234ODBC–remote query timeout expired.
3235ODBC–data type not supported on server.
3240Btrieve–missing Btrieve engine.
3242Invalid reference in SELECT statement.
3243None of the import field names match fields in the appended table.
3244Can't import password-protected spreadsheet.
3245Couldn't parse field names from the first row of the import table.
3246Operation not supported in transactions.
3247ODBC – linked table definition has changed.
3248Invalid NetworkAccess setting in the Windows Registry.
3249Invalid PageTimeout setting in the Windows Registry.
3251Operation is not supported for this type of object.
3254ODBC – Can't lock all records.
3257Syntax error in WITH OWNERACCESS OPTION declaration.
3260Couldn't update; currently locked by user <name> on machine <name>.
3261Table <name> is exclusively locked by user <name> on machine <name>.
3262Couldn't lock table <name>; currently in use by user <name> on machine <name>.
3264No field defined – cannot append TableDef or Index.
3265Item not found in this collection.
3266.Can't append a Field that is already a part of a Fields collection.
3267Property can be set only when the Field is part of a Recordset object's Fields collection.
3268Can't set this property once the object is part of a collection.
3269Can't append an Index that is already a part of an Indexes collection.
3272Object isn't a collection.
3273Method not applicable for this object.
3274External table isn't in the expected format.
3275Unexpected error from external database driver <error number>.
3276Invalid database object reference.
3277Can't have more than 10 fields in an index.
3278The Microsoft Jet database engine has not been initialized.
3279The Microsoft Jet database engine has already been initialized.
3280Can't delete a field that is part of an index or is needed by the system.
3281Can't delete this index or table. It is either the current index or is used in a relationship.
3282Operation not supported on a table that contains data.
3283Primary key already exists.
3286Format of memo file doesn't match specified external database format.
3287Can't create index on the given field.
3288Paradox index is not primary.
3289Syntax error in CONSTRAINT clause.
3290Syntax error in CREATE TABLE statement.
3291Syntax error in CREATE INDEX statement.
3292Syntax error in field definition.
3293Syntax error in ALTER TABLE statement.
3294Syntax error in DROP INDEX statement.
3295Syntax error in DROP TABLE or DROP INDEX.
3296Join expression not supported.
3297Couldn't import table or query. No records found, or all records contain errors.
3298There are several tables with that name. Please specify owner in the format 'owner.table'.
3300Can't create a relationship.
3302Can't change a rule while the rules for this table are in use.
3303Can't delete this field. It's part of one or more relationships.
3305Invalid connection string in pass-through query.
3307The number of columns in the two selected tables or queries of a union query don't match.
3308Invalid TOP argument in select query.
3309Property setting can't be larger than 2K.
3311Property specified already exists.
3312Validation rules and default values can't be placed on system or linked tables.
3313Can't place this validation expression on this field.
3315Field <name> can't be a zero-length string.
3316<Table-level validation text>.
3318Values specified in a TOP clause are not allowed in delete queries or reports.
3319Syntax error in union query.
3320<Error> in table-level validation expression.
3321No database specified in connection string or IN clause.
3322Crosstab query contains one or more invalid fixed column headings.
3323The query cannot be used as a row source.
3324The query is a DDL query and cannot be used as a row source.
3325Pass-through query with ReturnsRecords property set to True did not return any records.
3326This Recordset is not updatable.
3334Can be present only in version 1.0 format.
3336Btrieve: Invalid IndexDDF option in initialization setting.
3337Invalid DataCodePage option in initialization setting.
3338Btrieve: Xtrieve options aren't correct in initialization setting.
3339Btrieve: Invalid IndexDeleteRenumber option in initialization setting.
3342Invalid Memo or OLE Object in subquery <name>.
3343Unrecognized database format <filename>.
3345Unknown or invalid field reference <name>.
3346Number of query values and destination fields aren't the same.
3350Object is invalid for operation.
3352No destination field name in INSERT INTO statement <statement>.
3353Btrieve: Can't find file Field.ddf.
3354At most one record can be returned by this subquery.
3355Syntax error in default value.
3357This query is not a properly formed data-definition query.
3358Can't open the Microsoft Jet engine workgroup information file.
3359Pass-through query must contain at least one character.
3361Unions not allowed in a subquery.
3364Can't use Memo or OLE Object field <name> in the SELECT clause of a union query.
3365Can't set this property for remote objects.
3366Can't append a relation with no fields defined.
3367Can't append. An object with that name already exists in the collection.
3368Relationship must be on the same number of fields with the same data types.
3370Can't modify the design of table <name>. It's in a read-only database.
3371Can't find table or constraint.
3372No such index <name> on table <name>.
3373Can't create relationship. Referenced table <name> doesn't have a primary key.
3374The specified fields are not uniquely indexed in table <name>.
3375Table <name> already has an index named <name>.
3376Table <name> doesn't exist.
3377No such relationship <name> on table <name>.
3378There is already a relationship named <name> in the current database.
3380Field <name> already exists in table <name>.
3381There is no field named <name> in table <name>.
3382Size of field <name> is too long.
3383Can't delete field <name>. It's part of one or more relationships.
3384Can't delete a built-in property.
3385User-defined properties don't support a Null value.
3386Property <name> must be set before using this method.
3388Unknown function <name> in validation expression or default value on <name>.
3389Query support unavailable.
3390Account name already exists.
3394Can't save property; property is a schema property.
3397Can't perform cascading operation. There must be a related record in table <name>.
3398Can't perform cascading operation. It would result in a null key in table <name>.
3399Can't perform cascading operation. It would result in a duplicate key in table <name>.
3403Can't perform cascading operation: <validation text>.
3405Error <error text> in validation rule.
3409Invalid field definition <name> in definition of index or relationship.
3412Can't perform cascading update on the table because it is currently in use by another user.
3414Can't perform cascading operation on table <name> because it is currently in use.
3415Zero-length string is valid only in a Text or Memo field.
3417An action query cannot be used as a row source.
3420Object is invalid or no longer set.
3421Data type conversion error.
3422Can't modify table structure. Another user has the table open.
3424Can't create database because the locale is invalid.
3429Incompatible version of an installable ISAM.
3430While loading the Microsoft Excel installable ISAM, OLE was unable to initialize.
3431This is not a Microsoft Excel 5.0 file.
3432Error opening a Microsoft Excel 5.0 file.
3433Invalid setting in Excel key of the Engines section of the Windows Registry.
3435Cannot delete spreadsheet cells.
3438The data being exported does not match the format described in the Schema.ini file.
3441Text file specification field separator matches decimal separator or text delimiter.
3442In the text file specification <name>, the <name> option is invalid.
3443The fixed-width specification <name> contains no column widths.
3444In the fixed width specification <name>, column <column> does not specify a width.
3445Incorrect version of the DLL file <name> was found.
3449No country code found in the connection string.
3452You can't make changes to the design of the database at this replica.
3455Can't make the database replicable.
3456The object named <name> in the <name> collection cannot be made replicable.
3457You can't set the KeepLocal property for an object that is already replicated.
3461The replication property you are attempting to set or delete is read-only and can't be changed.
3463Can't find the .dll <name>.
3464Data type mismatch in criteria expression.
3465The disk drive you are attempting to access is unreadable.
3468Access was denied while accessing dropbox folder <name>.
3469The disk for dropbox folder <name> is full.
3470Disk failure accessing dropbox folder <name>.
3471Failure to write to the Synchronizer log file.
3472Disk full for path <name>.
3473Disk failure while accessing log file <name>.
3474Can't open the log file <name> for writing.
3475Sharing violation while attempting to open log file <name> in Deny Write mode.
3476Invalid dropbox path <name>.
3477Dropbox address <name> is syntactically invalid.
3478The replica is not a partial replica.
3479Can't designate a partial replica as the Design Master for the replica set.
3480The relationship <name> in the partial filter expression is invalid.
3481The table name <name> in the partial filter expression is invalid.
3482The filter expression for the partial replica is invalid.
3483The password supplied for the dropbox folder <name> is invalid.
3484The password used by the Synchronizer to write to a destination dropbox folder is invalid.
3485The object can't be replicated because the database is not replicated.
3486You can't add a second Replication ID AutoNumber field to a table.
3487The database you are attempting to replicate can't be converted.
3488The value specified is not a ReplicaID for any member in the replica set.
3489The object specified can't be replicated because it is missing a necessary resource.
3491The database must be opened in exclusive mode before it can be replicated.
3492The synchronization failed because a design change could not be applied to one of the replicas.
3493Can't set the specified Registry parameter for the Synchronizer.
3494Unable to retrieve the specified Registry parameter for the Synchronizer.
3495There are no scheduled synchronizations between the two Synchronizers.
3496Replication Manager cannot find the ExchangeID in the MSysExchangeLog table.
3497Unable to set a schedule for the Synchronizer.
3499Can't retrieve the full path information for a member of the replica set.
3500You cannot specify two different Synchronizers to manage the same replica.
3502The Design Master or replica is not being managed by a Synchronizer.
3503The Synchronizer's Registry has no value set for the key you queried.
3504The Synchronizer ID does not match an existing ID in the MSysTranspAddress table.
3506The Synchronizer is unable to open the Synchronizer log.
3507Failure writing to the Synchronizer log.
3508There is no active transport for the Synchronizer.
3509Could not find a valid transport for this Synchronizer.
3512Failed to read the dropbox folder.
3513Failed to write to the dropbox folder.
3514Synchronizer could not find any scheduled or on-demand synchronizations to process.
3515The Microsoft Jet database engine could not read the system clock on your computer.
3516Could not find transport address.
3517Synchronizer could not find any messages to process.
3518Could not find Synchronizer in the MSysTranspAddress table.
3520The replica name or ID does not match a currently managed member of the replica set.
3522Synchronizer cannot find the record of a specific synchronization in the MSysExchangeLog table.
3523Synchronizer cannot find a specific version number in the MSysSchChange table.
3524The history of design changes in the replica does not match the history in the Design Master.
3525Synchronizer could not access the message database.
3526The name selected for the system object is already in use.
3527The Synchronizer or Replication Manager could not find the system object.
3528There is no new data in shared memory for the Synchronizer or Replication Manager to read.
3530The Synchronizer is already serving a client.
3531The wait period for an event has timed out.
3532Synchronizer could not be initialized.
3533The system object used by a process still exists after the process has stopped.
3534Synchronizer looked for a system event but did not find one to report to the client.
3535Client has asked the Synchronizer to terminate operation.
3536Synchronizer received an invalid message for a member of the replica set that it manages.
3538Cannot initialize Synchronizer because there are too many applications running.
3539A system error has occurred or your swap file has reached its limit.
3540Your swap file has reached its limit or is corrupted.
3541Synchronizer could not be shut down properly and is still active.
3542Process stopped when attempting to terminate Synchronizer client.
3543Synchronizer has not been set up.
3544Synchronizer is already running.
3545The two replicas you are attempting to synchronize are from different replica sets.
3546The type of synchronization you are attempting is not valid.
3547Synchronizer could not find a replica from the correct set to complete the synchronization.
3548GUIDs do not match or the requested GUID could not be found.
3549The file name you provided is too long.
3550There is no index on the GUID column.
3551Unable to delete the specified Registry parameter for the Synchronizer.
3552The size of the Registry parameter exceeds the maximum allowed.
3553The GUID could not be created.
3555All valid nicknames for replicas are already in use.
3556Invalid path for destination dropbox folder.
3557Invalid address for destination dropbox folder.
3558Disk I/O error at destination dropbox folder.
3559Failure to write because destination disk is full.
3560The two members of the replica set you are attempting to synchronize have the same ReplicaID.
3561The two members of the replica set you are attempting to synchronize are both Design Masters.
3562Access denied at destination dropbox folder.
3563Fatal error accessing a local dropbox folder.
3564Synchronizer can't find the source file for messages.
3567Message in dropbox folder belongs to the wrong Synchronizer.
3568Synchronizer could not delete a file.
3571The attempt to set a column in a partial replica violated a rule governing partial replicas.
3572A disk I/O error occurred while reading or writing to the TEMP directory.
3574The ReplicaID for this member of the replica set was reassigned during a move or copy procedure.
3575The disk drive you are attempting to write to is full.
3576The database you are attempting to open is already in use by another application.
3577Can't update replication system column.
3578Failure to replicate database; can't determine whether the database is open in exclusive mode.
3581Can't open replication system table <name> because the table is already in use.
3583Cannot make the <name> object in <name> container replicable.
3584Insufficient memory to complete operation.
3586Syntax error in partial filter expression on table <name>.
3587Invalid expression in the ReplicaFilter property.
3588Error when evaluating the partial filter expression.
3589The partial filter expression contains an unknown function.
3593You can't change the data master attribute for the replica set.
3595The system tables in your replica are no longer reliable and the replica should not be used.
3607The replication property you are attempting to delete is read-only and cannot be removed.
3608Record length is too long for an indexed Paradox table.
3609No unique index found for the referenced field of the primary table.
3610Same table <table> referenced as both the source and destination in a make-table query.
3611Can’t execute data definition statements on linked data sources.
3612Multi-level GROUP BY clause is not allowed in a subquery.
3613Can’t create a relationship on linked ODBC tables.
3614GUID not allowed in Find method criteria expression.
3615Type mismatch in JOIN expression.
3616Updating data in a linked table is not supported by this ISAM.
3617Deleting data in a linked table is not supported by this ISAM.
3618Exceptions table could not be created on import/export.
3619Records could not be added to exceptions table.
3620The connection for viewing your linked Microsoft Excel worksheet was lost.
3621Can’t change password on a shared open database.
3623Cannot access the FoxPro 3.0 bound DBF file <filename>.
3624Couldn’t read the record; currently locked by another user.
3627Cannot find the executable file for the Synchronizer (mstran35.exe).
3628Partner replica is not managed by a Synchronizer.
3629This Synchronizer and Synchronizer <name> have the same File System dropbox – <name>.
3631Invalid table name in filter.
3632Remote Synchronizer is not configured for remote synchronization.
3634Cannot create a replica using a partial replica.
3635Cannot create partial replica of a workgroup information file.
3637Cannot use the crosstab of a non-fixed column as a subquery.
3639Cannot create a replica of a workgroup information file.
3640The fetch buffer was too small for the amount of data you requested.
3641There are fewer records remaining in the Recordset than you requested.
3642A cancel was performed on the operation.
3643One of the records in the Recordset was deleted by another process.
3645One of the binding parameters is incorrect.
3646The specified row length is shorter than the sum of the column lengths.
3647A column requested is not being returned to the Recordset.
3648Cannot synchronize a partial replica with another partial replica.
3649The language-specific code page was not specified or could not be found.