"Kent Roberts" <[EMAIL PROTECTED]> wrote on 08/09/2005 12:24:11 PM:
> Has anyone had experience with this yet? My attempts so far render > "ODBC--call failed". My connection is good and I can use select > statements successfully, but no luck with calling an SP yet. I > really want to call an SP with parameters, but I'm trying a simple > one first. Also, anyone know of a forum dedicated to using Access as > a front-end to MySql? > > Thanks in advance...again. > Your options depend on if you are using OLEDB, ADO, or DAO to communicate with the ODBC driver. Refer to the appropriate library documentation to figure out how to get a recordset from a command. If you are using ADO, I would look closely at these objects.methods: Connection.Execute Command.Execute (along with the Parameter object) Recordset.Open But you say you are in MS Access, so I guess you are using DAO to control the ODBC connection? I am too rusty with DAO to suggest anything there. Shawn Green Database Administrator Unimin Corporation - Spruce Pine