Solved: Autmatically Refresh Tables in Access

[asingh]

Hi,
Is it possible to automatically refresh the linked tables I have attached to an access data base. I would prefer a method where the linked tables are "read" by the module dynamically and are not hard coded. Would it be possible to read the tables..[back end files..txt format] that reside in the parent folder..where the main ACCESS.MDB data is residing, and then update them onto my same access data base. Basically I want to automate the linked table manager operation...thanks in advance


asingh

[OBP]

asingh as far as I know the tables are "dynamically" linked and are therefore automatically refreshed.

[Imdabaum]

Do you mean if you move the Front end and back end it asks you to find the back end and refreshes them for you?

[asingh]

yups..something like that....but now via the linked table manager..a more visual..interface..!

[mattj]

Here ya go:
http://www.mvps.org/access/tables/tbl0009.htm

[asingh]

Wow..the code looks good..thanks a lot....!..Will give it a try.

regards,

asingh

[mattj]

Glad I could help!