Quick-save database to read-only

[adamburton]

Does anybody know if there is a quick way of making a database read-only (so no data input OR design priviledges).

Ive had a request to send somebody a database so they can look at the data but not add/amend etc. The only thing I can think of is adding a security workgroup and assigning read only permissions. But this seems a bit long-winded and I wondered if I was missing something obvious like a 'save as - read only' option.

Any ideas.

Thanks,
Adam.

 

[trucktime]

Read only

You could put this code somewehere, may be in the On Opening Event of the Start up form:

Me.AllowAdditions = False
Me.AllowDeletions = False
Me.AllowEdits = False

 

[ghudson]

Do what trucktime suggested in the forms OnOpen event but you will have to convert the db to a MDE so that the user can not change the design of the form or touch the code.

You could put the db on a CD-ROM. The user will not be able to alter anything if they try to open it from the CD but all bets are off if they copy the db file to their hard drive.

Do not mess with the Read-Only file attribute for anybody can remove it.

 

[adamburton]

Thanks

Thanks guys,

I will give that a go.

Many thanks for your quick response.

Adam.