At 16:56 06/03/2001 -0500, [EMAIL PROTECTED] wrote:
Hi,
If you are using Access as front end, when you build the update
or append query you can use an expression like:
My Name: [TableName]![ColumnName]
You can do this manually or using the builder query of Access.
Regards,
Miguel
>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
__ ___ ________ __
/ |/ /_ __/ __/ __ \/ / http://www.mysql.com/
/ /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano <[EMAIL PROTECTED]>
/_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil
<___/ Development Team
---------------------------------------------------------------------
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
