Use Macro to update Linked Tables?

[SRAB]

I create reports from an Access Db that I've created.
I have many sources of data that I gather into my DB.
I have several linked tables.
As part of my monthly update process, I need to update those linked tables to refresh the data that I am reporting on.
I am trying to automate as much as I can using macros.
Is there a way to update a linked table via a macro?

thanks,
Gail

 

[Ziggy1]

what type of linked tables are you using?? Excel/ODBC (or other)? What is different about the tables that you have to relink? Are the file names different?

 

[SRAB]

what type of linked tables are you using?? Excel/ODBC (or other)? What is different about the tables that you have to relink? Are the file names different?

I have a remote Access table, and a local spreadsheet.
End users make updates in the remote Access table and I need to relink to capture those updates. The spreadsheet contains rep/manager information that I manage manually because it's the easiest way to do it.

Why would the type of linked table matter for executing a relink in a macro?

 

[Ziggy1]

well I was trying to understand why you need to execute a relink? as soon as you open the table or the spreadsheet you will see the changes (if they were actually linked. the way you describe it, they are not directly linked.

 

[SRAB]

well I was trying to understand why you need to execute a relink? as soon as you open the table or the spreadsheet you will see the changes (if they were actually linked. the way you describe it, they are not directly linked.

Maybe I misunderstand how a link table functions. I assumed that the data would remain stagnent until I executed the update. But from what you are saying linking is not a point in time picture, it's looking at the table live. I can make a couple simple tests to see if that's true.

thanks for the information.

 

[gemma-the-husky]

Links to tables are active, not a "snapshot". The only time you would need to relink is if there was some physical disk issue, or if for instance you renamed or moved the excel spreadsheet. Note that copying the Access DBS to another m/c is OK, as long as the folder mapping and any mapped drives remain consistent.

I don't know whether links can be managed through macros. In code you need to process properties of the tabledefs collection, and it is quite easy once you know how.