How to create a read-only database

[Rajjanssen]

Hi,

I have set up a simple ordering system at my workplace using Exce
forms. Using template wizard with data tracking all orders using thi
form are stored in a database. I like this database to be read-only, s
everyone can see the orders placed without messing up the database
However, if I make the database read-only, the template wizard i
unable to add new orders. How do I get around this problem? Fo
instance, is it possible to make an automatic copy of the databas
everytime it is changed which is read-only ??

Thnx

Richar

 

[Dave Peterson]

Not a real good solution, but maybe...

When you save the file (actually File|SaveAs), you can specify that you want to
recommend that the file be opened readonly.

File|SaveAs|tools|(General) Options|check the "read-only recommended" box

If you want to allow some users to only have readonly access, give it a password
to modify in that same dialog. But only share that password with the users who
should make changes.