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()...
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.
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...
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...
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...
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 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...
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
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...
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...