Results 1 to 12 of 12

Thread: Error

  1. #1
    Jim Presley Guest

    Error

    I all of a sudden receive this error when updating records, I have
    checked the tables for reserved words and find none.


    Error # = 80040E14(-2147217900)
    Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 37000
    Native Error = -3503

  2. #2
    Mark Guest

    Error (reply)

    Jim,

    It sure sounds like a reserved word problem. Anyway, do this:
    Turn on debug (X.dbDebug=4 or 101) to see what the exact SQL that is trying to execute. Take a close look at it and/or show it to us.

    ALSO … Be sure the TableName doesn’t have a "minus sign" in it. such as [RES-FLD-NAMES].

    Mark.


    ------------
    Jim Presley at 5/9/00 9:37:53 AM

    I all of a sudden receive this error when updating records, I have
    checked the tables for reserved words and find none.


    Error # = 80040E14(-2147217900)
    Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 37000
    Native Error = -3503

  3. #3
    Jim Presley Guest

    Error (reply)

    Checked three times, the reserved listing.
    Start ASPdb
    Localize3
    Localize -1
    Enter Get Connection
    Test Blank
    Grid: Entering
    Show Grid: SX, mode, SQL=_111/grid/Select * FROM [Central Iowa Equipment]
    mySQL in Get_OrderBY=Select * FROM [Central Iowa Equipment]
    tail,p1=/39
    heads=Select * FROM [Central Iowa Equipment]/
    Show Grid: Sort Name V=
    Grid: mySQL Select * FROM [Central Iowa Equipment]
    Grid: After get RS - Select * FROM [Central Iowa Equipment]
    PT=GridPtr/RecInc/FormPtr=0/5/0
    PT right before move = 0
    Grid SQL=Select * FROM [Central Iowa Equipment]
    Before move (Show Grid) = 5/9/00 9:46:36 AM

    Get_RS: Entering mode=dual-horiz
    Begin Setfilterinsql, filter=Select * FROM [Central Iowa Equipment]/
    Get_RS_get_Count, SQL=Select * FROM [Central Iowa Equipment]/0
    Get_RS_GetCount: DBTYPE, SelectFROM,UseRSFilter,ORACLEServer,CountSQL=ACCES S / True / False / /
    Construct CountSQL - SELECT COUNT(*) as c FROM [Central Iowa Equipment]
    No filter count=1929
    Count=1929
    Get_RS_OPEN: Entering GET_RS_OPEN
    Get_RS_OPEN: mySQL in memory=Select * FROM [Central Iowa Equipment]
    Get_RS_OPEN: High speed TOP
    TOPSQL,psize=Select TOP 5 * FROM [Central Iowa Equipment]/5
    Get_RS_OPEN: TOPSQL, cursor=Select TOP 5 * FROM [Central Iowa Equipment]/0
    Get_RS_OPEN: After oRs open Fcount=33
    Display=True
    DisplayLookUpListSetup-
    Get_Form_TrueCnt: TrueCnt=33
    Exit Get_RS
    After Get_RS
    Show Navigation Bar =top
    Total Buttons=25

    Top Prev Next Filter Canedit=1
    Add Update



    HeadSelBG, HeadSelFG= BGCOLOR=#FF99FF /#000000
    HeadSelBG, HeadSelFG= BGCOLOR=#FF99FF /#000000
    HeadSelBG, HeadSelFG= BGCOLOR=#FF99FF /#000000
    # PMI Make Model Serial
    1 Gateway2000/solo2300 8004696
    2 Gateway2000/solo2300 8004697
    3 Gateway2000/solo2300 8004700
    4 DIGITAL/5000PC KN746PZS99
    5 Gateway2000/GP7-550 0018334351
    Grid: Leaving, FormPtr=0
    Form: Entering SQL = Select * FROM [Central Iowa Equipment]

    Form:SQL/FTP=Select * FROM [Central Iowa Equipment]/0
    Get_RS: Entering mode=dual-horiz
    Begin Setfilterinsql, filter=Select * FROM [Central Iowa Equipment]/
    Get_RS_get_Count, SQL=Select * FROM [Central Iowa Equipment]/1929
    Get_RS_OPEN: Entering GET_RS_OPEN
    Get_RS_OPEN: mySQL in memory=Select * FROM [Central Iowa Equipment]
    Get_RS_OPEN: High speed TOP
    TOPSQL,psize=Select TOP 1 * FROM [Central Iowa Equipment]/1
    Get_RS_OPEN: TOPSQL, cursor=Select TOP 1 * FROM [Central Iowa Equipment]/0
    Get_RS_OPEN: After oRs open Fcount=33
    Display=True
    Get_Form_TrueCnt: TrueCnt=33
    Exit Get_RS
    Form: Return from Get_RS - UserRs=False
    ID 24199
    PMI
    Make Model Gateway2000/solo2300
    Serial 8004696
    Purchase Order P71045
    Cost
    Type of Device PC
    Memory
    Mouse
    Hard Disk Size
    Hard Disk Type
    Disk Drives
    Other
    Service Using IRM
    Phone
    Program Using
    Status STORAGE
    Building 68
    Room 206A
    Cable Pair
    CMR
    Month
    Work Station Lap Top
    Total 1
    Network Address
    IP Address
    System Using
    Serial DB
    INV True
    Date Installed
    Printer
    Location Knoxville
    Campus Navigation at form bottom - top
    Knoxville


    Show Status Bar

    [1 - 5 : 1929]



    ------------
    Mark at 5/9/00 9:55:49 AM

    Jim,

    It sure sounds like a reserved word problem. Anyway, do this:
    Turn on debug (X.dbDebug=4 or 101) to see what the exact SQL that is trying to execute. Take a close look at it and/or show it to us.

    ALSO … Be sure the TableName doesn’t have a "minus sign" in it. such as [RES-FLD-NAMES].

    Mark.


    ------------
    Jim Presley at 5/9/00 9:37:53 AM

    I all of a sudden receive this error when updating records, I have
    checked the tables for reserved words and find none.


    Error # = 80040E14(-2147217900)
    Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 37000
    Native Error = -3503

  4. #4
    Mark Guest

    Error (reply)

    Jim,

    I still don't see the UPDATE SQL in your debug output. Maybe you didn't go far enough. Did you actually click on Update Current Record and get to the error message? BTW "Date Installed" is an illegal field name according to Microsoft. See the list of Reserved Words at:

    http://www.aspdb.com/docs/aspdbman.htm#TOC_IVB

    The Debug line we are looking for will look something like this:

    Edit SQL=UPDATE Employees SET LastName = 'Davolio', FirstName = 'Nancy', Title = 'Sales Representative', TitleOfCourtesy = 'Ms.', BirthDate = #12/8/1962#, HireDate = #5/1/1992#, Address = '507 - 20th Ave. E.Apt. 2Ax', City = 'Seattle', Region = 'WA', PostalCode = '98122', Country = 'USA', HomePhone = '(206) 555-9857', Extension = '5467', Notes = 'Education includes a BA in psychology from Colorado State University in 1970. She also completed "The Art of the Cold Call"', ReportsTo = 5 WHERE EmployeeID = 1

    Mark.

    ------------
    Jim Presley at 5/9/00 9:37:53 AM

    I all of a sudden receive this error when updating records, I have
    checked the tables for reserved words and find none.


    Error # = 80040E14(-2147217900)
    Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 37000
    Native Error = -3503

  5. #5
    Jim Presley Guest

    Error (reply)

    Thanks for the call Mark, here is the information after selecting update
    current record:

    Start ASPdb
    Localize3
    Localize -1
    Enter Get Connection
    Test Blank
    Edit Action=Update Current Record
    Entering edit: Update Current Record
    f1=, ID = #ID# , PMI = '#PMI#', [Make Model] = '#Make Model#', Serial = '#Serial#', [Purchase Order] = '#Purchase Order#', Cost = #Cost# , [Type of Device] = '#Type of Device#', Memory = '#Memory#', Mouse = '#Mouse#', [Hard Disk Size] = '#Hard Disk Size#', [Hard Disk Type] = '#Hard Disk Type#', [Disk Drives] = '#Disk Drives#', Other = '#Other#', [Service Using] = '#Service Using#', Phone = #Phone# , [Program Using] = '#Program Using#', Status = '#Status#', Building = '#Building#', Room = '#Room#', [Cable Pair] = #Cable Pair# , CMR = '#CMR#', Month = '#Month#', [Work Station] = '#Work Station#', [Network Address] = '#Network Address#', Total = #Total# , [IP Address] = '#IP Address#', [System Using] = '#System Using#', [Serial DB] = '#Serial DB#', INV = #INV# , [Date Installed] = #Date Installed#, Printer = '#Printer#', Location = '#Location#', Campus = '#Campus#',
    Update Arg, Field Value=ID|24199|
    Update Arg, Field Value=IP Address||
    Update Arg, Field Value=INV|True|
    Update Arg, Field Value=PMI||
    Update Arg, Field Value=Purchase Order|P71045|
    Update Arg, Field Value=Cost||
    Update Arg, Field Value=Other|testing error|
    Update Arg, Field Value=Make Model|Gateway2000/solo2300|
    Update Arg, Field Value=Serial|8004696|
    Update Arg, Field Value=Disk Drives||
    Update Arg, Field Value=Service Using|IRM|
    Update Arg, Field Value=Room|206A|
    Update Arg, Field Value=Location|Knoxville|
    Update Arg, Field Value=Type of Device|PC|
    Update Arg, Field Value=Program Using||
    Update Arg, Field Value=Campus|Knoxville|
    Update Arg, Field Value=aspDBUnit|_111|
    Update Arg, Field Value=Memory||
    Update Arg, Field Value=Total|1|
    Update Arg, Field Value=aspDBClick_111|applyupdate|
    Update Arg, Field Value=Mouse||
    Update Arg, Field Value=Network Address||
    Update Arg, Field Value=System Using||
    Update Arg, Field Value=Serial DB||
    Update Arg, Field Value=Hard Disk Size||
    Update Arg, Field Value=Hard Disk Type||
    Update Arg, Field Value=CMR||
    Update Arg, Field Value=Printer||
    Update Arg, Field Value=Phone||
    Update Arg, Field Value=Status|STORAGE|
    Update Arg, Field Value=Building|68|
    Update Arg, Field Value=Cable Pair||
    Update Arg, Field Value=Month||
    Update Arg, Field Value=Date Installed||
    Update Arg, Field Value=Work Station|Lap Top|
    final update f1=, ID = 24199 , PMI = 'Null', [Make Model] = 'Gateway2000/solo2300', Serial = '8004696', [Purchase Order] = 'P71045', Cost = Null , [Type of Device] = 'PC', Memory = 'Null', Mouse = 'Null', [Hard Disk Size] = 'Null', [Hard Disk Type] = 'Null', [Disk Drives] = 'Null', Other = 'testing error', [Service Using] = 'IRM', Phone = Null , [Program Using] = 'Null', Status = 'STORAGE', Building = '68', Room = '206A', [Cable Pair] = Null , CMR = 'Null', Month = 'Null', [Work Station] = 'Lap Top', [Network Address] = 'Null', Total = 1 , [IP Address] = 'Null', [System Using] = 'Null', [Serial DB] = 'Null', INV = #INV# , [Date Installed] = Null, Printer = 'Null', Location = 'Knoxville', Campus = 'Knoxville',


    Error # = 80040E14(-2147217900)
    Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 37000
    Native Error = -3503



    End SQL execution



    ------------
    Mark at 5/9/00 11:00:53 AM

    Jim,

    I still don't see the UPDATE SQL in your debug output. Maybe you didn't go far enough. Did you actually click on Update Current Record and get to the error message? BTW "Date Installed" is an illegal field name according to Microsoft. See the list of Reserved Words at:

    http://www.aspdb.com/docs/aspdbman.htm#TOC_IVB

    The Debug line we are looking for will look something like this:

    Edit SQL=UPDATE Employees SET LastName = 'Davolio', FirstName = 'Nancy', Title = 'Sales Representative', TitleOfCourtesy = 'Ms.', BirthDate = #12/8/1962#, HireDate = #5/1/1992#, Address = '507 - 20th Ave. E.Apt. 2Ax', City = 'Seattle', Region = 'WA', PostalCode = '98122', Country = 'USA', HomePhone = '(206) 555-9857', Extension = '5467', Notes = 'Education includes a BA in psychology from Colorado State University in 1970. She also completed "The Art of the Cold Call"', ReportsTo = 5 WHERE EmployeeID = 1

    Mark.

    ------------
    Jim Presley at 5/9/00 9:37:53 AM

    I all of a sudden receive this error when updating records, I have
    checked the tables for reserved words and find none.


    Error # = 80040E14(-2147217900)
    Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 37000
    Native Error = -3503

  6. #6
    Jim Presley Guest

    Error (reply)

    Per your instructions, editing one field at a time, received same error
    throughout, double checked reserved words against the database, nothing
    received this error with debug:

    Start ASPdb
    Localize3
    Localize -1
    Enter Get Connection
    Test Blank
    Edit Action=Update Current Record
    Entering edit: Update Current Record
    f1=, ID = #ID# , PMI = '#PMI#', Cost = #Cost# , [Type of Device] = '#Type of Device#', Memory = '#Memory#', Mouse = '#Mouse#', [Hard Disk Size] = '#Hard Disk Size#', [Hard Disk Type] = '#Hard Disk Type#', [Disk Drives] = '#Disk Drives#', Other = '#Other#', [Service Using] = '#Service Using#', Phone = '#Phone#', [Program Using] = '#Program Using#', Status = '#Status#', Building = '#Building#', Room = '#Room#', Cable = #Cable# , CMR = '#CMR#', Month = '#Month#', [Work Station] = '#Work Station#', [Network Address] = '#Network Address#', Total = #Total# , [IP Address] = '#IP Address#', [System Using] = '#System Using#', [Serial DB] = '#Serial DB#', INV = #INV# , Installed = #Installed#, Printer = '#Printer#', Location = '#Location#', Campus = '#Campus#',
    Update Arg, Field Value=ID|24199|
    Update Arg, Field Value=IP Address||
    Update Arg, Field Value=INV|True|
    Update Arg, Field Value=PMI||
    Update Arg, Field Value=Cost|35.00|
    Update Arg, Field Value=Other||
    Update Arg, Field Value=Installed||
    Update Arg, Field Value=Type of Device|PC|
    Update Arg, Field Value=Program Using||
    Update Arg, Field Value=Campus|Knoxville|
    Update Arg, Field Value=aspDBUnit|_111|
    Update Arg, Field Value=Memory||
    Update Arg, Field Value=Total|1|
    Update Arg, Field Value=aspDBClick_111|applyupdate|
    Update Arg, Field Value=Mouse||
    Update Arg, Field Value=Cable||
    Update Arg, Field Value=Network Address||
    Update Arg, Field Value=System Using||
    Update Arg, Field Value=Serial DB||
    Update Arg, Field Value=Hard Disk Size||
    Update Arg, Field Value=Hard Disk Type||
    Update Arg, Field Value=CMR||
    Update Arg, Field Value=Printer||
    Update Arg, Field Value=Disk Drives||
    Update Arg, Field Value=Service Using|IRM|
    Update Arg, Field Value=Room|206A|
    Update Arg, Field Value=Location|Knoxville|
    Update Arg, Field Value=Phone||
    Update Arg, Field Value=Status|STORAGE|
    Update Arg, Field Value=Building|68|
    Update Arg, Field Value=Month||
    Update Arg, Field Value=Work Station|Lap Top|
    final update f1=, ID = 24199 , PMI = 'Null', Cost = 35.00 , [Type of Device] = 'PC', Memory = 'Null', Mouse = 'Null', [Hard Disk Size] = 'Null', [Hard Disk Type] = 'Null', [Disk Drives] = 'Null', Other = 'Null', [Service Using] = 'IRM', Phone = 'Null', [Program Using] = 'Null', Status = 'STORAGE', Building = '68', Room = '206A', Cable = Null , CMR = 'Null', Month = 'Null', [Work Station] = 'Lap Top', [Network Address] = 'Null', Total = 1 , [IP Address] = 'Null', [System Using] = 'Null', [Serial DB] = 'Null', INV = #INV# , Installed = Null, Printer = 'Null', Location = 'Knoxville', Campus = 'Knoxville',


    Error # = 80040E14(-2147217900)
    Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 37000
    Native Error = -3503



    End SQL execution



    ------------
    Jim Presley at 5/9/00 9:37:53 AM

    I all of a sudden receive this error when updating records, I have
    checked the tables for reserved words and find none.


    Error # = 80040E14(-2147217900)
    Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 37000
    Native Error = -3503

  7. #7
    Jim Presley Guest

    FOUND THE PROBLEM!!!

    Mark, I inserted dbRESET right after the SQL statement, and that appears
    to have fixed it.


    ------------
    Jim Presley at 5/9/00 9:37:53 AM

    I all of a sudden receive this error when updating records, I have
    checked the tables for reserved words and find none.


    Error # = 80040E14(-2147217900)
    Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 37000
    Native Error = -3503

  8. #8
    Jim Presley Guest

    FOUND THE PROBLEM!!! (reply)

    You are right, next and filter do not work well, but doesn't this prove
    a point that the reserved list is adhered too, and that this is another
    problem?


    ------------
    Jim Presley at 5/9/00 3:05:28 PM

    Mark, I inserted dbRESET right after the SQL statement, and that appears
    to have fixed it.


    ------------
    Jim Presley at 5/9/00 9:37:53 AM

    I all of a sudden receive this error when updating records, I have
    checked the tables for reserved words and find none.


    Error # = 80040E14(-2147217900)
    Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 37000
    Native Error = -3503

  9. #9
    Mark Guest

    FOUND THE PROBLEM!!! (reply)

    Jim,
    I don't think we've proved anything yet. I still haven't seen your source code and I would really appreciate it if you could email us a simple asp and mdb file that demonstrates your problem. Also, please set dbDebug=101 and try it again. 101 will dump the exact SQL that was trying to run at the time of the error. You can then copy it off your screen and paste it into an Access Query and let Access try to run it. Access will give you a better clue as to exactly where in the SQL the syntax error is occurring.

    Mark.


    ------------
    Jim Presley at 5/9/00 4:35:51 PM

    You are right, next and filter do not work well, but doesn't this prove
    a point that the reserved list is adhered too, and that this is another
    problem?


    ------------
    Jim Presley at 5/9/00 3:05:28 PM

    Mark, I inserted dbRESET right after the SQL statement, and that appears
    to have fixed it.


    ------------
    Jim Presley at 5/9/00 9:37:53 AM

    I all of a sudden receive this error when updating records, I have
    checked the tables for reserved words and find none.


    Error # = 80040E14(-2147217900)
    Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 37000
    Native Error = -3503

  10. #10
    Jim Presley Guest

    sorry




    ------------
    Mark at 5/9/00 4:46:11 PM

    Jim,
    I don't think we've proved anything yet. I still haven't seen your source code and I would really appreciate it if you could email us a simple asp and mdb file that demonstrates your problem. Also, please set dbDebug=101 and try it again. 101 will dump the exact SQL that was trying to run at the time of the error. You can then copy it off your screen and paste it into an Access Query and let Access try to run it. Access will give you a better clue as to exactly where in the SQL the syntax error is occurring.

    Mark.


    ------------
    Jim Presley at 5/9/00 4:35:51 PM

    You are right, next and filter do not work well, but doesn't this prove
    a point that the reserved list is adhered too, and that this is another
    problem?


    ------------
    Jim Presley at 5/9/00 3:05:28 PM

    Mark, I inserted dbRESET right after the SQL statement, and that appears
    to have fixed it.

    Sorry, got other jobs to do, but here is what dbDebug=101
    says:
    Edit SQL=UPDATE Central Iowa Equipment SET ID = 1 , PMI = 'Null', Cost = 0 , [Type of Device] = 'PRINTER', Memory = 'Null', Mouse = 'Null', [Hard Disk Size] = 'Null', [Hard Disk Type] = 'Null', [Disk Drives] = 'Null', Other = 'testing error', [Service Using] = 'MHC', Phone = '5807', [Program Using] = 'Null', Status = 'ACTIVE', Building = '1', Room = '233', Cable = 0 , CMR = 'Null', Month = 'Null', [Work Station] = 'Null', [Network Address] = 'Null', Total = 1 , [IP Address] = 'Null', [System Using] = 'Null', Installed = Null, Printer = 'Null', Location = 'DesMoines', Campus = 'DesMoines' WHERE ID = 1

    here is a simple asp I used:

    <html>

    <body>
    <%
    Set X = Server.CreateObject(&#34;ASPdb.Y2K&#34
    X.dbUnit = 141
    X.dbMDB=&#34;D:InetPubwwwrootIRMdatabase.mdb&#34;
    X.dbSQL=&#34;Select * FROM [Central Iowa Equipment]&#34;
    X.dbMode=&#34;Grid&#34;
    X.dbNavigationItem=&#34;Next,Prev,Add,Update,Delet e,Filter&#34;
    X.dbFilterFlds =&#34;Campus,Status,Installed&#34;
    X.dbEditParams=&#34;TableName=Central Iowa Equipment,BookMarkFlds=0&#34;
    X.dbEditFlds=&#34;Make Model,Cost,Service Using,Status,Building,Room,Location,Campus&#34;
    X.ASPdbY2k
    %>
    </body>

    </html>



    Error # = 80040E14(-2147217900)
    Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 37000
    Native Error = -3503


    ------------
    Jim Presley at 5/9/00 9:37:53 AM

    I all of a sudden receive this error when updating records, I have
    checked the tables for reserved words and find none.


    Error # = 80040E14(-2147217900)
    Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 37000
    Native Error = -3503

  11. #11
    Jim Presley Guest

    copied Access Db



    Mark, I copied the MS Access2000 table that was causing the error, and
    then deleted all entries except 9, then updated, this new table
    I received no Syntax errors. I reviewed both the table causing the
    error and the new table (9 entries), the structure is the same (field names
    types, etc.). The only difference I can tell is the number of entries (
    9 entries versus 1981 entries)
    ------------
    Jim Presley at 5/9/00 9:37:53 AM

    I all of a sudden receive this error when updating records, I have
    checked the tables for reserved words and find none.


    Error # = 80040E14(-2147217900)
    Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 37000
    Native Error = -3503

  12. #12
    Jim Presley Guest

    Sent E-mail with attachments



    Mark, I sent you copies via E-mail
    ------------
    Jim Presley at 5/9/00 9:37:53 AM

    I all of a sudden receive this error when updating records, I have
    checked the tables for reserved words and find none.


    Error # = 80040E14(-2147217900)
    Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = 37000
    Native Error = -3503

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •