PC Review


Reply
Thread Tools Rate Thread

Databse synchronisation

 
 
John
Guest
Posts: n/a
 
      18th Jul 2007
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



 
Reply With Quote
 
 
 
 
David W. Fenton
Guest
Posts: n/a
 
      18th Jul 2007
"John" <(E-Mail Removed)> wrote in
news:FE09E18D-B219-41D9-AE90-(E-Mail Removed):

> 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.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
 
Reply With Quote
 
Pat Hartman \(MVP\)
Guest
Posts: n/a
 
      18th Jul 2007
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" <(E-Mail Removed)> wrote in message
news:FE09E18D-B219-41D9-AE90-(E-Mail Removed)...
> 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
>
>
>



 
Reply With Quote
 
John
Guest
Posts: n/a
 
      18th Jul 2007
Perfect Thanks for the help.

John


"John" <(E-Mail Removed)> wrote in message
news:FE09E18D-B219-41D9-AE90-(E-Mail Removed)...
> 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
>
>
>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
i have access databse .whci his a dictionary databse mit Microsoft Access Security 2 9th Sep 2006 08:59 AM
Help to create databse GabrielG Microsoft Access Queries 1 25th May 2004 05:29 AM
Synchronisation hangs during save of synchronisation log. Dirk Microsoft Outlook 0 10th Feb 2004 07:46 PM
Defragging SQL Databse Ashwini Khanna Microsoft Windows 2000 Advanced Server 0 28th Jan 2004 06:13 AM
Databse Connectivity Ashish Nanda Microsoft Access Queries 0 14th Aug 2003 08:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:09 PM.