Replicated Database 1

[villsthearcher]

Hi,

I intend to make my database a read only file. What I mean is that the User will not be able to change the Design or modify the forms, reports or queries respectively.

So what I did was I first converted the .mdb file into .mde file. Then I replicated this file. Now, I was successful in doing this and I got what I wanted. But I found that, I was still able to add data to the tables. How do I or what should I do to turn off this ablity to enter data into a replicated file of a mde file.



Thanks,
villsthearcher

 

[lupins46]

You should implement Access security and ensure that the Admin user has read permissions only on all data.
You will have to read a fair bit about Access security if you have not used it before. And don't practice on anything that matters!

http://support.microsoft.com/default.aspx?scid=kb;en-us;207793

 

[villsthearcher]

Lupin,

Thanks for showing me the light!

Thanks,
villsthearcher