odbc refresh

[dforkin]

I use access to view and odbc connection to mysql database.

When I change fields within a table, I can reflect the changes in access by using the linked table manager and updating the information.

However, this only seems to work for fields.

What can I do to refresh my view to show new tables or tables that have been dropped?

any suggestions welcome.

 

[lameid]

You could try programmatically opening each of your links to ensure they are still good but as for adding tables/views that are new, I think you have to simply know to do it. I would check to see if mySql can dump a text file with the table information etc. in it. Then you could link to the text file and check things based on that link.