Re: Multiple users in a stand-alone environment

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"octibel" <octibel@xxxxxxxxx> wrote in
news:1148029290.213132.28560@xxxxxxxxxxxxxxxxxxxxxxxxxxx:

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

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.

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

Relevant Pages

  • Re: How do I replicate forms, reports, code, etc. in an upsized da
    ... Your mdb version was set up incorrectly, ... overwriting the adp file is possible. ... >> Replication is not intended to be used for queries, forms, reports, ...
    (microsoft.public.access.setupconfig)
  • Re: Duplicate MDB files
    ... one MDB, ... Replication is what's needed. ... Then a local replica could be made from that synchronized global DB, ... Is it necessary to make replicas of both MDB files, ...
    (comp.databases.ms-access)
  • Re: Intermittant 3167 error/indexing problem
    ... And you should probably do it in an entirely MDB. ... excluded the replication fields of course and they were only ... The client networking environment is unreliable or the ... can easily lead to corruption on a regular basis. ...
    (microsoft.public.access.replication)
  • Replication 101 questions?
    ... and have to do more advanced stuff, specificially replication & ... The .mdb is already open. ... I get the error "User-defined type not defined" on the first Dim ... Dim strMaster As String ...
    (microsoft.public.access.replication)
  • Re: Wireless merge replication stability question.
    ... Copying the mdb back and forth won't work. ... If client 1 copies his mdb to the ... Looking for a SQL Server replication book? ... >> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)