Multiple design masters in replication

[Guest]

Have a replicated database on several computers. One function on the
database allows user to use command button to create and email a report.
DoCmd.CopyObject and delete object are used to create, send and then delete
report. Replicated copies are not permitted to create objects, only the
design master can.

Any ideas how to allow a replica to create objects? Is it possible to give
a replica additional permissions to create objects?

 

[Joan Wild]

Have a replicated database on several computers. One function on the
database allows user to use command button to create and email a
report. DoCmd.CopyObject and delete object are used to create, send
and then delete report. Replicated copies are not permitted to
create objects, only the design master can.

Any ideas how to allow a replica to create objects? Is it possible
to give a replica additional permissions to create objects?

First of all this newsgroup is about security in Access. There is a
newsgroup for replication. Try looking under
Developer-Office Solutions.....Access....replication

Secondly, replication is meant for tables (data) only. You should not be
replicating other objects. Split the database and replicate just the
backend. Give each user a copy of the frontend on their machine, linked to
whatever replica they need to use. Your scheme for creating/deleting
objects will work as well.