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

 

[Guest]

You can either create mirror copies of your tables in the Unix database or,
if you want them in mdb format, you could create an Access database with
tables structured like the Unix tables.

In either case, you will need queries to append the previous day's records
to the "mirror" database.

 

[pheonix1t]

You can either create mirror copies of your tables in the Unix database or,
if you want them in mdb format, you could create an Access database with
tables structured like the Unix tables.

In either case, you will need queries to append the previous day's records
to the "mirror" database.

Hi Dave,
I've tried the option where it copies the tables (I chose select all)
from the unix db via odbc, it starts to work but then it gets stuck on
some tables. It gives an error that the format was too small or
something like this. I'm also looking at doing a mirror on the unix
machine via mysql. I'm trying to see if access will be easier but it
so far it's got its own set of challenges.

So, doing a query and scheduling it would create the mirror on
access. I didn't think of that!

How can I get past the errors access is giving me via odbc by trying
to copy? Should i try linking instead and then copying (this would be
copying from access instead of odbc)?
The copying takes a while since it's about 800mb of data.
Thank you,

Oskar

 

[Guest]

Since there are differences in different databases in how the table, field,
indexes, and other properties are defined, it may be necessary to create the
table definitions by hand for the Access database.