ACC1x: Complete Reserved Error List for Microsoft Access 1.1

ID: Q113496


The information in this article applies to:


SUMMARY

This article lists all the reserved error codes for Microsoft Access version 1.1. These error codes are subject to change without notice when Microsoft Access is upgraded.


MORE INFORMATION

If you encounter a Reserved Error message, check the Microsoft Knowledge Base for specific error numbers, since there may be an article with information about that error code. If you don't 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.


  0     Successful Operation
 -1     Function Not Yet Implemented
 -100   JET_errRfsFailure
 -101   JET_errRfsFailure
 -1001  API not supported
 -1002  Invalid name
 -1003  Invalid API parameter
 -1004  Column is NULL-valued
 -1005  No such reference
 -1006  Buf too short, data truncated
 -1007  Database is already attached
 -1008  On end point
 -1009  Sort does not fit in memory
 -1010  Invalid database id
 -1011  Out of Memory
 -1012  Couldn't allocate a page
 -1013  Max # of cursors allocated
 -1014  JET_errOutOfBuffers
 -1015  Too many indexes
 -1016  Too many columns in an index
 -1017  Record has been deleted
 -1018  Read verification error
 -1019  Obsolete database format
 -1020  No more file handles
 -1021  Disk not ready
 -1022  JET_errDiskIO
 -1023  JET_errInvalidPath
 -1024  JET_errFileShareViolation
 -1025  JET_errFileLockViolation
 -1026  JET_errRecordTooBig
 -1027  Database limit reached
 -1028  This isn't a database
 -1029  JetInit not yet called
 -1030  JetInit already called
 -1031  JET_errFileLockingUnavailable
 -1032  JET_errFileAccessDenied
 -1033  OS sharing buffer exceeded
 -1034  Query support unavailable
 -1035  SQL Link support unavailable
 -1036  Too many client tasks
 -1037  Unsupported OS version
 -1038  Buffer is too small
 -1039  SeekLE or SeekGE didn't find exact match
 -1040  Too many columns defined
 -1041  Too many fixed columns defined
 -1042  Too many variable columns defined
 -1043  Container is not empty
 -1044  Filename is invalid
 -1045  Invalid bookmark
 -1046  Column used in an index
 -1047  Data buffer doesn't match column size
 -1048  Can't set column value
 -1049  Commit did not flush to disk
 -1050  Forced Salvager abort
 -1051  Index is in use
 -1052  Link support unavailable
 -1053  Null keys are disallowed on index
 -1054  JET_errNotInTransaction
 -1055  No extended error information
 -1056  Installable ISAM not found
 -1057  Operation canceled by client
 -1058  No idle activity occurred
 -1059  Too many active database users
 -1060  Cannot append long value
 -1061  Invalid or unknown country code
 -1062  Invalid or unknown language id
 -1063  Invalid or unknown code page
 -1064  Can't build key for this sort order.
 -1065  Re-entrancy on same cursor family

 -1101  Cannot BeginSession
 -1102  Write lock failed due to outstanding write lock
 -1103  Xactions nested too deeply
 -1104  Invalid session handle
 -1105  Commit lock failed due to outstanding read lock
 -1106  Read lock failed due to outstanding commit lock
 -1107  Another session has private version of page
 -1108  Operation not allowed within a transaction
 -1109  User is not quiescer
 -1110  System quiescing state
 -1111  Resuming without quiesced
 -1112  System already quiescing
 -1113  Too many active sessions

 -1201  Database already exists
 -1202  Database in use, can't detach
 -1203  No such database
 -1204  Invalid database name
 -1205  Invalid number of pages
 -1206  non-db file or corrupted db
 -1207  Database exclusively locked
 -1208  Database is encrypted

 -1301  Open an empty table
 -1302  Table is exclusively locked
 -1303  Table already exists
 -1304  Table is in use, cannot lock
 -1305  No such table or object
 -1306  Cannot rename temporary file
 -1307  Bad file/index density
 -1308  Cannot define primary
 -1309  No DDLs w/o exclusive lock
 -1310  Invalid table id
 -1311  Cannot open any more tables
 -1312  Oper. not supported on table
 -1313  Query Execution segment is released
 -1314  Table or object name in use

 -1401  Cannot build primary index
 -1402  Primary index already defined
 -1403  Index is already defined
 -1404  No such index
 -1405  Cannot delete primary index
 -1406  Illegal index definition
 -1407  Referencing/Referenced index is the same

 -1501  column value is long
 -1502  no such chunk in field
 -1503  Field will not fit in record
 -1504  Null not valid
 -1505  Column indexed, cannot delete
 -1506  Field length is > maximum
 -1507  No such column
 -1508  Field is already defined
 -1509  No defaults on tagged fields
 -1510  Second autoinc or version column
 -1511  Invalid column data type
 -1512  Max length too big, truncated
 -1513  Cannot index Bit,LongText,LongBinary
 -1514  No non-NULL tagged fields
 -1515  Invalid w/o a current index
 -1516  The key is completely made
 -1517  Column Id Incorrect

 -1601  The key was not found
 -1602  No working buffer
 -1603  Currency not on a record
 -1604  Primary key may not change
 -1605  Illegal duplicate key
 -1606  Cannot insert before current
 -1607  Already copy/clear current
 -1608  No call to JetMakeKey
 -1609  No call to JetPrepareUpdate
 -1610  Data has changed
 -1611  Data has changed; operation aborted
 -1613  No referenced key exists
 -1698  JET_errRedoPrepUpdate CONSIDER: QJET INTERNAL(jpbulk.c)
 -1699  JET_wrnSyncedToDelRec CONSIDER: QJET INTERNAL

 -1701  Too many sort processes
 -1702  Invalid operation on Sort

 -1801  Config. file can't be opened
 -1802  System db could not be opened
 -1803  Temp file could not be opened
 -1804  Database file can't be opened
 -1806  Db file could not be closed
 -1807  Too many files open
 -1808  No space left on disk
 -1809  Permission denied
 -1810  Could not open sort file
 -1811  File not found
 -1812  No space left on disk

 -1850  Cannot Restore after init.
 -1851  New log generation id too big
 -1852  Logs could not be interpreted

 -1901  failed sysdb on beginsession
 -1902  invalid logon at beginsession
 -1903  invalid account name
 -1904  invalid SID
 -1905  invalid password
 -1906  invalid operation
 -1907  access denied
 -1908  Can't open MSysAccounts
 -1909  Can't open MSysGroups

 -2001  RMT: ODBC call failed
 -2006  RMT: Can't load ODBC DLL
 -2007  RMT: Insert statement failed
 -2008  RMT: Delete statement failed
 -2009  RMT: Update statement failed
 -2010  RMT: data truncated
 -2011  RMT: Can't create JET type on server
 -2012  RMT: Create table stmt failed
 -2014  RMT: Function not legal for rdb
 -2020  RMT: Data value out of range
 -2021  RMT INTERNAL: SQL_STILL_EXECUTING
 -2022  RMT: Server Not Responding
 -2023  RMT: Internal only - need Lv data
 -2024  Fat cursor has no effect **
 -2025  RMT: INTERNAL: wrong SProc ver **
 -2026  RMT: the def for the rmt tbl has changed
 -2027  RMT: Can't open DenyWrite
 -2029  RMT: INTERNAL: driver cannot convert
 -2030  RMT: Table ambiguous: must specifier owner

 -3001  Invalid query attribute
 -3002  Only 1 such row allowed
 -3003  Missing value in row
 -3004  Invalid value in Flag field
 -3005  Cycle in query definition
 -3006  Invalid table in join
 -3007  Ambiguous column reference
 -3008  Cannot bind name
 -3009  Parm redefined with different type
 -3010  Too few parameters supplied
 -3011  Invalid query output
 -3012  HAVING clause without aggregation
 -3013  Duplicate output alias
 -3014  Cannot input from MGB
 -3015  Invalid ORDER BY expression
 -3016  Too many levels on MGB
 -3017  Missing intermediate MGB level
 -3018  Aggregates not allowed
 -3019  Duplicate destination output
 -3020  Grbit should be set for Bulk Operation
 -3021  Query is not a Bulk Operation
 -3022  No inconsistent updates on outer joins
 -3023  Column must be NULL
 -3024  Query must have an output
 -3025  Query must have an input
 -3026  Query is not updatable (but IS RVT)
 -3027  Bogus character in alias name
 -3028  Cannot input from bulk operation
 -3029  T.* must use direct child
 -3030  Expression evaluation error
 -3031  Query is not row returning (VtObject only)
 -3032  Can't create RVT, query is static
 -3033  Wrong parameter type given
 -3034  Query Objects are being updated
 -3035  Operation must use an updatable query
 -3036  Missing destination column
 -3037  Repeated table name in FROM list
 -3038  Query is an MGB
 -3039  Cannot insert into Bulk/MGB
 -3040  DISTINCT not allowed for MGB
 -3045  Dest DB for VT parm not allowed
 -3047  Duplicated Fixed Value
 -3048  Must specify tables to delete from
 -3049  Cannot delete from specified tables
 -3050  Too many GROUP BY expressions
 -3051  Too many ORDER BY expressions
 -3052  Too many DISTINCT output expressions
 -3053  Malformed value list in Transform
 -3054  Connect string too long
 -3055  Invalid Parmeter Name (>64 char)
 -3056  Can't get parameters with Db Parm
 -3057  Illegally Upward ref'ed
 -3058  Joins in a QO are ambiguous
 -3059  Not a DDL Operation
 -3060  No database in connect string

 -3100  Syntax error in expression
 -3101  Illegal type in expression
 -3102  Unknown function in expression

 -3500  Bogus SQL statement type
 -3501  Parameter clause syntax error
 -3502  INSERT clause syntax error
 -3503  UPDATE clause syntax error
 -3504  SELECT clause syntax error
 -3505  Expected 'FROM' after 'DELETE'
 -3506  FROM clause syntax error
 -3507  GROUP BY clause syntax error
 -3508  ORDER BY clause syntax error
 -3509  LEVEL syntax error
 -3510  JOIN syntax error
 -3511  TRANSFORM syntax error
 -3512  HAVING clause syntax error
 -3513  WHERE clause syntax error
 -3514  Expected query name after 'PROCEDURE'
 -3515  Buffer too small for SQL string
 -3516  Missing ; at end of SQL statement
 -3517  Characters after end of SQL statement
 -3519  not supported in V11
 -3520  can be present in V10 format only
 -3550  constraint syntax error
 -3551  create table syntax error
 -3552  create index syntax error
 -3553  column def syntax error
 -3554  alter table syntax error
 -3555  drop index syntax error
 -3556  drop index syntax error
 -3557  index is created for Unique/Primary constraint

 -3600  Cursor wrapped during fast find

 -5001  I-ISAM: assert failure
 -5002  I-ISAM: record locked
  5003  I-ISAM: data truncated
 -5004  I-ISAM: table is not open
 -5005  I-ISAM: incorrect password
 -5007  I-ISAM: currency lost - must first/last
 -5008  I-ISAM: invalid date
 -5011  I-ISAM: options were ignored
 -5012  I-ISAM: incomplete table definition
 -5013  I-ISAM: illegal network option
 -5014  I-ISAM: illegal timeout option
 -5015  I-ISAM: invalid file format
 -5016  I-ISAM: unexpected engine error code

 -5020  Paradox: no primary index
 -5021  Paradox: sort order mismatch
 -5023  Paradox: net path or user name missing
 -5024  Paradox: bad Paradox net path
 -5025  Paradox: obsolete lock file
 -5027  Paradox: wrong sort sequence
 -5028  Paradox: can't open unkeyed table

 -5101  dBASE: invalid .INF file
 -5102  dBASE: can't open .INF file
 -5103  dBASE: unmaintainable index
 -5104  dBASE: missing memo file
 -5105  dBASE: Illegal century option
 -5106  dBASE: Illegal deleted option
 -5107  dBASE: Illegal statistics option
 -5108  dBASE: Illegal date option
 -5109  dBASE: Illegal mark option
 -5110  dBASE: duplicate indexes in INF file
 -5111  dBASE: missing index in INF file
 -5112  dBASE: wrong memo file type

 -5200  Btrieve: more than one memo field
 -5201  Btrieve: wbtrcall.dll missing
 -5202  Btrieve: WIN.INI [btrieve] options wrong
 -5203  Btrieve: need to GetIndexInfo
 -5204  Btrieve: can't modify record column
 -5205  Btrieve: out of resources
 -5206  Btrieve: locking deadlock
 -5207  Btrieve: Btrieve DLL failure
 -5208  Btrieve: data dictionary corrupted
 -5209  Btrieve: too many tasks 

Extended error codes must be in the following range. Major error codes may not be in this range.

 -8000  JET_errMinorLeast
 -8999  JET_errMinorMost

 -8001  Syntax error in FastFind expression
 -8002  Syntax error in QBE expression
 -8003  Non-existant object in FROM list
 -8004  Syntax error in some query expression
 -8005  Syntax error in expression column
 -8006  Expected alias after 'AS' in FROM list
 -8007  Expected 'BY' after 'GROUP'
 -8008  Expected 'BY' after 'ORDER'
 -8009  Expected ')' after column list
 -8010  Expected column name after 'PIVOT'
 -8011  Expected database name after 'IN'
 -8013  Expected '=' after update column name
 -8014  Expected join expression after 'ON'
 -8015  Expected expression after 'TRANSFORM'
 -8016  Expected expression after 'WHERE'
 -8017  Transform expects GROUP BY clause
 -8018  Expected grouping expression
 -8019  Expected HAVING expression
 -8020  Expected 'INTO' after 'INSERT'
 -8021  Expected 'JOIN' after INNER/LEFT/RIGHT
 -8022  Expected LEVEL after select list
 -8023  Expected number after 'LEVEL'
 -8024  Expected 'ON' after right join table
 -8025  Expected ordering expression
 -8026  Expected output alias after 'AS'
 -8027  Expected output expression
 -8028  Expected 'PIVOT' after SELECT statement
 -8029  Expected right join table after 'JOIN'
 -8030  Expected 'SELECT' after INSERT clause
 -8031  Expected 'SELECT' after Transform fact
 -8032  Expected 'SET' after table name
 -8033  Expected ';' after level number
 -8034  Expected ';' after parmeter list
 -8035  Expected ';' after PIVOT clause
 -8036  Expected ';' at end of SQL statement
 -8037  Expected table name
 -8038  Expected table name after 'INTO'
 -8039  Expected update expression after '='
 -8040  Expected update column name
 -8041  Bogus token after FROM list
 -8042  Bogus token after GROUP BY list
 -8043  Bogus token after HAVING clause
 -8045  Bogus token after SELECT clause
 -8047  Number after 'LEVEL' too big
 -8048  LEVEL allowed only in MGB
 -8049  Not group key or agg, but not MGB detail
 -8050  Agg. arg. uses outputs from > 1 level
 -8051  Agg. over output of same/higher level
 -8052  Cannot set column in join key to NULL
 -8053  Join is broken by column value(s)
 -8054  INSERT INTO unknown column name
 -8055  No dest. col. name in SELECT INTO stmt
 -8056  No dest. col. name in INSERT stmt
 -8057  Join expr refers to non-join table
 -8058  Aggregate in JOIN clause
 -8059  Aggregate in WHERE clause
 -8060  Aggregate in ORDER BY clause
 -8061  Aggregate in GROUP BY clause
 -8062  Aggregate in argument expression
 -8063  HAVING clause on TRANSFORM query
 -8064  HAVING clause w/o grouping/aggregation
 -8065  HAVING clause on MGB query
 -8066  Cycle in SELECT list (via aliases)
 -8067  'T.*' with grouping, but not MGB level 0
 -8068  '*' with grouping, but not MGB detail
 -8069  Cycle in tree of query objects
 -8072  Table appears twice in FROM list
 -8073  Level > 2 in TRANSFORM query
 -8074  Too many levels in MGB
 -8075  No dest. column name in UPDATE stmt
 -8076  Join table not in FROM list
 -8077  Join tables have same name
 -8078  Output w/ level > 1+max group level
 -8079  ORDER BY conflicts with GROUP BY
 -8080  ORDER BY conflicts with DISTINCT
 -8082  Expected '('
 -8083  Expected ')'
 -8084  EB/ES error evaluating expression
 -8085  Unmatched quote for database name
 -8086  Parameter type should be database
 -8087  Parameter type should be tableid
 -8088  Expected identifier
 -8089  Expected query name after PROCEDURE
 -8090  Unknown function in expression
 -8091  Ambiguous column reference
 -8092  Bad bracketing of identifier
 -8093  Invalid name in QODEF row
 -8094  Column not updatable (bulk op)
 -8095  DISTINCT not allowed for MGB
 -8096  Duplicate output alias
 -8097  Duplicate destination output
 -8098  Duplicated Fixed Value
 -8099  No inconsistent updates on outer joins
 -8100  Missing value in row
 -8101  Invalid query attribute
 -8102  Cannot input from bulk operation
 -8103  Invalid value in Flag field
 -8104  Cannot input from MGB
 -8105  Illegal long value in aggregate
 -8106  Illegal long value in DISTINCT
 -8107  Illegal long value in GROUP BY
 -8108  Illegal long value in HAVING
 -8109  Illegal long value in JOIN
 -8110  Illegal long value in ORDER BY
 -8111  Missing intermediate MGB level
 -8112  Too few parameters supplied
 -8113  Dest DB for VT parm not allowed
 -8114  No delete permission on table/query
 -8115  Query must have an input
 -8116  No insert permission on table/query
 -8117  Query must have an output
 -8118  No permission to read query definition
 -8119  No read permission on table/query
 -8120  No replace permission on table/query
 -8121  No CreateTable permission (bulk op)
 -8122  T.* must use direct child
 -8123  Column must be NULL
 -8124  Only 1 such row allowed
 -8125  Query output column not updatable
 -8126  Parm redefined with different type
 -8127  Wrong parameter type given
 -8128  Cannot bind name
 -8129  RMT: Connection attempt failed
 -8130  RMT: Delete statement failed
 -8131  RMT: Insert statement failed
 -8132  RMT: Can't load ODBC DLL
 -8133  RMT: ODBC call failed
 -8134  RMT: Update statement failed
 -8135  Expected 'FROM' after 'DELETE'
 -8136  Bogus SQL statement type
 -8137  Characters after end of SQL statement
 -8138  '*' illegal above level 0
 -8139  Parameter type not allowed for expression
 -8142  Too many destination column sepcified
 -8143  No dest. col. name in INSERT stmt
 -8144  RMT: link not found
 -8145  RMT: Too many columns on Select Into
 -8146  Write lock failed due to outstanding write lock
 -8147  Commit lock failed due to outstanding read lock
 -8148  Read lock failed due to outstanding commit lock
 -8149  Table is exclusively locked
 -8150  Table is in use, cannot lock
 -8151  Too many cross table column headers
 -8152  Non-existent table in Insert Into
 -8153  Table is exclusively locked
 -8154  Table is in use, cannot lock
 -8155  Table is exclusively locked
 -8156  Table is in use, cannot lock
 -8157  Invalid Parmeter Name (>64 char)
 -8158  File not found
 -8159  File sharing violation
 -8160  Access denied
 -8161  Invalid Path
 -8162  Table already exists
 -8163  Illegally Upward ref'ed
 -8164  References to key exist
 -8165  No referenced key exists
 -8166  Unexpected 'with' in this place
 -8167  Owner Access Option is defined Twice
 -8169  Owner Access Option is defined more than once
 -8170  Generic Access Denied
 -8171  I-ISAM: unexpected engine error code

 -8200  expect column name
 -8201  expect '('
 -8202  expect ')'
 -8203  expect INDEX
 -8204  expect index name
 -8205  expect ON
 -8206  expect KEY
 -8207  expect REFERENCES
 -8208  expect table name
 -8209  expect FULL or PARTIAL
 -8210  expect CASCADE or SET
 -8211  expect NULL
 -8212  expect UPDATE or DELETE
 -8213  expect constraint name
 -8214  expect FOREIGN
 -8215  expect data type
 -8216  expect index options
 -8217  expect WITH
 -8218  expect TABLE
 -8219  expect End Of String
 -8220  expect ADD or Drop
 -8221  Create view not supported
 -8222  Create proc not supported
 -8223  expect object name
 -8224  expect COLUMN

 -8251  exactly two tables should be referenced in join
 -8252  all tables come from one side of input
 -8253  Join clause is ambiguous when stored in V1 format 

The following error code ranges are reserved for external use:

Additional query words: errlist error codes


Keywords          : kbusage GnlOthr 
Version           : WINDOWS:1.1
Platform          : WINDOWS 
Issue type        : kbinfo 

Last Reviewed: July 13, 1999