Results 1 to 2 of 2

Thread: UPDATE ???

  1. #1
    Bruce Heller Guest

    Default UPDATE ???

    Well, I&#039ve got a weird issue and I really do not know how to get out of that...<BR><BR>When I use that it works very well :<BR>Set DBconnect = Server.CreateObject("ADODB.connection")<BR><BR>DBC onnect.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:inetpubwwwrootrucefpdbmp3db.mdb"<BR><BR>str ComptSQL="UPDATE compte1 SET count = 1"<BR><BR>Set ComptRS=DBConnect.Execute(strComptSQL)<BR><BR>But when I change the connection string to :<BR>DBConnect.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=c:inetpubwwwrootrucefpdbmp3db.mdb"<BR><BR> I&#039ve got an error (it was in french so the error might not be the good english one) :<BR>Microsoft JET Database Engine error &#039 80040e14&#039 <BR>Syntax error in the UPDATE instruction. <BR><BR>Well... I can&#039t do any update in an OLEDB connection ???<BR><BR>Pleaze help because my host only accept OLEDB... (no DSN or standard DSN-Less...)

  2. #2
    Join Date
    Dec 1969

    Default RE: UPDATE ???

    are you trying to set an autonumber or primary key to 1 ?<BR><BR>j

Posting Permissions

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