Microsoft KB Archive/113496

-

The information in this article applies to:


 * Microsoft Access 1.1

-

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:


 * 30000 through 30999 for use by Vt Object (as defined in JETEB.H).
 * 32000 through 32767 for use by Import/Export (as defined in JETUTIL.H).

Additional query words: errlist error codes

Keywords         : kbusage GnlOthr Version          : WINDOWS:1.1 Platform         : WINDOWS Issue type       : kbinfo Last Reviewed: July 13, 1999