Re: Read only db

[alicejwz]

Re: Read only db

Hi all,

I have a ACC 2K FE and SQL Server 2K BE. I like to create a copy of this database as READ ONLY, FE and BE. That means a user can click on different buttons to open different forms for viewing but no editing, no changes to the tables. I don't believe creating ade will solve my problem. How would I create a read only db?

Thanks!

 

[aqif]

One simple solution could be to create a frontend version with all the forms locked by setting Allow Additions, Allow Deletions, Allow Edits properties to flase at the form level. This will only prevent the data entry/deletion on form level but Pat Hartman solution is definitetly the ultimate one.