Replicating only tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I have a database that i have replicated and distributed to four different
users. When i replicate the master the file bloats, and so too are the
replicas.

Question, can i just replicate the tables? Is there a risk?
 
All you should be replicating is the tables. Application items such as
forms, reports, macros and modules should never be replicated.

In actual fact, your application should be split into a front-end
(containing the queries, forms, reports, macros and modules), linked to a
back-end (containing the tables and relationships). You'd replicate the
back-end, and give each user his/her own copy of the front-end.
 
replicate only the tables by splitting the database. Also Replication will
approx double you db size. This is normal.
 
Back
Top