Running a Query Append in Access 97 with a linked MySQL table

2001-03-07 Thread Kewlbloke
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

Re: Running a Query Append in Access 97 with a linked MySQL table

2001-03-07 Thread Miguel Angel Solórzano
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