> I have multiple users who need to utilize one access database,
> without the opportunity of setting up a LAN. My predecessor
[quoted text clipped - 3 lines]
> database and replicate the front end in a non-networked,
> stand-alone environment?
Front ends should *never* be replicated, only "back ends" (i.e., the
data tables). The reason for that is that, despite Microsoft's
claims to the contrary, replication of Access objects (forms,
reports, etc.) doesn't work reliably over the long term --
eventually the project ends up corrupted and is lost.
If there is no network at all, then you can't use replication in any
form, since the only way that any changes can be distributed between
replicas (whether front end or back end) is by connecting via a
network. Any other method (emailing files, floppy disks, CDs) will
result in the dreaded "dead replicas" (search this newsgroup on
Google Groups for the term and you'll find out all the problems they
cause), which lead to errors and corruption and eventual loss of a
replica set.

Signature
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
octibel - 19 May 2006 10:01 GMT
Thanks David!
I should revise my statement: there is a simple, peer2peer that i will
use to link laptops (carrying replicas) with my desktop (storing the
design master). From all i'm reading on this list (which is fantastic,
by the by), i need to instruct Access to only replicate tables. Since
the replication process is new to me, what steps need to be taken to
only replicate tables? i've checked the tools\options\advanced tab as
well as the database properties window...so far i can't find the magic
spot where Access will allow me to only select tables for replication.
any help is much appreciated
David W. Fenton - 19 May 2006 16:10 GMT
> I should revise my statement: there is a simple, peer2peer that i
> will use to link laptops (carrying replicas) with my desktop
[quoted text clipped - 6 lines]
> allow me to only select tables for replication. any help is much
> appreciated
Replicated or not, no Access application but the most trivial should
be used in any configuration except split, with one MDB for the data
tables and a second MDB containing the forms/reports/etc. with links
to the MDB with the tables in it. Each user gets a copy of the front
end MDB (the forms/etc.), and everyone shares the back end MDB (the
tables).
This is basic Access 101 and there are very few Access applications
that should not be set up in this fashion.
The implication for replication is that only the back end MDB is
replicated.

Signature
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/