473,320 Members | 2,012 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Advice on Synchronization

Hi

I wish to create a synchronized database to give to each of our 150
travelling sales reps. They would fill out forms on their laptops, on
the move, and then when they dial up (56k) at the end of the day to
get their email, they would synchronize the database.

Sounds ok? Well I would like also to be able to sychronize changes to
Forms/Reports/Macros etc. Now, I would quite like not to have a
seperate database for each also.

I have seen a few postings warning people to split data and not
synchronize the front-end, but most of these seem to apply to earlier
versions of access. We are using version 2002, and I would imagine
(perhaps foolishly) that by now, it works ok.

Has anyone tried similar, and can they give me any tips?

Thanks,
Mark.
Nov 12 '05 #1
1 2164
I think that database replication is the answer to the data sync issue.
I can't see why would you want to sync the non-data objects (forms). Do
your reps also develop the database? Then you should really have a
version control server for them (the program that manages code and
design chages for forms, reports, etc.).

Mark Roberts wrote:

Hi

I wish to create a synchronized database to give to each of our 150
travelling sales reps. They would fill out forms on their laptops, on
the move, and then when they dial up (56k) at the end of the day to
get their email, they would synchronize the database.

Sounds ok? Well I would like also to be able to sychronize changes to
Forms/Reports/Macros etc. Now, I would quite like not to have a
seperate database for each also.

I have seen a few postings warning people to split data and not
synchronize the front-end, but most of these seem to apply to earlier
versions of access. We are using version 2002, and I would imagine
(perhaps foolishly) that by now, it works ok.

Has anyone tried similar, and can they give me any tips?

Thanks,
Mark.

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: user451 | last post by:
As the most Access-savvy person in my office, I have been handed the task of proposing a nationwide expansion of a project that I have developed in Access. A brief overview: Right now, about 25...
3
by: dlesandrini | last post by:
I need advice about my decision to go with Replication in general. This post was placed on the Microsoft Replication newsgroup, but I really value the feedback that comes from this group as well. ...
3
by: Robert W. | last post by:
Following the advice of several of you on here (Thank You All!) I've successfully constructed a Model-View-Controller (MVC) implementation. It works great! Now, whenever the user manipulates one...
4
by: scott | last post by:
hi all, Thx to any one that can offer me help, it will be much appreciated. iv got a multithreaded program and need to use thread synchronization. The synchronization does not have to...
5
by: Kevin Carne | last post by:
First, Merry Christmas. I have been doing intensive Java programming for two years in school (no choice on the language), but now I need to return to C++ because my resume is filled with it both in...
0
by: Rod | last post by:
I orginally posted this to microsoft.public.sqlserver.ce but had not received any responses. I have a CF.NET application (C#) with a SqlCE database. We had originally planned to use SQL...
4
by: Ben Fidge | last post by:
My application uses a singleton static class for writing entries to a log file. The location and name of the log-file is read from web.config each time an entry is written, but has the current date...
12
by: emma_middlebrook | last post by:
Hi Say you had N threads doing some jobs (not from a shared queue or anything like that, they each know how to do their own set of jobs in a self-contained way). How can you coordinate them so...
0
by: lbrtchx | last post by:
Say you need to serve the same Web content from a number of IP address, which you need to keep out there with high availability requirements ~ I think Web Services would be a good candidate for...
0
by: sundman.anders | last post by:
Hi all! I have a question about thread synchronization and c++ streams (iostreams, stringstreams, etc). When optimizing a program for a multicore processor I found that stringstream was causing...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.