Open database Read-only

[sdawson]

Is it possible to put some code in start up form to make the whole of the db read only.
I know this is an option from the File,Open on the menu bar but I need to make sure that this archived data is never changed.

Thanks

 

[John Big Booty]

So long as your user can only access the data through a form you can do this quite easily by setting the Form's Allow Editst, Allow Deletions & Allow Additions properties to False/No.

 

[sdawson]

Not quite what I was looking for.
When there are multiple forms where data can be changed, this gets a little tiresome.
I was looking for something like the DOS command attrib +r.
Guess I'll have to stick with that!

 

[sportsguy]

VBA code:
SetAttr "Filepathname", vbReadOnly

I have databases which I update with monthly transactional information.
I set the attribute to vbNormal before loading, and vbReadOnly after loading. . .

does that work for you?

sportsguy

 

[sdawson]

Works fine if the db is not open but gives a Runtime error on the open file.
Thanks for reply sportsguy.