update data

R

Rik

I get my data for my db from a sql server and use odbc to get it.
Some times the server isn't available so i use a imported version of the
table too. I update the linked and imported table with a delete query and
append query. The first query deletes all data from the table, the second
appends it back in.
Problem:
If i run these query's when the server isn't available my table is empty.
Q:
What do i have to change to make it better?
 
R

Robert_DubYa

Hi Rik,

Have you tried using the linked table manager? You can get at this by right
clicking on any table. When the manager pops up check the check box next to
the table you would like to change the link for. Next check the box in the
lower left corner that says "always prompt for new location". Click okay,
and find the table your new table. This is the best way I have found to
switch to other data locations. It is easy and fast, but the tables must be
the same.

Regards,
RW
 
R

Robert_DubYa

Sorry, after re-reading your question my first response was not correct. The
best way to do this is just create a new link or import table with the same
name as the one you want to replace.
 
R

Rik

Okay but i try to create a db that everybody in the office can use. This
means that users will have to update the db with one button.
My question is: How can i do this update procedure as an automated process?

Process:
Check if db needs updating and if the server is available
Import only the new data
Keep a log of every update
 
Top