April 28th, 2011, 12:20 AM
Sorry, I did not understand: what is not PUBLIC? Should the function be public?
And regarding your other point, the function returns a connection object. The purpose of this function is to be used...
April 26th, 2011, 01:56 PM
I see your point and maybe I will use stored functions, but for now, the problem I face is different: I can not compile the VBA code with a reference to a DLL class using an ADO object. Any idea...
April 26th, 2011, 12:46 AM
Sorry I do not follow you. I do not know what are the "credentials from the DLL". I Google to find more info and I saw that that task is related to C or C++ DLLs that check user identity.
My idea...
April 25th, 2011, 03:12 PM
Hello
I was using Excel-VBA to connect to a MySQL database with ADO in this way:
Dim conn As ADODB.Connection
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=" &...
