Got it delevered today And after reading half of the first chaper it's Payed for itself in that it told me where I could find a tool to remove a replica and convert it back to a normal DB Which is something I've been trying to do for ages but doing it the way MSOFT Say seems to leave things behind which I found slowed the whole system down but this tool sorts all that and now I have a db of near on 3 mill records running like a dream.

thanks to whoever pointed me in the direction of this book I'm sure it will keep paying for itslef.

mick

Before unreplicating an MDB, you might want to synchronize with all the replicas to make sure you have all the data (though if you're contemplating unreplicating, you're unlikely to have been using replication recently).

Microsoft provides instructions on how to do this manually:

* Access 2002 instructions (should work for A2003, too)
http://support.microsoft.com/kb/290052/

* Access 2000 instructions
http://support.microsoft.com/kb/208394/

* Access 97 instructions
http://support.microsoft.com/kb/153526/

The A97 article also has a download link for the Jet 3.5 unreplication wizard:
http://support.microsoft.com/kb/168398/

There are two other tools that also work for Jet 4 databases:

* Michael Kaplan's TSI Un-Replicator Add-in
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=7#7

* Graham Search's Unreplicate Utility
http://www.pacificdb.com.au/MVP/Code/UnReplicate.htm

The latter has code, and you could perhaps learn something by reviewing the code, but I've never actually used the latter (I've hardly ever unreplicated anything).

--
David W. Fenton
David Fenton Associates
http://dfenton.com/DFA/