Oct 13 2010, 01:33 AM
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 !
Oct 13 2010, 03:49 AM
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
Oct 13 2010, 04:22 AM
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 ...?
Oct 13 2010, 04:55 AM
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?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here