Hello,
I have BackEnd tables on a shared folder and users with FrontEnd accesing it without problem over the network.
Now I need to allow a user to acces data but with read only option.
What is the best way to do it ?

Thank You !

Hello ,

You could set up a form in datasheet mode where all records are locked.

Set default view to datasheet
Allow form view = No
Allow datasheet view = Yes
pivot table and pivotchart view = NO
Allow Edits , additions , deletions = NO

Hi,
Thank you,
but I since this user can access the forms and change this setting, I wanted to know if there is some code that do this automaticaly, regardles of the status of the forms in edit mode ...?

You can base it off a query whose recordset type is set to something that provides read-only. But I think, if your users can enter design view of a form to change those properties they can get around anything you might do to try and stop them from changing the records.

Can you distribute an mde/accde file for them to use where they won't be abe to design anything?