Syncronization / Replication

[mjoerge]

I'm trying to find out how to create a replica of an Access database where the design master has linked tables to an Oracle database via ODBC.

The replica is to be destributed to a set of users which will be working off-line. When on-line they should be able to syncronize the data with the master, which then through the linked tables updates the Oracle database.

Is it somehow possible to make the tables in the replica local while the design master has liked tables, or is there another way to do this?

 

[MrP]

i might be a buit dumb here but i dont quite understand what you are trying to do.

i take it you are distributing front ends to your users using the replication.

are they then updating
1. a back end access database in your head office which then updates an oracle database

2. the oracle database

3. a local data file which your then wanting to update the oracle database with

4. something completly different

sorry if this dosent make too much sense, but its too hot today!!

toodles