"McDal" <McDal[ at ]discussions.microsoft.com> wrote in
news:459A08CD-51A8-480A-B842-FA9BF0E638F5[ at ]microsoft.com:
[Quoted Text] > I'm just an amature programmer that wrote an Access 2003 Database
> program for my company to track inspections at customer's sites.
> We want to deploy it by keeping the master on the server in the
> office and having replicas on about 10 laptops. I understand I
> need to split the data base into the front end and backend. I can
> do that without trouble. But what about making it secured, I
> think the toolbar in access under Tools shows it as "making an
> mdb"? Do I need to do that?
Securing a replicated database is no different from securing an
unreplicated one. It's a complicated subject, and outside the scope
of this newsgroup. You might find information on this by searching
Google Groups for the newsgroup comp.databases.ms-access. And you
can post there -- you'll get good annswers.
> Anyway, I'm having trouble through all my research I've been doing
> on this subject, is to figure out how to truly automatically
> syncronize all the laptop changes my techs make on a daily basis
> with the one in the office. And there are changes being made on
> the office copy too. So that everybody has the most current
> up-to-date version of the database everyday when they go to the
> jobsites, because John Doe may have done 1 inspection at a
> customer's site on monday, but he called out sick and we need to
> send Jim Doe and he needs what JOhn Doe did yesterday. Anyway,
> that's my stumpling block...how do you syncronize automatically?
> Do I need to purchase additional software to do this? Or is it
> some VB code I need to write to perform this task?
The easiest way to do that is to run code at startup and shutdown of
the app. That will check to see if the laptop is connected to the
LAN, and if so, will synch with the hub on the server (don't use the
design master either for editing or as the synchronization hub).
To execute code on startup, you have two choices:
1. an Autexec macro, OR
2. a startup form (visible or not).
I would do the latter, since then you can run the same synch code in
the form's OnLoad and in its OnUnLoad events.
> Too many articles are too technical for me...I need something step
> by step for deployment written for "dummies". Any help would be
> greatly appreciated.
There is no such resource because not enough people are using Jet
replication. And people don't use it because there's insufficient
documentation to make it easy. Chicken and egg.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
|