Re-Link 1 Table in Multiple Databases via VBA

[jo15765]

I have found a few ways to re-link tables via VBA, but is there a way to create a database, and then create an array in VBA of workbooks to open, then once the workbook is opened run the re-link code, close the db and move onto the next database?

[orange]

I found quite a few links based on this google search parm

opening multiple msaccess databases with vba

Good luck.

[jo15765]

I found quite a few links based on this google search parm



Good luck.

Oh no, is this not a feasible solution?

[orange]

Workbooks? Access

Perhaps you should tell us clearly WHAT you are trying to do.

[jo15765]

I have found a few ways to re-link tables via VBA, but is there a way to create a database, and then create an array in VBA of workbooks to open, then once the workbook is opened run the re-link code, close the db and move onto the next database?

I have about 200 access databases with a linked SQL Table that I need the table link refreshed. So instead of manually doing each and every database I was going to try to VBA it somehow..

[jo15765]

I have my code to import the SQL table, and I have my code to cycle the databases, but the snippet I am using is:

Dim tdf As DAO.TableDef

Set tdf = Currentdb.CreateTableDef

But I want to (this is excel terms I know) change focus from the db I am running this code in, to the db I just opened to create the table in. Is this possible?