Update Query

A

Appache

Hello,
I have an access database on a server and I also have another access
database on another server which is the same but not with updated data.
Whenever web users filled out a form on the webside this data goes to first
access database and I want to run a query everyday on the second database
which just will bring the data since I last time run the query which will be
one day before just because I will run it everyday but weekends.

My question is how can I do that? What kind of query should I use and What
do I need? (User name and password for servers?) Can I do it with Ms Access
or I need to use something else?
 
A

Appache

I understood what you want to do so far. However I still have a question.
When somebody fills out athe form on the website the data goes to access db
with a time stamp which is one of the fields in the table and I want to get
data since the last time query is run. How can I find out when I run the
query last time?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top