Prevent Modules, Forms & Macros becoming Replicable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wesley Baker - 21 Mar 2005 03:38 GMT

Hi All,

I am developing a distrbuted database across our LAN using Access 2002
Replication.

The database is split into front end & back end files. I want to use the
design master to control various automatic updates and pre-crunch some data
to use in reports in the replicas.

My problem is that I dont want to replicate the forms, macros & modules I
have created to implement this automation.

Does any one know how I can stop these objects from becoming Replicable?

I have tried changing the Replicable & ReplicableBool properties but to no
avail... Maybe I am doing this incorrectly though.

Any Ideas?

Thanks in advance,

Wesley Baker

Reply to this Message

Jack MacDonald - 21 Mar 2005 05:07 GMT

Splitting the db into FE and BE components is the right thing to do,
and then to replicate only the BE, as you have done. The BE should
contain only tables.

If you want some automatic processing to occur in the BE, and not to
have the processing objects to be in the FE, you could create a
separate FE for the automatic processes. Use it just like your
conventional FE, but don't distribute it to the users.

If you don't want to maintain a separate "automatic" FE, then you
could distribute your conventional FE as an MDE, which will (probably,
but haven't checked explicitly) prevent the objects from being
replicated. Or you could apply user-level security to prevent people
other than yourself from accessing the database design.

>Hi All,
>
[quoted text clipped - 18 lines]
>
>Wesley Baker

**********************
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

Reply to this Message

Wesley Baker - 22 Mar 2005 01:47 GMT

Thanks Jack,

I should have thought of that... I guess I just got on the wrong train of
thought.

Once I converted replicated Access 97 database to 2002, some how the
database & queries tables remained replicated, but the forms & modules were
not! I don't know how though.

best regards,

Wes

Reply to this Message