By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,139 Members | 1,247 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,139 IT Pros & Developers. It's quick & easy.

Advice on Synchronization

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.