question about linked table feature on access 2000

[pheonix1t]

hello,
I'm wondering if I can do something on access using the linked table
feature.

I'd like to create a mirror of a unix database (we have odbc access to
it). It's about 800MB.

I'd like to have a copy of database exactly 1 day old so we can see
how data is changing from previous day.

I want access to refresh tables only when we tell it to. Otherwise it
should keep the data from the last refresh.

Is this possible with access?

Thanks,

Oskar

[Tom van Stiphout]

On 7 May 2007 19:41:34 -0700, "ph*******@gmail.com"
<ph*******@gmail.comwrote:

"Refresh tables" means something specific in Access, and what you want
to do isn't it,.
Rather you could write some code to cycle over all tables, and run a
MakeTable statement for each table (if tables do not yet exist), or
run an Append query.

-Tom.

>hello,
I'm wondering if I can do something on access using the linked table
feature.

I'd like to create a mirror of a unix database (we have odbc access to
it). It's about 800MB.

I'd like to have a copy of database exactly 1 day old so we can see
how data is changing from previous day.

I want access to refresh tables only when we tell it to. Otherwise it
should keep the data from the last refresh.

Is this possible with access?

Thanks,

Oskar