E
everymn
Hi,
I have the following situation, I have a linked MySQL table which is
populated, and a blank Access table whose schema matches the MySQL
table as closely as possible. I'm trying to write a query to copy the
data from MySQL table to Access. I know that there is no problem with
the ODBC connection as I can open the table in access and read it.
The MySQL table is t1
The Access table is InsertSource
The query is written as follows:
UPDATE InsertSource INNER JOIN t1 ON InsertSource.f1 = t1.f1 SET
InsertSource.f2 = [t1].[f2], InsertSource.f3 = [ti].[f3],
InsertSource.f4 = [t1].[f4], InsertSource.f5 = [t1].[f5] and so on up
to about 50 fields.
However when I run this a prompt dialog pops up asking me for to enter
parameter value [t1].[f3]. Why would it be asking me for this rather
than copying it right from the MySQL table, and why if it was going to
fail like this would the failure not occur on f2? However perhaps the
failure does occur on f2 because after looking at the table, no data
has been written at all to f2 or any other field.
Thank You
I have the following situation, I have a linked MySQL table which is
populated, and a blank Access table whose schema matches the MySQL
table as closely as possible. I'm trying to write a query to copy the
data from MySQL table to Access. I know that there is no problem with
the ODBC connection as I can open the table in access and read it.
The MySQL table is t1
The Access table is InsertSource
The query is written as follows:
UPDATE InsertSource INNER JOIN t1 ON InsertSource.f1 = t1.f1 SET
InsertSource.f2 = [t1].[f2], InsertSource.f3 = [ti].[f3],
InsertSource.f4 = [t1].[f4], InsertSource.f5 = [t1].[f5] and so on up
to about 50 fields.
However when I run this a prompt dialog pops up asking me for to enter
parameter value [t1].[f3]. Why would it be asking me for this rather
than copying it right from the MySQL table, and why if it was going to
fail like this would the failure not occur on f2? However perhaps the
failure does occur on f2 because after looking at the table, no data
has been written at all to f2 or any other field.
Thank You