Auto-Update

Hello,

I asked this question in the Access Forum and never got a response. I figure I would give this Forum a chance to see if any of you had any ideas.


Hello - I hope that someone can lead me in the right direction or have some sample code I can use for my question.

What I am trying to accomplish is update (on a time interval) an Access Database on a server from another Access Database residing on my network. The database on the Server will be supplying data to an ASP page. Can you write a macro/code in the Database residing on the server that goes out and grabs the database from the network:

Server Database:

1. On a timed interval go and copy a table from another database (network db)
2. Copy and overwrite the table into the database residing on the server, which will be accessed by the ASP page.

Thanks,

Jay

There is nothing in asp itself that allows you to schedule something. Perhaps some task scheduler entry that calls your asp page on a schedule?