synchronizing two ms access databases

Has no one really ever dealt with this or is Microsoft incapable of providing any decent capabilities for its programs? I''d really appreciate some help as this could actually cost me my job...

Crispy

use SQL

By synchronise do you just mean make the data in db1 == to the data in db2?

-- Wait, wait, wait....who''s Nambla Fett?

quote:

---

Original post by krez
use SQL

---

MS Access uses SQL as its basis.

quote:

---

Original post by BASSOFeeSH
By synchronise do you just mean make the data in db1 == to the data in db2?

---

yup - basically copy everything that''s new (non-structural) in db1 into db2 which may already have some entries (data) in it. the problem comes with the primary keys and references to them from other tables (relationships) - so copying the table contents via clipboard won''t work either on top of being a menial nuisance...


Crispy

quote:

---

Original post by Crispy
MS Access uses SQL as its basis.

---

and you should use SQL to copy your data between tables...
i.e., create a new "Query" and do something like this (simplified of course):

INSERT INTO [ c:\PathOfDatabase\database.mdb ].tblPutItHere
SELECT *
FROM tblGetItFromHere;