Re: Request Recomendation
From: Jack MacDonald (jackMACmacdonald_at_telus.net)
Date: 02/13/05
- Next message: Kos Semonski: "Re: Request Recomendation"
- Previous message: Kos Semonski: "Request Recomendation"
- In reply to: Kos Semonski: "Request Recomendation"
- Next in thread: Kos Semonski: "Re: Request Recomendation"
- Reply: Kos Semonski: "Re: Request Recomendation"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 13 Feb 2005 00:01:45 GMT
The best sources of info that I am aware of are:
www.trigeminal.com
Access XX Developers Handbook (version number varies) from Sybex
Some tips that I have learned:
- always split your database into frontend and backend components
- never replicate the frontend -- backend ONLY (tables!!)
- never move a replica once it has been created unless using
Replication manager
- never attempt to use email, floppy disk, CD, USB drive, etc etc to
move a replica from one location to another.
- never use the Design Master for data entry
- never include your Design Master in a scheduled synchronization.
Always sync it manually
- never sync over a WAN unless using Indirect Synchronization as
supported by Replication Manager.
- developers write code instead of macros
HTH
On Sat, 12 Feb 2005 12:08:38 GMT, Kos Semonski <me@you.com> wrote:
> Hi,
>
>I have need to use the replication feature of Access 2000. Generally
>speaking, I understand the concept of replication, and I have successfully
>played a bit to see it work, create errors and evaluate the results, resolve
>errors, etc.
>
>>From there, I've been searching for a reference source that will really get
>into the nuts and bolts of replication on Access. I've spend a few hours at
>multiple bookstores, but each book I look at seems to have very limited
>information about replication. They usually have the "click on this menu,
>select that to create a replica, blah, blah, blah....", but there is really
>no "big" chapter that I have found that would strike me as the "mother lode"
>of info.
>
>I need a recommendation on an article, book, or other source that I can study
>to really understand the ins and outs of replication using MS Access.
>Additionally, I will require some automation for my replication project, and
>I have discovered that the DoCommand function and SynchronizeNow does not
>seem to play well together as a macro. I've looked at some of the solutions
>here that reference VB and Modules, but because I'm a little challenged with
>VB, (I've always been able to macro my way out of an automation issue) I've
>been unsuccessful with actually getting the code listed in the threads to
>actually work.
>
>Sorry for the long winded message, but I'm hoping that someone can point me
>in the right direction.
>
>
>TIA,
>
>
>Kos
>Mgr. Sales Operations - Data Analysis
>SBC Directory Operations
>
**********************
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
- Next message: Kos Semonski: "Re: Request Recomendation"
- Previous message: Kos Semonski: "Request Recomendation"
- In reply to: Kos Semonski: "Request Recomendation"
- Next in thread: Kos Semonski: "Re: Request Recomendation"
- Reply: Kos Semonski: "Re: Request Recomendation"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
