ACC2: Complete Reserved Error List for Microsoft Access 2.0ID: Q115846
|
Moderate: Requires basic macro, coding, and interoperability skills.
This article lists the reserved error codes for Microsoft Access
version 2.0. These error codes are subject to change without notice
when Microsoft Access is upgraded.
If you encounter a Reserved Error message, check the Microsoft Knowledge
Base for specific error numbers, because there may be an article with
information about that error code. If you do not find an article about a
specific error, report it to Microsoft Product Support Services; reserved
error messages should not appear in Microsoft Access.
Some error codes do not have associated messages because Microsoft did
not expect that these error codes would be encountered.
JET_wrnNyi -1 Function Not Yet Implemented
JET_errRfsFailure* -100 JET_errRfsFailure
JET_errRfsNotArmed* -101 JET_errRfsFailure
JET_errPageBoundary -200 Reached Page Boundary
JET_errKeyBoundary -201 Reached Key Boundary
JET_wrnRemainingVersions 202 Some versions could not be
cleaned
JET_errFileClose -203 Could not close OS file
JET_errNoMoreThreads -204 Could not start thread
JET_errNoComputerName -205 fail to get computername
JET_errTooManyIO -206 System busy due to too many
IO's
JET_errFeatureNotAvailable -1001 API not supported
JET_errInvalidName -1002 Invalid name
JET_errInvalidParameter -1003 Invalid API parameter
JET_wrnColumnNull 1004 Column is NULL-valued
JET_errReferenceNotFound -1005 No such reference
JET_wrnBufferTruncated 1006 Buf too short, data truncated
JET_wrnDatabaseAttached 1007 Database is already attached
JET_wrnOnEndPoint 1008 On end point
JET_wrnSortOverflow 1009 Sort does not fit in memory
JET_errInvalidDatabaseId -1010 Invalid database id
JET_errOutOfMemory -1011 Out of Memory
JET_errCantAllocatePage -1012 Couldn't allocate a page
JET_errNoMoreCursors -1013 Max # of cursors allocated
JET_errOutOfBuffers -1014 JET_errOutOfBuffers
JET_errTooManyIndexes -1015 Too many indexes
JET_errTooManyKeys -1016 Too many columns in an index
JET_errRecordDeleted -1017 Record has been deleted
JET_errReadVerifyFailure -1018 Read verification error
JET_errFilesysVersion -1019 Obsolete database format
JET_errNoMoreFiles -1020 No more file handles
JET_errDiskNotReady -1021 Disk not ready
JET_errDiskIO -1022 JET_errDiskIO
JET_errInvalidPath -1023 JET_errInvalidPath
JET_errFileShareViolation -1024 JET_errFileShareViolation
JET_errFileLockViolation -1025 JET_errFileLockViolation
JET_errRecordTooBig -1026 JET_errRecordTooBig
JET_errTooManyOpenDatabases -1027 Database limit reached
JET_errInvalidDatabase -1028 This isn't a database
JET_errNotInitialized -1029 JetInit not yet called
JET_errAlreadyInitialized -1030 JetInit already called
JET_errFileLockingUnavailable -1031 JET_errFileLockingUnavailable
JET_errFileAccessDenied -1032 JET_errFileAccessDenied
JET_errSharingBufferExceeded -1033 OS sharing buffer exceeded
JET_errQueryNotSupported -1034 Query support unavailable
JET_errSQLLinkNotSupported -1035 SQL Link support unavailable
JET_errTaskLimitExceeded -1036 Too many client tasks
JET_errUnsupportedOSVersion -1037 Unsupported OS version
JET_errBufferTooSmall -1038 Buffer is too small
JET_wrnSeekNotEqual 1039 SeekLE or SeekGE didn't find
exact match
JET_errTooManyColumns -1040 Too many columns defined
JET_errTooManyFixedColumns -1041 Too many fixed columns
defined
JET_errTooManyVariableColumns -1042 Too many variable columns
defined
JET_errContainerNotEmpty -1043 Container is not empty
JET_errInvalidFilename -1044 Filename is invalid
JET_errInvalidBookmark -1045 Invalid bookmark
JET_errColumnInUse -1046 Column used in an index
JET_errInvalidBufferSize -1047 Data buffer doesn't match
column size
JET_errColumnNotUpdatable -1048 Can't set column value
JET_wrnCommitNotFlushed 1049 Commit did not flush to disk
JET_errAbortSalvage -1050 Forced Salvager abort
JET_errIndexInUse -1051 Index is in use
JET_errLinkNotSupported -1052 Link support unavailable
JET_errNullKeyDisallowed -1053 Null keys are disallowed on
index
JET_errNotInTransaction -1054 JET_errNotInTransaction
JET_wrnNoErrorInfo 1055 No extended error information
JET_errInstallableIsamNotFound -1056 Installable ISAM not found
JET_errOperationCancelled -1057 Operation canceled by client
JET_wrnNoIdleActivity 1058 No idle activity occurred
JET_errTooManyActiveUsers -1059 Too many active database
users
JET_errInvalidAppend -1060 Cannot append long value
JET_errInvalidCountry -1061 Invalid or unknown country
code
JET_errInvalidLanguageId -1062 Invalid or unknown language
id
JET_errInvalidCodePage -1063 Invalid or unknown code page
JET_errCantBuildKey -1064 Can't build key for this sort
order.
JET_errIllegalReentrancy -1065 Re-entrancy on same cursor
family
JET_errIllegalRelationship -1066 Can't create relationship
JET_wrnNoWriteLock 1067 No write lock at transaction
level 0
JET_errDBVerFeatureNotAvailable -1067 API not supported using old
database format
JET_errIllegalRIConstraint -1068 Illegal referrential
constraint
JET_wrnNoMessageForError 1069 No message for error
JET_errCantBegin -1101 Cannot BeginSession
JET_errWriteConflict -1102 Write lock failed due to
outstanding write lock
JET_errTransTooDeep -1103 Xactions nested too deeply
JET_errInvalidSesid -1104 Invalid session handle
JET_errReadConflict -1105 Commit lock failed due to
outstanding read lock
JET_errCommitConflict -1106 Read lock failed due to
outstanding commit lock
JET_errSessionWriteConflict -1107 Another session has private
version of page
JET_errInTransaction -1108 Operation not allowed within
a transaction
JET_errTooManySessions -1109 Too many active sessions
JET_errDatabaseDuplicate -1201 Database already exists
JET_errDatabaseInUse -1202 Database in use, can't detach
JET_errDatabaseNotFound -1203 No such database
JET_errDatabaseInvalidName -1204 Invalid database name
JET_errDatabaseInvalidPages -1205 Invalid number of pages
JET_errDatabaseCorrupted -1206 non-db file or corrupted db
JET_errDatabaseLocked -1207 Database exclusively locked
JET_wrnDatabaseEncrypted 1208 Database is encrypted
JET_errDatabaseCorrupted_Cmpct -1209 Database is corrupted. Run
repair *AND* compact
JET_wrnTableEmpty 1301 Open an empty table
JET_errTableLocked -1302 Table is exclusively locked
JET_errTableDuplicate -1303 Table already exists
JET_errTableInUse -1304 Table is in use, cannot lock
JET_errObjectNotFound -1305 No such table or object
JET_errCannotRename -1306 Cannot rename temporary file
JET_errDensityInvalid -1307 Bad file/index density
JET_errTableNotEmpty -1308 Cannot define clustered index
JET_errTableNotLocked -1309 No DDLs w/o exclusive lock
JET_errInvalidTableId -1310 Invalid table id
JET_errTooManyOpenTables -1311 Cannot open any more tables
JET_errIllegalOperation -1312 Oper. not supported on table
JET_wrnExecSegReleased 1313 Query Execution segment is
released
JET_errObjectDuplicate -1314 Table or object name in use
JET_errRulesLoaded -1315 Rules loaded, can't define
more
JET_errInvalidObject -1316 object is invalid for
operation
JET_errInvalidCursorName -1317 Invalid Cursor Name
JET_errIndexCantBuild -1401 Cannot build clustered index
JET_errIndexHasPrimary -1402 Primary index already defined
JET_errIndexDuplicate -1403 Index is already defined
JET_errIndexNotFound -1404 No such index
JET_errIndexMustStay -1405 Cannot delete clustered index
JET_errIndexInvalidDef -1406 Illegal index definition
JET_errSelfReference -1407 Referencing/Referenced index
is the same
JET_errIndexHasClustered -1408 Clustered index already
defined
JET_errColumnLong -1501 column value is long
JET_errColumnNoChunk -1502 no such chunk in field
JET_errColumnDoesNotFit -1503 Field will not fit in record
JET_errNullInvalid -1504 Null not valid
JET_errColumnTooBig -1506 Field length is > maximum
JET_errColumnNotFound -1507 No such column
JET_errColumnDuplicate -1508 Field is already defined
JET_errTaggedDefault -1509 No defaults on tagged fields
JET_errColumn2ndSysMaint -1510 Second autoinc or version
column
JET_errInvalidColumnType -1511 Invalid column data type
JET_wrnColumnMaxTruncated 1512 Max length too big, truncated
JET_errColumnCannotIndex -1513 Cannot index Bit, LongText,
LongBinary
JET_errTaggedNotNULL -1514 No non-NULL tagged fields
JET_errNoCurrentIndex -1515 Invalid w/o a current index
JET_errKeyIsMade -1516 The key is completely made
JET_errBadColumnId -1517 Column Id Incorrect
JET_errBadItagSequence -1518 Bad itagSequence for tagged
column
JET_errColumnInRelationship -1519 Cannot delete, column
participates in relationship
JET_wrnCopyLongValue 1520 Single instance column
bursted
JET_errCannotBeTagged -1521 AutoIncrement and Version
cannot be tagged
JET_errRelNoPrimaryIndex -1522 No primary index on
referenced table
JET_errNoBlank -1523 Zero length string invalid
JET_errRecordNotFound -1601 The key was not found
JET_errRecordNoCopy -1602 No working buffer
JET_errNoCurrentRecord -1603 Currency not on a record
JET_errRecordClusteredChanged -1604 Clustered key may not change
JET_errKeyDuplicate -1605 Illegal duplicate key
JET_errCannotInsertBefore -1606 Cannot insert before current
JET_errAlreadyPrepared -1607 Already copy/clear current
JET_errKeyNotMade -1608 No call to JetMakeKey
JET_errUpdateNotPrepared -1609 No call to JetPrepareUpdate
JET_wrnDataHasChanged 1610 Data has changed
JET_errDataHasChanged -1611 Data has changed; operation
aborted
JET_errIntegrityViolationMaster -1612 References to key exist
JET_errIntegrityViolationSlave -1613 No referenced key exists
JET_wrnMuchDataChanged 1614 Repaint whole datasheet
JET_errIncorrectJoinKey -1615 Master key does not match
lookup key
JET_wrnCannotUndo 1616 Cannot undo JetUpdate
JET_wrnMuchChangedNoUndo 1617 Repaint datasheet, cannot
undo
JET_wrnKeyChanged 1618 Moved to new key
JET_errRIKeyNullDisallowed -1621 null value as a result of RI
action disallowed
JET_errRIKeyDuplicate -1622 duplicate key as a result of
RI action
JET_errRIUpdateTwice -1623 tried to update some field in
a record twice
JET_wrnRIRecordsUpdated 1624 some additional records got
updated due to RI actions
JET_wrnRIRecordsDeleted 1625 some additional records got
deleted due to RI actions
JET_wrnRIRecordsUpdAndDel 1626 some additional records got
updated and deleted due to RI
actions
JET_errRIInvalidBufferSize -1627 data size exceeds column size
JET_errRIWriteConflict -1628 write conflict due to
cascading
JET_errRISessWriteConflict -1629 session write conflict due to
cascading
JET_wrnSyncedToDelRec 1699 CONSIDER: QJET INTERNAL
JET_errRedoPrepUpdate 1698 CONSIDER: QJET
JET_errTooManySorts -1701 Too many sort processes
JET_errInvalidOnSort -1702 Invalid operation on Sort
JET_errSysDatabaseOpenError -1802 System db could not be opened
JET_errDatabaseOpenError -1804 Database file can't be opened
JET_errTooManyAttachedDatabases -1805 Too many open databases
JET_errDatabaseCloseError -1806 Db file could not be closed
JET_errTooManyOpenFiles -1807 Too many files open
JET_errDiskFull -1808 No space left on disk
JET_errPermissionDenied -1809 Permission denied
JET_errFileNotFound -1811 File not found
JET_errTempDiskFull -1812 No space left on disk
JET_wrnFileOpenReadOnly 1813 Database file is read only
JET_errAfterInitialization -1850 Cannot Restore after init.
JET_errLogCorrupted -1852 Logs could not be interpreted
JET_errCannotOpenSystemDb -1901 failed sysdb on beginsession
JET_errInvalidLogon -1902 invalid logon at beginsession
JET_errInvalidAccountName -1903 invalid account name
JET_errInvalidSid -1904 invalid SID
JET_errInvalidPassword -1905 invalid password
JET_errInvalidOperation -1906 invalid operation
JET_errAccessDenied -1907 access denied
JET_errNoMSysAccounts -1908 Can't open MSysAccounts
JET_errNoMSysGroups -1909 Can't open MSysGroups
JET_errInvalidPin -1910 invalid pin
JET_errAccountDuplicate -1911 account name already exists
JET_errRmtSqlError -2001 RMT: ODBC call failed
JET_errRmtMissingOdbcDll -2006 RMT: Can't load ODBC DLL
JET_errRmtInsertFailed -2007 RMT: Insert statement failed
JET_errRmtDeleteFailed -2008 RMT: Delete statement failed
JET_errRmtUpdateFailed -2009 RMT: Update statement failed
JET_errRmtColDataTruncated -2010 RMT: data truncated
JET_errRmtTypeIncompat -2011 RMT: Can't create JET type on
server
JET_errRmtCreateTableFailed -2012 RMT: Create table stmt failed
JET_errRmtNotSupported -2014 RMT: Function not legal for
rdb
JET_errRmtValueOutOfRange -2020 RMT: Data value out of range
JET_errRmtStillExec -2021 RMT INTERNAL:
SQL_STILL_EXECUTING
JET_errRmtQueryTimeout -2022 RMT: Server Not Responding
JET_wrnRmtNeedLvData 2023 RMT: Internal only - need Lv
data
JET_wrnFatCursorUseless 2024 Fat cursor has no effect **
JET_errRmtWrongSPVer -2025 RMT: INTERNAL: wrong SProc
ver **
JET_errRmtLinkOutOfSync -2026 RMT: the def for the rmt tbl
has changed
JET_errRmtDenyWriteIsInvalid -2027 RMT: Can't open DenyWrite
JET_errRmtDriverCantConv -2029 RMT: INTERNAL: driver cannot
convert
JET_errRmtTableAmbiguous -2030 RMT: Table ambiguous: must
specifier owner
JET_errRmtBogusConnStr -2031 RMT: SPT: Bad connect string
JET_errRmtMultiRowUpdate -2032 RMT: unique index not really
unique
JET_errBadMSysConf -2033 RMT: improper MSysConf
JET_errRmtDriverNotSupported -2034 RMT: ODBC driver not
supported through JET
JET_errQueryInvalidAttribut -3001 Invalid query attribute
JET_errQueryOnlyOneRow -3002 Only 1 such row allowed
JET_errQueryIncompleteRow -3003 Missing value in row
JET_errQueryInvalidFlag -3004 Invalid value in Flag field
JET_errQueryCycle -3005 Cycle in query definition
JET_errQueryInvalidJoinTable -3006 Invalid table in join
JET_errQueryAmbigRef -3007 Ambiguous column reference
JET_errQueryUnboundRef -3008 Cannot bind name
JET_errQueryParmRedef -3009 Parm redefined with different
type
JET_errQueryMissingParms -3010 Too few parameters supplied
JET_errQueryInvalidOutput -3011 Invalid query output
JET_errQueryInvalidHaving -3012 HAVING clause without
aggregation
JET_errQueryDuplicateAlias -3013 Duplicate output alias
JET_errQueryInvalidMGBInput -3014 Cannot input from MGB
JET_errQueryInvalidOrder -3015 Invalid ORDER BY expression
JET_errQueryTooManyLevels -3016 Too many levels on MGB
JET_errQueryMissingLevel -3017 Missing intermediate MGB
level
JET_errQueryIllegalAggregate -3018 Aggregates not allowed
JET_errQueryDuplicateOutput -3019 Duplicate destination output
JET_errQueryIsBulkOp -3020 Grbit should be set for Bulk
Operation
JET_errQueryIsNotBulkOp -3021 Query is not a Bulk Operation
JET_errQueryIllegalOuterJoin -3022 No inconsistent updates on
outer joins
JET_errQueryNullRequired -3023 Column must be NULL
JET_errQueryNoOutputs -3024 Query must have an output
JET_errQueryNoInputTables -3025 Query must have an input
JET_wrnQueryNonUpdatableRvt 3026 Query is not updatable (but
IS RVT)
JET_errQueryInvalidAlias -3027 Bogus character in alias name
JET_errQueryInvalidBulkInput -3028 Cannot input from bulk
operation
JET_errQueryNotDirectChild -3029 T.* must use direct child
JET_errQueryExprEvaluation -3030 Expression evaluation error
JET_errQueryIsNotRowReturning -3031 Query does not return rows
JET_wrnQueryNonRvt 3032 Can't create RVT, query is
static
JET_errQueryParmTypeMismatch -3033 Wrong parameter type given
JET_errQueryChanging -3034 Query Objects are being
updated
JET_errQueryNotUpdatable -3035 Operation must use an
updatable query
JET_errQueryMissingColumnName -3036 Missing destination column
JET_errQueryTableDuplicate -3037 Repeated table name in FROM
list
JET_errQueryIsMGB -3038 Query is an MGB
JET_errQueryInsIntoBulkMGB -3039 Cannot insert into Bulk/MGB
JET_errQueryDistinctNotAllowed -3040 DISTINCT not allowed for MGB
JET_errQueryDistinctRowNotAllow -3041 DISTINCTROW not allowed for
MGB
JET_errQueryNoDbForParmDestTbl -3045 Dest DB for VT parm not
allowed
JET_errQueryDuplicatedFixedSet -3047 Duplicated Fixed Value
JET_errQueryNoDeleteTables -3048 Must specify tables to delete
from
JET_errQueryCannotDelete -3049 Cannot delete from specified
tables
JET_errQueryTooManyGroupExprs -3050 Too many GROUP BY expressions
JET_errQueryTooManyOrderExprs -3051 Too many ORDER BY expressions
JET_errQueryTooManyDistExprs -3052 Too many DISTINCT output
expressions
JET_errQueryBadValueList -3053 Malformed value list in
Transform
JET_errConnStrTooLong -3054 Connect string too long
JET_errQueryInvalidParm -3055 Invalid Parmeter Name (>64
char)
JET_errQueryContainsDbParm -3056 Can't get parameters with Db
Parm
JET_errQueryBadUpwardRefed -3057 Illegally Upward ref'ed
JET_errQueryAmbiguousJoins -3058 Joins in a QO are ambiguous
JET_errQueryIsNotDDL -3059 Not a DDL Operation
JET_errNoDbInConnStr -3060 No database in connect string
JET_wrnQueryIsNotRowReturning 3061 Not row returning
JET_errSingleColumnExpected -3063 At most one column can be
returned from this subquery
JET_errColumnCountMismatch -3064 Union Query: number of
columns in children don't
match
JET_errQueryTopNotAllowed -3065 Top not allowed in query
JET_errQueryIsDDL -3066 Must set JET_bitTableDDL
JET_errQueryIsCorrupt -3067 Query is Corrupted
JET_errQuerySPTBulkSucceeded -3068 INTERNAL only
JET_errSPTReturnedNoRecords -3069 SPT marked as RowReturning
did not return a table
JET_errSingleRecordExpected -3070 At most one record can be
returned from this subquery
JET_errQueryTooComplex -3071 Query too complex; push
expressions into UDFs and
reduce number of columns
JET_errSetOpInvalidInSubquery -3072 Unions not allowed in a
subquery
JET_errQueryKeyTooBig -3073 join, group, or sort key is
too big
JET_errNoMostMany -3074 most many info can not be
obtained
JET_wrnAmbiguousMostMany 3075 a unique mostmany table was
unable to be determined
JET_errQueryIsNotRvt -3076 query is not an RVT
JET_errTooManyFindSessions -3077 Too many FastFind Sessions
were invoked
JET_errQueryNotCheap -3078 INTERNAL: For use with
JET_bitTableOnlyIfCheap
JET_errExprSyntax -3100 Syntax error in expression
JET_errExprIllegalType -3101 Illegal type in expression
JET_errExprUnknownFunction -3102 Unknown function in
expression
JET_errSQLSyntax -3500 Bogus SQL statement type
JET_errSQLParameterSyntax -3501 Parameter clause syntax error
JET_errSQLInsertSyntax -3502 INSERT clause syntax error
JET_errSQLUpdateSyntax -3503 UPDATE clause syntax error
JET_errSQLSelectSyntax -3504 SELECT clause syntax error
JET_errSQLDeleteSyntax -3505 Expected 'FROM' after
'DELETE'
JET_errSQLFromSyntax -3506 FROM clause syntax error
JET_errSQLGroupBySyntax -3507 GROUP BY clause syntax error
JET_errSQLOrderBySyntax -3508 ORDER BY clause syntax error
JET_errSQLLevelSyntax -3509 LEVEL syntax error
JET_errSQLJoinSyntax -3510 JOIN syntax error
JET_errSQLTransformSyntax -3511 TRANSFORM syntax error
JET_errSQLHavingSyntax -3512 HAVING clause syntax error
JET_errSQLWhereSyntax -3513 WHERE clause syntax error
JET_errSQLProcedureSyntax -3514 Expected query name after
'PROCEDURE'
JET_errSQLNotEnoughBuf -3515 Buffer too small for SQL
string
JET_errSQLMissingSemicolon -3516 Missing ; at end of SQL
statement
JET_errSQLTooManyTokens -3517 Characters after end of SQL
statement
JET_errSQLOwnerAccessSyntax -3518 OWNERACCESS OPTION syntax
error
JET_errNoInsertColumnName -3519 No dest. col. name in INSERT
stmt
JET_errQueryWrongNumDestCol -3520 Too few/many destination
columns
JET_errV11NotSupported -3530 not supported in V11
JET_errV10Format -3531 can be present in V10 format
only
JET_errSQLUnionSyntax -3532 UNION query syntax error
JET_wrnSqlPassThrough 3534 Pass Through query involved
JET_errSQLInvalidSPT -3535 SPT Must be at least one char
JET_errDDLConstraintSyntax -3550 constraint syntax error
JET_errDDLCreateTableSyntax -3551 create table syntax error
JET_errDDLCreateIndexSyntax -3552 create index syntax error
JET_errDDLColumnDefSyntax -3553 column def syntax error
JET_errDDLAlterTableSyntax -3554 alter table syntax error
JET_errDDLDropIndexSyntax -3555 drop index syntax error
JET_errDDLDropSyntax -3556 drop column or constraint
syntax error
JET_errDDLDiffNumRelCols -3560 different number of cols in
relationship
JET_errDDLIndexColNotFound -3561 creating index on non-
existant column
JET_errNoSuchProperty -3600 Property was not found
JET_errPropertyTooLarge -3601 Small Property larger than 2K
JET_errJPMInvalidForV1x -3602 No JPM for non Red-V2
databases
JET_errPropertyExists -3603 Property already exists
JET_errInvalidDelete -3604 DeleteOnly called with non-
zero cbData
JET_wrnPropCouldNotSave 3605 Optimization to save props
failed
JET_errPropMustBeDDL -3606 You must be set
JET_bitPropDDL to set/delete
this property
JET_wrnFindWrapped 3700 Cursor wrapped during fast
find
JET_errTLVNativeUserTablesOnly -3700 TLVs can only be placed on
native user tables/columns
JET_errTLVNoNull -3701 This field cannot be null
JET_errTLVNoBlank -3702 This column cannot be blank
JET_errTLVRuleViolation -3703 This validation rule must be
met
JET_errTLVInvalidColumn -3704 This TLV property cannot be
placed on this column
JET_errTLVDefaultExprEvaluation -3705 Default value expression
evaluation error
JET_errTLVExprUnknownFunc -3706 Unknown function in TLV
expression
JET_errTLVExprSyntax -3707 Syntax error in TLV
expression
JET_errDefaultExprSyntax -3708 Syntax error in Default
expression
JET_errTLVRuleExprEvaluation -3709 Rule expression evaluation
error
JET_errGeneral -5001 I-ISAM: assert failure
JET_errRecordLocked -5002 I-ISAM: record locked
JET_wrnColumnDataTruncated 5003 I-ISAM: data truncated
JET_errTableNotOpen -5004 I-ISAM: table is not open
JET_errDecryptFail -5005 I-ISAM: incorrect password
JET_wrnCurrencyLost 5007 I-ISAM: currency lost - must
first/last
JET_errDateOutOfRange -5008 I-ISAM: invalid date
JET_wrnOptionsIgnored 5011 I-ISAM: options were ignored
JET_errTableNotComplete -5012 I-ISAM: incomplete table
definition
JET_errIllegalNetworkOption -5013 I-ISAM: illegal network
option
JET_errIllegalTimeoutOption -5014 I-ISAM: illegal timeout
option
JET_errNotExternalFormat -5015 I-ISAM: invalid file format
JET_errUnexpectedEngineReturn -5016 I-ISAM: unexpected engine
error code
JET_errNumericFieldOverflow -5017 I-ISAM: can't convert to
native type
JET_errIndexHasNoPrimary -5020 Paradox: no primary index
JET_errTableSortOrderMismatch -5021 Paradox: sort order mismatch
JET_errNoConfigParameters -5023 Paradox: net path or user
name missing
JET_errCantAccessParadoxNetDir -5024 Paradox: bad Paradox net path
JET_errObsoleteLockFile -5025 Paradox: obsolete lock file
JET_errIllegalCollatingSequence -5026 Paradox: invalid sort
sequence
JET_errWrongCollatingSequence -5027 Paradox: wrong sort sequence
JET_errCantUseUnkeyedTable -5028 Paradox: can't open unkeyed
table
JET_errNetCtrlMismatch -5029 Paradox: Open with different
.net files
JET_err4xTableWith3xLocking -5030 Paradox: Can't open 4x table
with 3x lock
JET_errINFFileError -5101 dBase: invalid .INF file
JET_errCantMakeINFFile -5102 dBase: can't open .INF file
JET_wrnCantMaintainIndex 5103 dBase: unmaintainable index
JET_errMissingMemoFile -5104 dBase: missing memo file
JET_errIllegalCenturyOption -5105 dBase: Illegal century option
JET_errIllegalDeletedOption -5106 dBase: Illegal deleted option
JET_errIllegalStatsOption -5107 dBase: Illegal statistics
option
JET_errIllegalDateOption -5108 dBase: Illegal date option
JET_errIllegalMarkOption -5109 dBase: Illegal mark option
JET_wrnDuplicateIndexes 5110 dBase: duplicate indexes in
INF file
JET_errINFIndexNotFound -5111 dBase: missing index in INF
file
JET_errWrongMemoFileType -5112 dBase: wrong memo file type
JET_errTooManyLongFields -5200 Btrieve: more than one memo
field
JET_errCantStartBtrieve -5201 Btrieve: wbtrcall.dll missing
JET_errBadConfigParameters -5202 Btrieve: win.ini [btrieve]
options wrong
JET_errIndexesChanged -5203 Btrieve: need to GetIndexInfo
JET_errNonModifiableKey -5204 Btrieve: can't modify record
column
JET_errOutOfBVResources -5205 Btrieve: out of resources
JET_errBtrieveDeadlock -5206 Btrieve: locking deadlock
JET_errBtrieveFailure -5207 Btrieve: Btrieve DLL failure
JET_errBtrieveDDCorrupted -5208 Btrieve: data dictionary
corrupted
JET_errBtrieveTooManyTasks -5209 Btrieve: too many tasks
JET_errIllegalIndexDDFOption -5210 Btrieve: Illegal IndexDDF
option
JET_errIllegalDataCodePage -5211 Btrieve: Illegal DataCodePage
option
JET_errXtrieveEnvironmentError -5212 Btrieve: Xtrieve INI options
bad
JET_errMissingDDFFile -5213 Btrieve: Missing field.ddf
JET_errIllegalIndexNumberOption -5214 Btrieve: Illegal
IndexRenumber option
JET_errFindExprSyntax -8001 Syntax error in FastFind
expression
JET_errQbeExprSyntax -8002 Syntax error in QBE
expression
JET_errInputTableNotFound -8003 Non-existant object in FROM
list
JET_errQueryExprSyntax -8004 Syntax error in some query
expression
JET_errQodefExprSyntax -8005 Syntax error in expression
column
JET_errExpAliasAfterAS -8006 Expected alias after 'AS' in
FROM list
JET_errExpBYAfterGROUP -8007 Expected 'BY' after 'GROUP'
JET_errExpBYAfterORDER -8008 Expected 'BY' after 'ORDER'
JET_errExpClsParenAfterColList -8009 Expected ')' after column
list
JET_errExpColNameAfterPIVOT -8010 Expected column name after
'PIVOT'
JET_errExpDatabaseAfterIN -8011 Expected database name after
'IN'
JET_errExpDatatypeAfterParmName -8012 Expected datatype after
parameter name
JET_errExpEqualAfterUpdColName -8013 Expected '=' after update
column name
JET_errExpExprAfterON -8014 Expected join expression
after 'ON'
JET_errExpExprAfterTRANSFORM -8015 Expected expression after
'TRANSFORM'
JET_errExpExprAfterWHERE -8016 Expected expression after
'WHERE'
JET_errExpGroupClauseInXform -8017 Transform expects GROUP BY
clause
JET_errExpGroupingExpr -8018 Expected grouping expression
JET_errExpHavingExpr -8019 Expected HAVING expression
JET_errExpINTOAfterINSERT -8020 Expected 'INTO' after
'INSERT'
JET_errExpJOINAfterJoinType -8021 Expected 'JOIN' after
INNER/LEFT/RIGHT
JET_errExpLEVELAfterSelectList -8022 Expected LEVEL after select
list
JET_errExpNumberAfterLEVEL -8023 Expected number after 'LEVEL'
JET_errExpONAfterRightTable -8024 Expected 'ON' after right
join table
JET_errExpOrderExpr -8025 Expected ordering expression
JET_errExpOutputAliasAfterAS -8026 Expected output alias after
'AS'
JET_errExpOutputExpr -8027 Expected output expression
JET_errExpPIVOTAfterSelectStmt -8028 Expected 'PIVOT' after SELECT
statement
JET_errExpRightJoinTable -8029 Expected right join table
after 'JOIN'
JET_errExpSELECTAfterInsClause -8030 Expected 'SELECT' after
INSERT clause
JET_errExpSELECTAfterXformExpr -8031 Expected 'SELECT' after
Transform fact
JET_errExpSETAfterTableName -8032 Expected 'SET' after table
name
JET_errExpSemiAfterLevelNumber -8033 Expected ';' after level
number
JET_errExpSemiAfterParmList -8034 Expected ';' after parmeter
list
JET_errExpSemiAfterPivotClause -8035 Expected ';' after PIVOT
clause
JET_errExpSemiAtEndOfSQL -8036 Expected ';' at end of SQL
statement
JET_errExpTableName -8037 Expected table name
JET_errExpTableNameAfterINTO -8038 Expected table name after
'INTO'
JET_errExpUpdExprAfterEqual -8039 Expected update expression
after '='
JET_errExpUpdateColName -8040 Expected update column name
JET_errInvTokenAfterFromList -8041 Bogus token after FROM list
JET_errInvTokenAfterGroupList -8042 Bogus token after GROUP BY
list
JET_errInvTokenAfterHavingCls -8043 Bogus token after HAVING
clause
JET_errInvTokenAfterOrderClause -8044 Bogus token after ORDER BY
clause
JET_errInvTokenAfterSelectCls -8045 Bogus token after SELECT
clause
JET_errInvTokenAfterWhereClause -8046 Bogus token after WHERE
clause
JET_errLevelNumberTooBig -8047 Number after 'LEVEL' too big
JET_errLevelOnNonMGB -8048 LEVEL allowed only in MGB
JET_errIllegalDetailReference -8049 Not group key or agg, but not
MGB detail
JET_errAggOverMixedLevels -8050 Agg. arg. uses outputs from >
1 level
JET_errAggregatingHigherLevel -8051 Agg. over output of
same/higher level
JET_errNullInJoinKey -8052 Cannot set column in join key
to NULL
JET_errValueBreaksJoin -8053 Join is broken by column
value(s)
JET_errInsertIntoUnknownColumn -8054 INSERT INTO unknown column
name
JET_errNoSelectIntoColumnName -8055 No dest. col. name in SELECT
INTO stmt
JET_errNoInsertColumnNameM -8056 No dest. col. name in INSERT
stmt
JET_errColumnNotInJoinTable -8057 Join expr refers to non-join
table
JET_errAggregateInJoin -8058 Aggregate in JOIN clause
JET_errAggregateInWhere -8059 Aggregate in WHERE clause
JET_errAggregateInOrderBy -8060 Aggregate in ORDER BY clause
JET_errAggregateInGroupBy -8061 Aggregate in GROUP BY clause
JET_errAggregateInArgument -8062 Aggregate in argument
expression
JET_errHavingOnTransform -8063 HAVING clause on TRANSFORM
query
JET_errHavingWithoutGrouping -8064 HAVING clause w/o
grouping/aggregation
JET_errHavingOnMGB -8065 HAVING clause on MGB query
JET_errOutputAliasCycle -8066 Cycle in SELECT list (via
aliases)
JET_errDotStarWithGrouping -8067 'T.*' with grouping, but not
MGB level 0
JET_errStarWithGrouping -8068 '*' with grouping, but not
MGB detail
JET_errQueryTreeCycle -8069 Cycle in tree of query
objects
JET_errTableRepeatInFromList -8072 Table appears twice in FROM
list
JET_errTooManyXformLevels -8073 Level > 2 in TRANSFORM query
JET_errTooManyMGBLevels -8074 Too many levels in MGB
JET_errNoUpdateColumnName -8075 No dest. column name in
UPDATE stmt
JET_errJoinTableNotInput -8076 Join table not in FROM list
JET_errUnaliasedSelfJoin -8077 Join tables have same name
JET_errOutputLevelTooBig -8078 Output w/ level > 1+max group
level
JET_errOrderVsGroup -8079 ORDER BY conflicts with GROUP
BY
JET_errOrderVsDistinct -8080 ORDER BY conflicts with
DISTINCT
JET_errExpLeftParenthesis -8082 Expected '('
JET_errExpRightParenthesis -8083 Expected ')'
JET_errEvalEBESErr -8084 EB/ES error evaluating
expression
JET_errQueryExpCloseQuote -8085 Unmatched quote for database
name
JET_errQueryParmNotDatabase -8086 Parameter type should be
database
JET_errQueryParmNotTableid -8087 Parameter type should be
tableid
JET_errExpIdentifierM -8088 Expected identifier
JET_errExpQueryName -8089 Expected query name after
PROCEDURE
JET_errExprUnknownFunctionM -8090 Unknown function in
expression
JET_errQueryAmbigRefM -8091 Ambiguous column reference
JET_errQueryBadBracketing -8092 Bad bracketing of identifier
JET_errQueryBadQodefName -8093 Invalid name in QODEF row
JET_errQueryBulkColNotUpd -8094 Column not updatable (bulk
op)
JET_errQueryDistinctNotAllowedM -8095 DISTINCT not allowed for MGB
JET_errQueryDuplicateAliasM -8096 Duplicate output alias
JET_errQueryDuplicateOutputM -8097 Duplicate destination output
JET_errQueryDuplicatedFixedSetM -8098 Duplicated Fixed Value
JET_errQueryIllegalOuterJoinM -8099 No inconsistent updates on
outer joins
JET_errQueryIncompleteRowM -8100 Missing value in row
JET_errQueryInvalidAttributeM -8101 Invalid query attribute
JET_errQueryInvalidBulkInputM -8102 Cannot input from bulk
operation
JET_errQueryInvalidFlagM -8103 Invalid value in Flag field
JET_errQueryInvalidMGBInputM -8104 Cannot input from MGB
JET_errQueryLVInAggregate -8105 Illegal long value in
aggregate
JET_errQueryLVInDistinct -8106 Illegal long value in
DISTINCT
JET_errQueryLVInGroupBy -8107 Illegal long value in GROUP
BY
JET_errQueryLVInHaving -8108 Illegal long value in HAVING
JET_errQueryLVInJoin -8109 Illegal long value in JOIN
JET_errQueryLVInOrderBy -8110 Illegal long value in ORDER
BY
JET_errQueryMissingLevelM -8111 Missing intermediate MGB
level
JET_errQueryMissingParmsM -8112 Too few parameters supplied
JET_errQueryNoDbForParmDestTblM -8113 Dest DB for VT parm not
allowed
JET_errQueryNoDeletePerm -8114 No delete permission on
table/query
JET_errQueryNoInputTablesM -8115 Query must have an input
JET_errQueryNoInsertPerm -8116 No insert permission on
table/query
JET_errQueryNoOutputsM -8117 Query must have an output
JET_errQueryNoReadDefPerm -8118 No permission to read query
definition
JET_errQueryNoReadPerm -8119 No read permission on
table/query
JET_errQueryNoReplacePerm -8120 No replace permission on
table/query
JET_errQueryNoTblCrtPerm -8121 No CreateTable permission
(bulk op)
JET_errQueryNotDirectChildM -8122 T.* must use direct child
JET_errQueryNullRequiredM -8123 Column must be NULL
JET_errQueryOnlyOneRowM -8124 Only 1 such row allowed
JET_errQueryOutputColNotUpd -8125 Query output column not
updatable
JET_errQueryParmRedefM -8126 Parm redefined with different
type
JET_errQueryParmTypeMismatchM -8127 Wrong parameter type given
JET_errQueryUnboundRefM -8128 Cannot bind name
JET_errRmtConnectFailedM -8129 RMT: Connection attempt
failed
JET_errRmtDeleteFailedM -8130 RMT: Delete statement failed
JET_errRmtInsertFailedM -8131 RMT: Insert statement failed
JET_errRmtMissingOdbcDllM -8132 RMT: Can't load ODBC DLL
JET_errRmtSqlErrorM -8133 RMT: ODBC call failed
JET_errRmtUpdateFailedM -8134 RMT: Update statement failed
JET_errSQLDeleteSyntaxM -8135 Expected 'FROM' after
'DELETE'
JET_errSQLSyntaxM -8136 Bogus SQL statement type
JET_errSQLTooManyTokensM -8137 Characters after end of SQL
statement
JET_errStarNotAtLevel0 -8138 '*' illegal above level 0
JET_errQueryParmTypeNotAllowed -8139 Parameter type not allowed
for expression
JET_errRmtLinkNotFound -8144 RMT: link not found
JET_errRmtTooManyColumns -8145 RMT: Too many columns on
Select Into
JET_errWriteConflictM -8146 Write lock failed due to
outstanding write lock
JET_errReadConflictM -8147 Commit lock failed due to
outstanding read lock
JET_errCommitConflictM -8148 Read lock failed due to
outstanding commit lock
JET_errTableLockedM -8149 Table is exclusively locked
JET_errTableInUseM -8150 Table is in use, cannot lock
JET_errQueryTooManyXvtColumn -8151 Too many cross table column
headers
JET_errOutputTableNotFound -8152 Non-existent table in Insert
Into
JET_errTableLockedQM -8153 Table is exclusively locked
JET_errTableInUseQM -8154 Table is in use, cannot lock
JET_errTableLockedMUQM -8155 Table is exclusively locked
JET_errTableInUseMUQM -8156 Table is in use, cannot lock
JET_errQueryInvalidParmM -8157 Invalid Parmeter Name (>64
char)
JET_errFileNotFoundM -8158 File not found
JET_errFileShareViolationM -8159 File sharing violation
JET_errFileAccessDeniedM -8160 Access denied
JET_errInvalidPathM -8161 Invalid Path
JET_errTableDuplicateM -8162 Table already exists
JET_errQueryBadUpwardRefedM -8163 Illegally Upward ref'ed
JET_errIntegrityViolMasterM -8164 References to key exist
JET_errIntegrityViolSlaveM -8165 No referenced key exists
JET_errSQLUnexpectedWithM -8166 Unexpected 'with' in this
place
JET_errSQLOwnerAccessM -8167 Owner Access Option is
defined Twice
JET_errSQLOwnerAccessSyntaxM -8168 Owner Access Option Syntax
Error
JET_errSQLOwnerAccessDef -8169 Owner Access Option is
defined more than once
JET_errAccessDeniedM -8170 Generic Access Denied
JET_errUnexpectedEngineReturnM -8171 I-ISAM: unexpected engine
error code
JET_errQueryTopNotAllowedM -8172 query cannot contain Top N
JET_errInvTokenAfterTableCls -8173 Bogus token after table
clause
JET_errInvTokenAfterRParen -8174 Unexpected tokens after a
closing paren
JET_errQueryBadValueListM -8175 Malformed value list in
Transform
JET_errQueryIsCorruptM -8176 Query is Corrupted
JET_errInvalidTopArgumentM -8177 Select Top argument is
invalid
JET_errQueryIsSnapshot -8178 Query is a snapshot
JET_errQueryExprOutput -8179 Output is a calculated column
JET_errQueryTableRO -8180 Column comes from read-only
table
JET_errQueryRowDeleted -8181 Column comes from deleted row
JET_errQueryRowLocked -8182 Column comes from locked row
JET_errQueryFixupChanged -8183 Would row-fixup away from
pending changes
JET_errQueryCantFillIn -8184 Fill-in-the-blank only on
most-many
JET_errQueryWouldOrphan -8185 Would orphan joined records
JET_errIncorrectJoinKeyM -8186 Must match join key in lookup
table
JET_errQueryLVInSubqueryM -8187 Illegal long value in
subquery
JET_errInvalidDatabaseM -8188 Unrecognized database format
JET_errOrderVsUnion -8189 You can only order by an
outputted column in a union
JET_errTLVCouldNotBindRef -8190 Unknown token in TLV
expression
JET_errCouldNotBindRef -8191 Unknown token in FastFind
expression
JET_errQueryPKeyNotOutput -8192 Primary key not output
JET_errQueryJKeyNotOutput -8193 Join key not output
JET_errExclusiveDBConflict -8194 Conflict with exclusive user
JET_errQueryNoJoinedRecord -8195 No F.I.T.B. insert if no
joined record
JET_errQueryLVInSetOp -8196 Illegal long value in set
operation
JET_errTLVExprUnknownFunctionM -8197 Unknown function in TLV
expression
JET_errInvalidNameM -8198 Invalid name
JET_errExpValue -8200 Expected value in VALUES list
JET_errDDLExpColName -8201 expect column name
JET_errDDLExpLP -8202 expect '('
JET_errDDLExpRP -8203 expect ')'
JET_errDDLExpIndex -8204 expect INDEX
JET_errDDLExpIndexName -8205 expect index name
JET_errDDLExpOn -8206 expect ON
JET_errDDLExpKey -8207 expect KEY
JET_errDDLExpReferences -8208 expect REFERENCES
JET_errDDLExpTableName -8209 expect table name
JET_errDDLExpNull -8210 expect NULL
JET_errDDLExpConstraintName -8211 expect constraint name
JET_errDDLExpDatatype -8212 expect data type
JET_errDDLExpTable -8213 expect TABLE
JET_errDDLExpEos -8214 expect End Of String
JET_errDDLExpAddOrDrop -8215 expect ADD or DROP
JET_errDDLExpColOrConstr -8216 expect COLUMN or CONSTRAINT
JET_errDDLExpTableOrIndex -8217 expect TABLE or INDEX
JET_errDDLExpNumber -8218 expect a number
JET_errDDLExpConstr -8219 expect a constraint
JET_errDDLPermissionDenied -8220 DDL on read-only database
JET_errDDLObjectNotFound -8221 table/constraint not found
JET_errDDLIndexNotFound -8222 no such index
JET_errDDLNoPkeyOnRefdTable -8223 no primary key on referenced
table
JET_errDDLColumnsNotUnique -8224 no unique key on referenced
columns
JET_errDDLIndexDuplicate -8225 index already exists
JET_errDDLTableNotFound -8226 no such table
JET_errDDLRelNotFound -8227 no such relationship
JET_errDDLRelDuplicate -8228 relationship already exists
JET_errDDLIntegrityViolation -8229 existing data violates new
relationship
JET_errDDLColumnDuplicate -8230 column already exists
JET_errDDLColumnNotFound -8231 no such column
JET_errDDLColumnTooBig -8232 column length too long
JET_errDDLColumnInRel -8233 cannot drop column, in
relationship
JET_errRelNoPrimaryIndexM -8234 No primary index on
referenced table
JET_errInvalidColumnM -8235 Invalid column in index or
reference definition
JET_errV11TableNameNotInScope -8250 referenced table not in join
clause
JET_errV11OnlyTwoTables -8251 exactly two tables should be
referenced in join
JET_errV11OneSided -8252 all tables come from one side
of input
JET_errV11Ambiguous -8253 Join clause is ambiguous when
stored in V1 format
JET_errTLVExprSyntaxM -8260 Syntax error in TLV
expression
JET_errTLVNoNullM -8261 This field cannot be null
JET_errTLVNoBlankM -8262 This column cannot be blank
JET_errTLVRuleViolationM -8263 This validation rule must be
met
JET_errRIViolationMasterCM -8264 references to key exist while
doing a cascade RI action
JET_errRIViolationSlaveCM -8265 no referenced key exist while
doing a cascade RI action
JET_errRIKeyNullDisallowedCM -8266 null value as a result of a
cascade RI action
JET_errRIKeyDuplicateCM -8267 duplicate key as a result of
a cascade RI action
JET_errRIUpdateTwiceCM -8268 tried to update some field in
a record twice
JET_errRITLVNoNullCM -8269 This field cannot be null
JET_errRITLVNoBlankCM -8270 This column cannot be blank
JET_errRITLVRuleViolationCM -8271 This validation rule must be
met
JET_errRIInvalidBufferSizeCM -8272 data size exceeds the column
size as a result of a cascade
action
JET_errRIWriteConflictCM -8273 write conflict due to
cascading
JET_errRISessWriteConflictCM -8274 session write conflict due to
cascading
JET_errREPReadOnly -20000 can't open this for update
JET_errREPSetRepid -20001 users can't change the rep ID
JET_errREPDBNotRep -20002 database not replicable
JET_errREPDBNotMaster -20003 database not master
JET_errREPSecondGuid -20004 don't put second guid on
table
JET_errREPOnlyBuiltin -20005 Can't make non-builtin
replicable
JET_errREPNotOwner -20006 Only owner can make DB
replicable
JET_errREPCantRelate -20007 Can't relate repl. and local
table
For more information on reserved errors in version 1.1, please see the
following article in the Microsoft Knowledge Base:
Q113496 ACC1x: Complete Reserved Error List for Microsoft Access 1.1
Additional query words: errlist kblist gpf reserve
Keywords : kberrmsg kbprg PgmErr
Version : 2.0
Platform : WINDOWS
Issue type : kbinfo Last Reviewed: April 3, 1999