Access 2007 and MySQL Password function

[Crilen007]

I'm trying to get access to send Queries to MySQL in the new ACcess 2007 (which is different than the other ones once again, yay)


I used the direct ODBC connect method in previous versions of access but this one tells me it wont support it.

How can I get access to send the password function to mysql now?

Any ideas or sites that would have examples for this?

Thanks.

PS: It's good to be back, been like a year since I've been here.