Updating Linked Tables

[Lil_Vegemite]

Hello Everyone,

I'm new to writing code in Access, but I have dabbled a little with VBA in Excel.

I have a db that has linked Excel files as the Tables. What I would like to be able to do is:

When the database is opened, have a messagebox displayed that asks if the user wishes to have the Excel files updated before working with the database. If the user chooses Yes, then the appropriate Excel files are opened, updated and closed before any work on the database commences.

Is this possible to achieve? If it is, could someone point me in the right direction as to where I can find the info needed to accomplish this. What I may be looking for is something like the OnOpen property that applies to the database as a whole.

Thank you to all who can offer any assistance.
Lil_Vegemite

 

[Banaticus]

What sort of updating are you looking to do?

And, if you're using Access to open and update the Excel sheet, why not use Access to update an Access table and base the form off that?

 

[Lil_Vegemite]

Thanks for the reply Banaticus.

The way that I have this set up is that the Excel files that I use as Tables are dependant on other files linked to them. So it is possible that the Excel files that I use as Tables do not have the latest updated data. The reason that I have done it this way is because of the complex calculations that are required and I believe that it was easier to manipulate this data in Excel. So ultimately the updating is simply updating the links from dependant files.

Hoping that this makes some sense.
Lil_Vegemite