I am moving a number of MS Access 2003 applications from MS SQL to MySQL, and I need an example connection string and parametrized stored procedure that is the equivalent of
Set cn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.RecordSet")
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=username; password=password; Initial Catalog=MyDB;Data Source=192.168.0.1"
spSQL = "execute spSelectRecords " & TableName
set rs = cn.Execute spSQL
Where the sproc is "Select * from @TableName
Thanks in advance!