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

sesproul · #1 01-19-2010, 06:10 AM

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 · #2 01-19-2010, 11:50 AM

Does anyone have any ideas?

sesproul · #3 01-21-2010, 08:40 AM

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

Steve

sesproul · #4 01-21-2010, 05:10 PM

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

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linked Table To SQL Server?	snkscore	Import/Export Data	3	12-09-2009 03:36 AM
Date columns linked to AS400 table not formatted as dates	vessellcpa	Access	3	11-19-2009 06:15 PM
How to make query based on external access DB's table and the table in linked table?	aquaraider	Queries	2	10-27-2009 05:09 AM
Update a field in a table based upon information in anther table?	sabrown	Database Design	4	09-03-2009 12:01 PM
Linked Table Manager	driccardi	Access	4	02-15-2006 08:47 AM