David Emerson
davide at dalyn.co.nz
Thu Mar 27 20:07:36 CST 2003
John, I have had experiences with two replicated databases. One on a local lan, the other replicating via dial up network. Both in A97. According to Arthur, A2K (Jet 4) is more stable. My main experience on the lan was that the database corrupted frequently. All the research I could find pinned it down to a faulty network but I am not a network techo so I had to leave it to the IT department. Eventually we ended up converting to SQL. However, the corruptions were due to the BE being on a server. In your case if the BE is on the local machines (and the users don't need up to date information) then indirect synchronization should work fine (as opposed to direct synchronization - fewer opportunities for corruption across the network. Regards David Emerson DALYN Software Ltd 25b Cunliffe St, Johnsonville Wellington, New Zealand Ph/Fax (877) 456-1205 At 27/03/2003, you wrote: >I need any info / experiences anyone can share re replication. My insurance >client has a functioning database now that is SLOOOOOooooow. They came from >a "flat file" where they had basically a single table with 125+ fields to a >fully relational FE/BE with of course much expanded functionality - and of >course the speed isn't anywhere close to the same as the old. No matter how >you explain, the user doesn't know what goes on behind the scenes, and >doesn't care. All they know is that it is slower. Plus they are adding >more employees (up to about 25 now from under 20 when I started the >project - and still climbing). > >They will probably go to SQl Server someday but now is not the time (money). >I have been discussing options with them and explained to the tech contact >the idea behind replication. He has been running a FE / BE development copy >of the db on his desktop and it is about twice as fast. Therefore he thinks >that replication might solve their speed issues for the short term (for a >year or so) until such time as they could make the move to SQL Server. > >So I need info. I have done replication one time, just on my own system, >just to see how it worked - and that was a long time ago. So I need to >start a thread with anyone who has current experience on how to set it up, >what is involved, any good reference material to read, would it work to >merge the BE/FE back in and also replicate design changes, etc. > >Anyone with info out there? > >Thanks, > >John W. Colby >Colby Consulting >www.ColbyConsulting.com > >---------------------------------------------------- >Is email taking over your day? Manage your time with eMailBoss. >Try it free! http://www.eMailBoss.com > > >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com