How to copy data from a database to another automatically?

[longmatch]

Dear All:
I have one Access database table on our web server need to be udpated based upon another Access database table. I would like to make this process automatically. How to make it work?


Haijun

 

[crpjaviman]

Here is the thread that I started with almost the very same question.

thread705-349301

To make it automatic, you need to create a hidden form with a timer function, run the code in the thread (with mods to your db) and will update the data.

Within the thread, you will find reference to a different thread that helped me out greatly.

Let me know how it works.

Thanks,
crpjaviman