Error Code -3034

For future reference, if you paste this code into a module and run it, it will make a table in your db with most of the codes used in Access and a breif description:

***************

The following procedure creates a table containing many of the error codes and strings used or reserved by Microsoft Access and by the Microsoft Jet database engine. Not all error codes are included in the resulting table, as some exist outside the range of error codes evaluated by this procedure (0 to 4500).

Function AccessAndJetErrorsTable() As Boolean
      Dim dbs As Database, tdf As TableDef, fld As Field
      Dim rst As Recordset, lngCode As Long
      Dim strAccessErr As String
      Const conAppObjectError = "Application-defined or object-defined error"

      On Error GoTo Error_AccessAndJetErrorsTable
      ' Create Errors table with ErrorNumber and ErrorDescription fields.
      Set dbs = CurrentDb
      Set tdf = dbs.CreateTableDef("AccessAndJetErrors")
      Set fld = tdf.CreateField("ErrorCode", dbLong)

tdf.Fields.Append fld
      Set fld = tdf.CreateField("ErrorString", dbMemo)
      tdf.Fields.Append fld

      dbs.TableDefs.Append tdf
      ' Open recordset on Errors table.
      Set rst = dbs.OpenRecordset("AccessAndJetErrors")
      ' Loop through error codes.
      For lngCode = 0 To 3500
            On Error Resume Next
            ' Raise each error.
            strAccessErr = AccessError(lngCode)
            DoCmd.Hourglass True
            ' Skip error numbers without associated strings.
            If strAccessErr <> "" Then

' Skip codes that generate application or object-defined errors.
                  If strAccessErr <> conAppObjectError Then
                        ' Add each error code and string to Errors table.
                        rst.AddNew
                        rst!ErrorCode = lngCode
                        ' Append string to memo field.
                        rst!ErrorString.AppendChunk strAccessErr
                        rst.Update
                  End If
            End If
      Next lngCode
      ' Close recordset.
      rst.Close
      DoCmd.Hourglass False
      RefreshDatabaseWindow
      MsgBox "Access and Jet errors table created."

AccessAndJetErrorsTable = True

Exit_AccessAndJetErrorsTable:
      Exit Function

Error_AccessAndJetErrorsTable:
      MsgBox Err & ": " & Err.Description
      AccessAndJetErrorsTable = False
      Resume Exit_AccessAndJetErrorsTable
End Function

Buggie,

is this answer good? If so accept, if not let me know

No response?

GREETINGS!

This question was awarded, but never cleared due to the JSP-500 errors of that time.  It was "stuck" against userID -1 versus the intended expert whom you awarded.  This corrects the problem and the expert will now receive these points; points verified.

Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them.  If you are an EE Pro user, you can also choose Power Search to find all your open questions.

This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added.  Also in the Community Support link is a question on how experts can help, if they wish, on the cleaning of old and abandoned questions.

https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
https://www.experts-exchange.com/jsp/zonesAll.jsp
 
Thank you,
Moondancer
Moderator @ Experts Exchange