can not open mysql odbc backend as read-write from code RRS feed

  • Question

  • I have gone through my MySQL server setup for two days. I can only secure a read-only connection from code. The remote odbc connection can be established.  MySQL workbench connects remotely. I am able to upload tables and all their data, from access. I do have a read only connection in code.

    I use:

    Set dbs_mac = OpenDatabase("ConnectODBC32", True, False, "ODBC;DATABASE=db;UID=ServerClient;PWD=*********;DSN=ConnectODBC32") 'CurrentDb

    strSQL = "SELECT *" & _
            " FROM [Client Information]" & _
            " ORDER BY [client_id] ASC"

    Set rst_ctl = dbs_mac.OpenRecordset(strSQL, Type:=dbOpenDynaset, Options:=dbConsistent)

    it's hard to tell if I missed something on the internet because a lot of stuff changed since a lot of posts were made over a decade ago.

    Wednesday, September 6, 2017 12:43 AM

All replies