Hello
I have uploaded a table from Access 97 to the MySQL database and apart from
changing the name from "Mailing List" to " Mailing_List" it appears fine. Now
that I am putting data into the linked MySQL table in a "live " environment I
need the MySQL table to update the Access records and vica versa.
When I try either way to run a Query Append I get as far as the fields and
when I try to run the append the message says that the field "web_site" has
an incorrect name. In my original table called the field "web sites" and
MySQL has underscored it, but I am calling the field the same as MySQL calls
it and it still wont recognise it. It does not work the other way either,
from Access to the MySQL linked table, whatever I call the "web site" column
it just has a problem with that column. Even if I delete the column it still
wont append and update the data.
Any ideas?
Peter Worthington
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
