Lock Table in Data Access Page

[OnLiner]

Hi everyone,
I created a DAP in design view and dragged a table onto it. How do I lock the table so users cannot edit/add/delete records, but just view them?

thanks

 

[OnLiner]

so I am assuming there is no way to do this without locking the underlying table or query??

 

[fneily]

You mean lock the DAP. Open your DAP in design view. Click on the Properties button (Button with a hand holding a piece of paper). Click on the TITLE BAR of the DAP. Click on the ALL tab of the property sheet. You will see an option called DATAENTRY. Change it to FALSE.

 

[OnLiner]

great thanks!!