Me again...

I have another question. I am pulling some data from an Oracle database. I linked the tables to Access Manually which worked great. My question is how do I update these links so my Access tables have all of the most up-to-date data? I only need them to be updated once a day. Should I just refresh them manually or can I run a script or macro to do this?

I also want to know how to run scripts housed in Oracle from Access.

Any thoughts?

Thanks, Justine

Only refresh the links if they need to be refreshed. If a table or view changes, do a refresh of the links, otherwise, do not refresh.



Sal

Thanks for the response. I definitely need to refresh the link every day. The data changes and I need to alert users of specific changes. Is there a way I can refresh in a Macro or with vba rather than doing it manually using the Linked Table Manager?

If the only thing changing is the data, you do not need to refresh the link. A linked table shows all changes as you make them. If, for instance, you add a field to a view, then you would need to refresh the link for only that view.





Sal