odbc data embedded howto

[mlh407]

I want to create a linked table with the odbc connection information embedded. I know the driver (in this case, mysql) will have to be on the users computer, but they won't have to setup the acutally odbc connection.

Is there anyway to do this in access

here is the vb code

  my_conn.Open("Driver={MySQL ODBC 3.51 Driver};" & _
                   "Server="localhost;" & _
                   "Port=3306;" & _
                   "Option=35;" & _
                   "Stmt=;" & _
                   "Database=people;" & _
                   "Uid=mote;" & _
                   "Pwd=user")
        strSQL = "select * from emp"
        rs = my_conn.Execute(strSQL)