Update Query

[Guest]

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?

 

[Smartin]

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?

Let's say database "A" is the one you want to update and "B" is the one
with the new information.

Assuming you can log in and see both servers' file systems, you could
create a link in A pointing to the table(s) in B you want to get
information from.

Then you simply write an INSERT (append) query to add to the table(s) in
A. How you go about this depends on how the information is organized in
the table(s).

Does this give you a start?

 

[Guest]

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?

 

[Smartin]

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?

It might be as easy as limiting the insert query to select records in
"B" where the time stamp exceeds the MAX(TimeStamp) from your "A" table.

Another option might be to store the times when you run the query in a
separate table on the A side. Then the same concept as above applies. If
you like this idea, you could automate populating the time stamp table
by putting the update process in a macro that calls two queries. The
first query does A->B stuff, the second inserts a new row in time stamp
with the value of Now().