Recent content by Guidon Mendoza

  1. G

    Solved Problem in ADO, with .AddNew to a remote DB

    And thanks to you too, arnelgp!
  2. G

    Solved Problem in ADO, with .AddNew to a remote DB

    Thanks, Minty! That was fast!
  3. G

    Solved Problem in ADO, with .AddNew to a remote DB

    I just found the answer on a MySQL document. Here the quote: Multiple-Step Operation Error Using the AppendChunk() or GetChunk() ADO methods, the Multiple-step operation generated errors. Check each status value error is returned. The GetChunk() and AppendChunk()...
  4. G

    Solved Problem in ADO, with .AddNew to a remote DB

    Hi, everyone! I have a project to share information for a work group over the Internet. To do so, I created a front-end platform in Access 2016 and remotely connected it to a MySQL DB. The connection seams to work fine, since I'm able to read and make updates using the connection. I've been...
  5. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    At the end, this is the solution I was looking for! Thanks a lot!!!
  6. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    Actually, that's what I wanted to do, but it did not work. This is how I started the question: "I have an MS Access 2016 platform linked to a MySQL database on a server somewhere. My platform is in 32-bit. I implemented Deletions, Creations and both work fine. But when I tried to Update...
  7. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    Actually, I'm not connecting to the remote DB until I get the Insert done, but it's never done, because of the 3065 error. As background, I need the Recordset in the beginning of the code to create the INSERT query: I receive the Object, and create the strSQL to execute. strSQL = "USE...
  8. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    Should I start a new thread? And actually is far faster with SQL, thanks!!
  9. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    No, I'm moving forward, using your help. Actually I was able to create a UPDATE query and make it work with an abstract object. Thanks!! Now I'm stuck with an Error Code 3065. The code I'm using is this: Function AddRec(Tbl As String, NewRec As Object, KeyId As String) As Long Dim DB As...
  10. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    Thanks to all of you. Isladog, is that correct for every recordset type? And if so, then the database is locked through out the whole process? Pat, I did refresh it. Arnelgp, I'll try this option also. Thanks. Thanks again. G
  11. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    I did alter the table manually and it works fine. I modified the tables for everyone to have a PK/Unique field. Even then, it did not work...
  12. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    Thanks a lot for the advise! I'll implement it as far as I can. The reason I wanted to use Recordsets is that the logic for constructing the SQL statements is complex in several parts of the program (and results in not very elegant code...), and the code is hard to abstract. On the other...
  13. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    Actually, if I try to do the update with an SQL command, it worked this time! I still would love to do it in Recerdsets, though... And here is the code that works: Private Sub BtnTest_Click() Dim DB As dao.Database Dim rst As dao.Recordset Dim strSQL As String Inicialization On...
  14. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    Thanks for your answer! I've tried with DAO recordsets and with SQL statements. I created a Test Button, to execute every option: The ConnectionStr I already tested (and since it works with delete and create, I don't see a problem it may have. Here I have a docmd.runsql for a straight SQL...
  15. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    Hi, Masters! I have an MS Access 2016 platform linked to a MySQL database on a server somewhere. My platform is in 32-bit. I implemented Deletions, Creations and both work fine. But when I tried to Update records, it shows error 3157 (shows what's in the title). I have tried to change the...
Top Bottom