Re: Merge 2 Db's

Tech-Archive recommends: Fix windows errors by optimizing your registry

stef569 wrote:
Hi,

I'm a bit lost in the 'Importing / Linking / Replication' world

What I want to do seems very easy:

I have 2 db's, on 2 different locations with exact the same db, not connected
to any network
db is not split.

db 1 enters travels + details (multiple tables +-20)
db 2 enters the incomes for the travels (only 1 table:Invoices)

When they meet the following happens:
db 1 is loaded on a usb drive

db 2 imports: all new travels, changed travels, new details, changed details
from db1
and
db 2 exports: all new Invoices

according to:
http://www.accessmonster.com/Uwe/Forum.aspx/access-replication/2237/Replication-over-the-internet-ftp-vpn
can I not use replication because i use an usb drive to connect the db's.

I'm currently working with linked tables in db2 and Inserting, updating from
there. But I have problems finding out if a row has been changed and I realy
don't want to create something that already is avaible

What i realy need is syncronization between 2 tables and syncronization
between 2 db's except this one table...

What strategy would you advise, as I said at the start I'm a bit lost ;)

Thanks Stef

I now understand that I can't use a usb to walk around with the replica's. So
I should forget the replica idee because my db's are not direct connected in
any way?
I should create an extra field when a row is edited for all my tables and
work from there?

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Merge 2 Dbs
    ... I'm a bit lost in the 'Importing / Linking / Replication' world ... all new travels, changed travels, new details, changed details ... can I not use replication because i use an usb drive to connect the db's. ... as I said at the start I'm a bit lost;) ...
    (microsoft.public.access.externaldata)
  • Re: Removed Domain Controller Replication Issues
    ... Yeah you are correct, my fault, on the Lost and Found. ... > untombstoned objects on the offending DCs by checking them against healthy ... >> contact with replication will end up with tombstoned objects. ... >>> I have 6 domain controllers at head office with approx 400 domain ...
    (microsoft.public.win2000.active_directory)
  • Re: Bulk of orphan object in lost & found container.
    ... replication issues which i sorted out.Now everywhr replication is happening ... We have 3 different domains and all our Lost and found containers are empty, ... 4000 orphan objects is ... The lostAndFound container is where objects that are orphaned during ...
    (microsoft.public.windows.server.active_directory)
  • Re: Bulk of orphan object in lost & found container.
    ... Also can be if replication is not correct running that some other objects that are needed will be deleted. ... We have 3 different domains and all our Lost and found containers are empty, the domain is setup 6 years ago. ... 4000 orphan objects is ... The lostAndFound container is where objects that are orphaned during ...
    (microsoft.public.windows.server.active_directory)
  • Modifications to replicated DB
    ... replaced objects in the replication master by deleting and then importing the ... a replica) and when I open it on a free standing PC it opens without ...
    (microsoft.public.access.setupconfig)