Dataset

[captainlove]

How do I make a dataset not updataable in MS access

 

[pbaldy]

You can present the data to the user in a form with its Allow Edits property set to No.

 

[odin1701]

Another way to do it is in the form properties, under the Data tab, you can set the Recordset Type to "Snapshot" - you can't change it then. It won't update if data changes unless you refresh the form (re open it, requery it, etc.) but you won't be able to do any edits.