update Linked Table Definitions after the table has columns added/Altered

[sesproul]

Hello,



I have been fighting this for months since I started using ACCESS.

In MYSQL, I alter a table definintion by adding columns, or altering column definitions.

How Do I get Access to recognize the change so that I do not need to recreate the queries that rely on the table after deleting the tables and relinking which I do now..


Thanks

Steve

[sesproul]

Does anyone have any ideas?

[sesproul]

Has anyone out there even experienced this? Does anyone have a similar problem?


Steve

[sesproul]

http://office.microsoft.com/en-us/ac...876231033.aspx


but does this mean every Query based on deleted table needs to be recreated?