Replication and Security

[123James]

Hi everyone

I have a database accessed by alot of people and have recently added user level security so that i can monitor who is logged on etc.

Another thing i need is the ability to update the design of forms whilst people are on the database. To do this i planned on creating a replica and synchronising any changes after i had made them.

However, this is causing problems with my security. I cannot create the shortcut needed to give people access to the replica, they can only access the design master, which defeats the point!

Any help much appreciated

James

 

[orna]

Replica

James

Don't start with replicas, it's not a good idea.
Replica is only for data not forms etc and it's a pain.
try this to logoff your users:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=LogUsersOff.mdb

 

[gemma-the-husky]

sounds like you and your users are sharing the front end. This is not ideal, looads of explanations here why not to do this.

 

[123James]

Thanks for the advice and also adding that link on

Im not too savvy with script but I will give it a shot!

James