Modules & VBA :: Connect To MySQL Via ODBC

I've developed an Acc2003 App that reads from a ODBC linked table.This link was created fro DBwindow->Link table. It often opens a window asking for userNmae and Pwd - I wold liek to aviod this wen distributing the App. So I wrote tis code:

Code:
Public Sub linkOdbcTable(DataSource As String, UID As String, PWD As String, dbName As String, ParamArray Tables())
Dim dbs As Database
Dim tbl As Variant
Dim rst As DAO.Recordset
Dim linked As Boolean
Dim ConnectionString As String

[code]....