By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,188 Members | 844 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,188 IT Pros & Developers. It's quick & easy.

question about linked table feature on access 2000

P: n/a
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

May 8 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
May 8 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.