How to Make DB Objects Read Only?

[Moah Scout]

Hi all!
I have a table of which should be converted to READ ONLY after confirmations! The Confirmation Button may be set to VBA to change the table properties to ReadONLY!!!!
Please help!

[Stewart Ross]

Tables cannot be set to read-only in Access.

If you really mean that you are accessing via a form you can use the form's allow edits and allow deletions properties to control whether or not users can edit the records. Although setting these properties in VBA is simple, you should be careful about how you do so as users may wish to make small changes to records after they confirm them (to correct a spelling error, for instance). I allow a short time period for this, set in a properties table for lookup and modification if required.

-Stewart

[Moah Scout]

Thanks alot Stewart! I will try your suggestion, this DB is just a trial version. It doesnt mater whether you disable it or not, we dont expect any editing after confirmation

[Mr Key]

According to my knowledge, if you link the db to another db, there are options to decide whether you want the tables to be linked as read only or not!!
There might be some trick for it

[Mr Key]

What if we create a copy of another db on the backend and delete the existing one and then create new db with no objects but include the link of the backend db wont it be the read only? I just wonders!!!!
We can also prevent the user from opening the realbackend db.

[Stewart Ross]

No, Mr Key, what you mention is just added complication which will not achieve what the poster requested - which is to have a table read-write until the record is saved, then read-only thereafter.

As mentioned, Access cannot set individual tables read-only, although it is certainly possible to treat the recordsource of forms as snapshots rather than dynasets (which will make them in effect read-only) - but only through the forms interface, not the tables as such.

-Stewart