plea for help with ms access/vba > mysql backend

Currently i'm working on a project to migrate a ms access backend + frontend
system to work with mysql backend. I plan on migrating it to work with php/mysql
but during the process i'd like to stage out the migration and keep the current
frontend working.

I have used the mysql migration toolkit to get a good msyql db from the backend
database and have also installed the myodbc connector from mysql and then
recreated the backend mdb file to use linked tables. i am able to connect to this
db and make modifications from access and have them change the values in the mysql db.

but i'm having trouble making the frontend work with it. i dont' really get any errors
except for this one when starting

"The expression On Load you entered as the event property setting produced the following
error: There was a problem accessinga property or method of the OLE object"

but no refernces the line where it occurs. I have tried viewing the vba code, and while
a newb at vba i couldn't find any references to On Load (or even references to the opening
of the ADO connection)

i click ok and get to the frontend menu , but it is incomplete and no functionality
seems to work

i then tried enabling connection tracing in the odbc dialog, but see no queries listed.

I'm not quite sure of where to go next cuz i don't know access very well

What exactly happens when making an mde file?
what is the default behavior of ADO as i see no references to a connection string in the VBA 
code? ( i searched for DSN, ConnectionString, Connection.Open, Open, Provider)

how can i be sure the linked table is being used.

I have been to the migration forums on mysql and the odbc forums, but i think i am hindered
by my lack of what is actually going on here.

if anybody in the community has any experience with access/vba or anything odbc related
let me know. i'm prolly missing a few things. so let me know if you want more info


 Johnny