I have written application that replicates a secured database using
DAO (by setting the database's ReplicableBool property and then
calling the MakeReplica method). The original database had been
secured with a workgroup that I had created, with all permissions
being granted via groups only (i.e. all individual user permissions
had been revoked).
Everything appears to be in order, except that the Admins group in the
replica has no permissions whatsoever granted to it for any object in
the database. The permissions for all of my custom groups are exactly
the same as those in the original database (which is now a Design
Master).
When I replicate an identical database using the Replication Wizard
all the permissions, including those for the Admins group, are
transferred correctly.
Can anyone suggest where I might be going wrong? I have to admit that
Replication is still a bit of a black art to me.
