Databse synchronisation

[John]

Hi,
I have a database on a server which is used by only 2 operators. the
opperators work away using laptops and enter new records.
When they get back to the office, can they synchronise their laptops with
the main database and update records in both directions?

Any help here would be most helpful.

Regards

John

 

[David W. Fenton]

I have a database on a server which is used by only 2 operators.
the opperators work away using laptops and enter new records.
When they get back to the office, can they synchronise their
laptops with the main database and update records in both
directions?

Yes. Jet replication is designed for just that scenario.

However, before your replicate, first split the database into front
end (forms/queries/reports/etc.) and back end (data tables only).
You will then replicate *only* the back end.

Jet replication is not viable for synching changes in a front end of
any kind, so if your users will be wanting to merge changes to
forms/queries/reports, etc., then replication is not a viable
option.

 

[Pat Hartman \(MVP\)]

Replication is the feature you want to research. Your question is not
specific enough to be answered except in general. Once you read the help
entry and any KB articles that are relevant, you can post back with specific
questions.

 

[John]

Perfect Thanks for the help.

John