Synkronisering af databaser

Hi Jan and  a happy new year.
I dont think you can use an IP address for linking your tables into your local database, but you should be able to map this as a drive letter.
The question of synchronizing two tables has been up before. It isnt something I have played around with very much but it should be possible to do this using replication, although I am sure that this should be taken into concideration BEFORE making the database. Ther is always the problem of primary key conflicts which replication gets arounbd by using GUIDS.

Can you give a little more information as to what you ant to synchronize so we have a nidea as to how complec your problem is

mvh
Terry

som information on replication here

http://support.microsoft.com/default.aspx?scid=kb;en-us;164553
http://support.microsoft.com/default.aspx?scid=kb;en-us;139485

Hi Terry

Har to databaser som er bygget op identisk, men har forskelligt data input. Dem vil jeg gerne have synkroniseret.

what about your primary keys (autonumbers)?  You will very likely have the same values in both databases! Before you can synchorinize two tables with identical data then its necessary to have a UNIQUE primary key and its very likley taht you dont if you are using autonumers as your primary key as the same value will VERY likley exist in BOTH tables!

I nogle af tabbelerne har jeg autonumbers andre ikke

It it possible to alter these to GUIDs? If you look in the properties of an autonumber field you can choose replication ID as the field size. This is a GUID and is supposed to be unique (GLOBAL).
You also need to make sure that if the original autonumer values are used as foreign keys (related tables) then they have to be changed there too!

So it may be a bit of a job just preparing your dB for replication.

Alternativt kunne du have tabeller, kun til input. Når du synkroniserer, tømmer du input fra inputtabellerne over i "hovedtabellerne" og flytter "hovedtabellerne over i den anden database, hvor du gør det samme... Du må nok påregne en smule redesign, som terry vist også indikerer.