Response Mechanics, Inc. MYM2QIFW        
Welcome What's New FAQ Bugs Suggestions Download Guarantee Get Key Discussion Search

LONG: List of Trappable Errors for VB 3.0

ARTICLE ID: Q108340


The information in this article applies to:

- Standard and Professional Editions of Microsoft Visual Basic for
  Windows, version 3.0

SUMMARY


This article lists error codes and messages for the errors that you can
trap at run time by using the On Error statement and the Err function.
MORE INFORMATION

When running VB.EXE, you can follow these steps to get more information
on a specific error.

1. Stop your program if it is currently running.

2. Press the F8 key to go from design mode to break mode.

3. Press Ctrl+B to activate the debug window.

4. Enter the following statement and wait for the error message to appear:

   Error <error-number>

5. Press the F1 key.

Trappable Errors

   3 Return without GoSub
   5 Illegal function call
   6 Overflow
   7 Out of memory
   9 Subscript out of range
  10 Duplicate definition
  11 Division by zero
  13 Type mismatch
  14 Out of string space
  16 String formula too complex
  17 Can't continue
  19 No Resume
  20 Resume without error
  28 Out of stack space
  35 Sub or Function not defined
  48 Error in loading DLL
  49 Bad DLL calling convention
  51 Internal error
  52 Bad file name or number
  53 File not found
  54 Bad file mode
  55 File already open
  57 Device I/O error
  58 File already exists
  59 Bad record length
  61 Disk full
  62 Input past end of file
  63 Bad record number
  64 Bad file name
  67 Too many files
  68 Device unavailable
  70 Permission denied
  71 Disk not ready
  74 Can't rename with different drive
  75 Path/File access error
  76 Path not found
  91 Object variable not Set
  92 For loop not initialized
  93 Invalid pattern string
  94 Invalid use of Null
  95 Cannot destroy active form instance
 260 No timer available
 280 DDE channel not fully closed; awaiting response from foreign
     application
 281 No More DDE channels
 282 No foreign application responded to a DDE initiate
 283 Multiple applications responded to a DDE initiate
 284 DDE channel locked
 285 Foreign application won't perform DDE method or operation
 286 Timeout while waiting for DDE response
 287 User pressed Escape key during DDE operation
 288 Destination is busy
 289 Data not provided in DDE operation
 290 Data in wrong format
 291 Foreign application quit
 292 DDE conversation closed or changed
 293 DDE Method invoked with no channel open
 294 Invalid DDE Link format
 295 Message queue filled; DDE message lost
 296 PasteLink already performed on this control
 297 Can't set LinkMode; invalid LinkTopic
 298 DDE requires ddeml.dll
 320 Can't use character device names in file names: ' '
 321 Invalid file format
 340 Control array element ' ' doesn't exist
 341 Invalid control array index
 342 Not enough room to allocate control array ' '
 343 Object not an array
 344 Must specify index for object array
 345 Reached limit: cannot create any more controls for this form
 360 Object already loaded
 361 Can't load or unload this object
 362 Can't unload controls created at design time
 363 Custom control ' ' not found
 364 Object was unloaded
 365 Unable to unload within this context
 366 No MDI Form available to load
 380 Invalid property value
 381 Invalid property array index
 382 ' ' property cannot be set at run time
 383 ' ' property is read-only
 384 A form can't be moved or sized while minimized or maximized
 385 Must specify index when using property array
 386 ' ' property not available at run time
 387 ' ' property can't be set on this control
 388 Can't set Visible property from a parent menu
 389 Invalid key
 390 No Defined Value
 391 Name not available
 392 MDI child forms cannot be hidden
 393 ' ' property cannot be read at run time
 394 ' ' property is write-only
 395 Can't use separator bar as menu name
 400 Form already displayed; can't show modally
 401 Can't show non-modal form when modal form is displayed
 402 Must close or hide topmost modal form first
 403 MDI forms cannot be shown modally
 404 MDI child forms cannot be shown modally
 420 Invalid object reference
 421 Method not applicable for this object
 422 Property ' ' not found
 423 Property or control ' ' not found
 424 Object required
 425 Invalid object use
 426 Only one MDI Form allowed
 427 Invalid object type; Menu control required
 428 Popup menu must have at least one submenu
 429 OLE Automation server cannot create object
 430 Class does not support OLE Automation
 431 OLE Automation server cannot load file
 432 OLE Automation file or object name syntax error
 433 OLE Automation object does not exist
 434 Access to OLE Automation object denied
 435 OLE initialization error
 436 OLE Automation method returned unsupported type
 437 OLE Automation method did not return a value
 438 OLE Automation no such property or method
 439 OLE Automation argument type mismatch
 440 OLE Automation error.
 441 Error loading VBOA300.DLL
 442 OLE Automation Lbound or Ubound on non Array value
 443 OLE Automation Object does not have a default value
 444 Method not applicable in this context
 460 Invalid Clipboard format
 461 Specified format doesn't match format of data
 480 Can't create AutoRedraw image
 481 Invalid picture
 482 Printer error
 520 Can't empty Clipboard
 521 Can't open Clipboard
 600 Set value not allowed on collections
 601 Get value not allowed on collections
 602 General ODBC error: ' '
 603 ODBC - SQLAllocEnv failure
 604 ODBC - SQLAllocConnect failure
 605 OpenDatabase - invalid connect string
 606 ODBC - SQLConnect failure ' '
 607 Access attempted on unopened DataBase
 608 ODBC - SQLFreeConnect error
 609 ODBC - GetDriverFunctions failure
 610 ODBC - SQLAllocStmt failure
 611 ODBC - SQLTables (TableDefs.Refresh) failure: ' '
 612 ODBC - SQLBindCol failure
 613 ODBC - SQLFetch failure: ' '
 614 ODBC - SQLColumns (Fields.Refresh) failure: ' '
 615 ODBC - SQLStatistics (Indexes.Refresh) failure: ' '
 616 Table exists - append not allowed
 617 No fields defined - cannot append table
 618 ODBC - SQLNumResultCols (CreateDynaset) failure: ' '
 619 ODBC - SQLDescibeCol (CreateDynaset) failure: ' '
 620 Dynaset is open - CreateDynaset method not allowed
 621 Row-returning SQL is illegal in ExecuteSQL method
 622 CommitTrans/Rollback illegal - Transactions not support
 623 Name not found in this collection
 624 Unable to Build Data Type Table
 625 Data type of field ' ' not supported by target database
 626 Attempt to Move past EOF
 627 Dynaset is not updatable or Edit method has not been invoked
 628 ' ' Dynaset method illegal - no scrollable cursor support
 629 Warning:   (ODBC - SQLSetConnectOption failure)
 630 Property is read-only
 631 Zero rows affected by Update method
 632 Update illegal without previous Edit or AddNew method
 633 Append illegal - Field is part of a TableDefs collection
 634 Property value only valid when Field is part of a Dynaset
 635 Cannot set the property of an object which is part of a Database
     object
 636 Set field value illegal without previous Edit or AddNew method
 637 Append illegal - Index is part of a TableDefs collection
 638 Access attempted on unopened Dynaset
 639 Field type is illegal
 640 Field size illegal for specified Field Type
 641   illegal - no current record
 642 Reserved parameter must be FALSE
 643 Property Not Found
 644 ODBC - SQLConfigDataSource error ' '
 645 ODBC Driver does not support exclusive access to Dynasets
 646 GetChunk: Offset/Size argument combination illegal
 647 Delete method requires a name argument
 648 Data access objects require VBDB300.DLL
2420 Syntax error in number
2421 Syntax error in date
2422 Syntax error in string
2423 Invalid use of '.', '!', or '()'.
2424 Unknown name
2425 Unknown function name
2426 Function isn't available in expressions
2427 Object has no value
2428 Invalid arguments used with domain function
2429 In operator without ()
2430 Between operator without And
2431 Syntax error
2432 Syntax error
2433 Syntax error
2434 Syntax error
2435 Extra )
2436 Missing ), ], or
2437 Invalid use of vertical bars
2438 Syntax error
2439 Wrong number of arguments used with function
2440 IIF function without ()
2442 Invalid use of parentheses
2443 Invalid use of Is operator
2445 Expression too complex
2446 Out of memory during calculation
2447 Invalid use of '.', '!', or '()'.
2448 Can't set value.
2449 Invalid method in expression.
2450 Invalid reference to form ' '.
2451 Invalid reference to report ' '.
2452 Invalid reference to Parent property.
2453 Invalid reference to control ' '.
2454 Invalid reference to '! '.
2455 Invalid reference to property ' '.
2456 Invalid form number reference.
2457 Invalid report number reference.
2458 Invalid control number reference.
2459 Can't refer to Parent property in Design view.
2460 Can't refer to Dynaset property in Design view.
2461 Invalid section reference.
2462 Invalid section number reference.
2463 Invalid group level reference.
2464 Invalid group level number reference.
2465 Invalid reference to field ' '.
2466 Invalid reference to Dynaset property.
2467 Object referred to in expression no longer exists.
2468 Invalid argument used with DatePart, DateAdd or DateDiff function.
2469  1 in validation rule: '|2'.
2470   in validation rule.
2471   in query.
2472   in linked master field.
2473  1 in '|2' expression.
2474 No control is active.
2475 No form is active.
2476 No report is active.
2477 Invalid subclass ' ' referred to in TypeOf function.
3000 Reserved error ( ); there is no message for this error.
3001 Invalid argument.
3002 Couldn't start session.
3003 Couldn't start transaction; too many transactions already nested.
3004 Couldn't find database ' '.
3005 ' ' isn't a valid database name.
3006 Database ' ' is exclusively locked.
3007 Couldn't open database ' '.
3008 Table ' ' is exclusively locked.
3009 Couldn't lock table ' '; currently in use.
3010 Table ' ' already exists.
3011 Couldn't find object ' '.
3012 Object ' ' already exists.
3013 Couldn't rename installable ISAM file.
3014 Can't open any more tables.
3015 ' ' isn't an index in this table.
3016 Field won't fit in record.
3017 Field length is too long.
3018 Couldn't find field ' '.
3019 Operation invalid without a current index.
3020 Update without AddNew or Edit.
3021 No current record.
3022 Can't have duplicate key; index changes were unsuccessful.
3023 AddNew or Edit already used.
3024 Couldn't find file ' '.
3025 Can't open any more files.
3026 Not enough space on disk.
3027 Couldn't update; database is read-only.
3028 Couldn't initialize data access because file 'SYSTEM.MDA' couldn't
     be opened.
3029 Not a valid account name or password.
3030 ' ' isn't a valid account name.
3031 Not a valid password.
3032 Can't delete account.
3033 No permission for ' '.
3034 Commit or Rollback without BeginTrans.
3035 Out of memory.
3036 Database has reached maximum size.
3037 Can't open any more tables or queries.
3038 Out of memory.
3039 Couldn't create index; too many indexes already defined.
3040 Disk I/O error during read.
3041 Incompatible database version.
3042 Out of MS-DOS file handles.
3043 Disk or network error.
3044 ' ' isn't a valid path.
3045 Couldn't use ' '; file already in use.
3046 Couldn't save; currently locked by another user.
3047 Record is too large.
3048 Can't open any more databases.
3049 ' ' is corrupted or isn't a Microsoft Access database.
3050 Couldn't lock file; SHARE.EXE hasn't been loaded.
3051 Couldn't open file ' '.
3052 MS-DOS file sharing lock count exceeded.  You need to increase the
     number of locks installed with SHARE.EXE.
3053 Too many client tasks.
3054 Too many Memo or Long Binary fields.
3055 Not a valid file name.
3056 Couldn't repair this database.
3057 Operation not supported on attached tables.
3058 Can't have Null value in index.
3059 Operation canceled by user.
3060 Wrong data type for parameter ' '.
3061  1 parameters were expected, but only |2 were supplied.
3062 Duplicate output alias ' '.
3063 Duplicate output destination ' '.
3064 Can't open action query ' '.
3065 Can't execute a non-action query.
3066 Query must have at least one output field.
3067 Query input must contain at least one table or query.
3068 Not a valid alias name.
3069 Can't have action query ' ' as an input.
3070 Can't bind name ' '.
3071 Can't evaluate expression.
3073 Operation must use an updatable query.
3074 Can't repeat table name ' ' in FROM clause.
3075  1 in query expression '|2'.
3076   in criteria expression.
3077   in expression.
3078 Couldn't find input table or query ' '.
3079 Ambiguous field reference ' '.
3080 Joined table ' ' not listed in FROM clause.
3081 Can't join more than one table with the same name ( ).
3082 JOIN operation ' ' refers to a non-joined table.
3083 Can't use internal report query.
3084 Can't insert into action query.
3085 Undefined function ' ' in expression.
3086 Couldn't delete from specified tables.
3087 Too many expressions in GROUP BY clause.
3088 Too many expressions in ORDER BY clause.
3089 Too many expressions in DISTINCT output.
3090 Resultant table may not have more than one Counter field.
3091 HAVING clause ( ) without grouping or aggregation.
3092 Can't use HAVING clause in TRANSFORM statement.
3093 ORDER BY clause ( ) conflicts with DISTINCT.
3094 ORDER BY clause ( ) conflicts with GROUP BY clause.
3095 Can't have aggregate function in expression ( ).
3096 Can't have aggregate function in WHERE clause ( ).
3097 Can't have aggregate function in ORDER BY clause ( ).
3098 Can't have aggregate function in GROUP BY clause ( ).
3099 Can't have aggregate function in JOIN operation ( ).
3100 Can't set field ' ' in join key to Null.
3101 Join is broken by value(s) in fields ' '.
3102 Circular reference caused by ' '.
3103 Circular reference caused by alias ' ' in query definition's SELECT
     list.
3104 Can't specify Fixed Column Heading ' ' in a crosstab query more
     than once.
3105 Missing destination field name in SELECT INTO statement ( ).
3106 Missing destination field name in UPDATE statement ( ).
3107 Couldn't insert; no insert permission for table or query ' '.
3108 Couldn't replace; no replace permission for table or query ' '.
3109 Couldn't delete; no delete permission for table or query ' '.
3110 Couldn't read definitions; no read definitions permission for table
     or query ' '.
3111 Couldn't create; no create permission for table or query ' '.
3112 Couldn't read; no read permission for table or query ' '.
3113 Can't update ' '; field not updatable.
3114 Can't include Memo or Long Binary when you select unique values
     ( ).
3115 Can't have Memo or Long Binary in aggregate argument ( ).
3116 Can't have Memo or Long Binary in criteria ( ) for aggregate
     function.
3117 Can't sort on Memo or Long Binary ( ).
3118 Can't join on Memo or Long Binary ( ).
3119 Can't group on Memo or Long Binary ( ).
3120 Can't group on fields selected with '*' ( ).
3121 Can't group on fields selected with '*'.
3122 ' ' not part of aggregate function or grouping.
3123 Can't use '*' in crosstab query.
3124 Can't input from internal report query ( ).
3125 ' ' isn't a valid name.
3126 Invalid bracketing of name ' '.
3127 INSERT INTO statement contains unknown field name ' '.
3128 Must specify tables to delete from.
3129 Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE',
     'SELECT', or 'UPDATE'.
3130 Syntax error in DELETE statement.
3131 Syntax error in FROM clause.
3132 Syntax error in GROUP BY clause.
3133 Syntax error in HAVING clause.
3134 Syntax error in INSERT statement.
3135 Syntax error in JOIN operation.
3136 Syntax error in LEVEL clause.
3137 Missing semicolon (;) at end of SQL statement.
3138 Syntax error in ORDER BY clause.
3139 Syntax error in PARAMETER clause.
3140 Syntax error in PROCEDURE clause.
3141 Syntax error in SELECT statement.
3142 Characters found after end of SQL statement.
3143 Syntax error in TRANSFORM statement.
3144 Syntax error in UPDATE statement.
3145 Syntax error in WHERE clause.
3146 ODBC--call failed.
3147 ODBC--data buffer overflow.
3148 ODBC--connection failed.
3149 ODBC--incorrect DLL.
3150 ODBC--missing DLL.
3151 ODBC--connection to ' ' failed.
3152 ODBC--incorrect driver version ' 1'; expected version '|2'.
3153 ODBC--incorrect server version ' 1'; expected version '|2'.
3154 ODBC--couldn't find DLL ' '.
3155 ODBC--insert failed.
3156 ODBC--delete failed.
3157 ODBC--update failed.
3158 Couldn't save record; currently locked by another user.
3159 Not a valid bookmark.
3160 Table isn't open.
3161 Couldn't decrypt file.
3162 Null is invalid.
3163 Couldn't insert or paste; data too long for field.
3164 Couldn't update field.
3165 Couldn't open .INF file.
3166 Missing memo file.
3167 Record is deleted.
3168 Invalid .INF file.
3169 Illegal type in expression.
3170 Couldn't find installable ISAM.
3171 Couldn't find net path or user name.
3172 Couldn't open PARADOX.NET.
3173 Couldn't open table 'MSysAccounts' in SYSTEM.MDA.
3174 Couldn't open table 'MSysGroups' in SYSTEM.MDA.
3175 Date is out of range or is in an invalid format.
3176 Couldn't open file ' '.
3177 Not a valid table name.
3178 Out of memory.
3179 Encountered unexpected end of file.
3180 Couldn't write to file ' '.
3181 Invalid range.
3182 Invalid file format.
3183 Not enough space on temporary disk.
3184 Couldn't execute query; couldn't find linked table.
3185 SELECT INTO remote database tried to produce too many fields.
3186 Couldn't save; currently locked by user ' 2' on machine '|1'.
3187 Couldn't read; currently locked by user ' 2' on machine '|1'.
3188 Couldn't update; currently locked by another session on this
     machine.
3189 Table ' 1' is exclusively locked by user '|3' on machine '|2'.
3190 Too many fields defined.
3191 Can't define field more than once.
3192 Couldn't find output table ' '.
3193 (unknown)
3194 (unknown)
3195 (expression)
3196 Couldn't use ' '; database already in use.
3197 Data has changed; operation stopped.
3198 Couldn't start session.  Too many sessions already active.
3199 Couldn't find reference.
3200 Can't delete or change record. Since related records exist in table
     ' ', referential integrity rules would be violated.
3201 Can't add or change record.  Referential integrity rules require
a related record in table ' '.
3202 Couldn't save; currently locked by another user.
3203 Can't specify subquery in expression ( ).
3204 Database already exists.
3205 Too many crosstab column headers ( ).
3206 Can't create a relationship between a field and itself.
3207 Operation not supported on Paradox table with no primary key.
3208 Invalid Deleted entry in [dBASE ISAM] section in INI file.
3209 Invalid Stats entry in [dBASE ISAM] section in INI file.
3210 Connect string too long.
3211 Couldn't lock table ' '; currently in use.
3212 Couldn't lock table ' 1'; currently in use by user '|3' on machine
     '|2'.
3213 Invalid Date entry in [dBASE ISAM] section in INI file.
3214 Invalid Mark entry in [dBASE ISAM] section in INI file.
3215 Too many Btrieve tasks.
3216 Parameter ' ' specified where a table name is required.
3217 Parameter ' ' specified where a database name is required.
3218 Couldn't update; currently locked.
3219 Can't perform operation; it is illegal.
3220 Wrong Paradox sort sequence.
3221 Invalid entries in [Btrieve ISAM] section in WIN.INI.
3222 Query can't contain a Database parameter.
3223 ' ' isn't a valid parameter name.
3224 Btrieve--data dictionary is corrupted.
3225 Encountered record locking deadlock while performing Btrieve
     operation.
3226 Errors encountered while using the Btrieve DLL.
3227 Invalid Century entry in [dBASE ISAM] section in INI file.
3228 Invalid CollatingSequence entry in [Paradox ISAM] section in INI
     file.
3229 Btrieve--can't change field.
3230 Out-of-date Paradox lock file.
3231 ODBC--field would be too long; data truncated.
3232 ODBC--couldn't create table.
3233 ODBC--incorrect driver version.
3234 ODBC--remote query timeout expired.
3235 ODBC--data type not supported on server.
3236 ODBC--encountered unexpected Null value.
3237 ODBC--unexpected type.
3238 ODBC--data out of range.
3239 Too many active users.
3240 Btrieve--missing WBTRCALL.DLL.
3241 Btrieve--out of resources.
3242 Invalid reference in SELECT statement.
3243 None of the import field names match fields in the appended table.
3244 Can't import password-protected spreadsheet.
3245 Couldn't parse field names from first row of import table.
3246 Operation not supported in transactions.
3247 ODBC--linked table definition has changed.
3248 Invalid NetworkAccess entry in INI file.
3249 Invalid PageTimeout entry in INI file.
3250 Couldn't build key.
3251 Feature not available.
3252 Illegal reentrancy during query execution.
3254 ODBC--Can't lock all records.
3255 ODBC--Can't change connect string parameter.
3256 Index file not found.
3257 Syntax error in WITH OWNERACCESS OPTION declaration.
3258 Query contains ambiguous (outer) joins.
3259 Invalid field data type.
3260 Couldn't update; currently locked by user ' 2' on machine '|1'.
3261
3262
3263 Invalid database object.
3264 No fields defined - cannot append table.
3265 Name not found in this collection.
3266 Append illegal - Field is part of a TableDefs collection.
3267 Property value only valid when Field is part of a recordset.
3268 Cannot set the property of an object which is part of a Database
     object.
3269 Append illegal - Index is part of a TableDefs collection.
3270 Property not found.
3271 Invalid property value.
3272 Object is not an array.
3273 Method not applicable for this object.
3274 External table isn't in the expected format.
3275 Unexpected error from external database driver ( ).
3276 Invalid database ID.
3277 Can't have more than 10 fields in an index.
3278 Database engine has not been initialized.
3279 Database engine has already been initialized.
3280 Can't delete a field that is part of an index.
3281 Can't delete an index that is used in a relationship.
3282 Can't perform operation on a nontable.
3283 Primary key already exists.
3284 Index already exists.
3285 Invalid index definition.
3286 Invalid type for Memo field.
3287 Can't create index on Memo field or Long Binary field.
3288 Invalid ODBC driver.
3289 Paradox: No primary index.
3290 Syntax error.
3291 Syntax error in CREATE TABLE statement.
3292 Syntax error in CREATE INDEX statement.
3293 Syntax error in column definition.
3294 Syntax error in ALTER TABLE statement.
3295 Syntax error in DROP INDEX statement.
3296 Syntax error in DROP statement.
3297 Operation not supported in version 1.1
3298 Couldn't import. No records found or all records contained errors.
3299 Several tables exist with that name; please specify owner, as in
     'owner.table'.

Additional reference words: 3.00
KBCategory: kbref
KBSubcategory: RefsDoc

Back to Top

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 1995.

[ Welcome | What's New | FAQ | Bugs | Suggestions | Download | Guarantee | Get Key | Discussion | Search ]

MYM2QIFW is a trademark of Response Mechanics, Inc. All other product names, referenced herein, are registered trade names of their respective companies. Neither Bank Of America, Intuit, MECA, Microsoft, NationsBank, nor any of their subsidiaries or affiliates warrants the effectiveness or accuracy of the MYM2QIFW translation software. The limited warranty is stated on the first screen viewed when MYM2QIFW runs.
Questions or problems regarding this web site should be directed to Support@RespMech.com.
Copyright 1997 Response Mechanics. Your privacy. All rights reserved. Last modified: Wednesday October 28, 1998 by Ranny Meier.