Re: Need Help with linking tables from Access to MySQL

[Jay Alverson]

Boy it's been a while, let's see. Make a backup of your mdb file first.

Then go to the form, right click on it and choose Design View.

Once the form opens in Design View, right click on the top bar (title bar)
of the form and choose PROPERTIES.

On the DATA tab the first option should be RECORD SOURCE which is the name
of the table that the form is using. Change that to the MYSQL table and see
what happens. You might have to edit some of the MySQL data (or add an extra
row) so you can tell the difference.

You might be able to write an Access Basic program to change others once
you get part this down, so you don't have to do it all by hand.

I've linked tables to MySQL using Access Basic, but never had to bother with
forms.

>

Thanks, Jay