Security And Replication

[Grumm]

I have an application that is replicated and I want ro have an office based master with various managers on site who will visit the office and replicate with new information. My problem is I need to implement security as the database holds sensitive information and must be secure.

What is the best approach to this?

Thanks for any help.

 

[SiJP]

Oh what a fantastic can of worms! Many people on this forum have opinions about the pro's and cons of using either acces built in security or building your own security.

May I suggest reading the following thread so you can get some background for this!

thread702-442005 this helps..

 

[Grumm]

Thanks for that - its a long read butthere are some good coments as well - maybe this will be the evidence I nee dto get my customer to pay for some web enablemennt

Cheers