Question Read only access for some departments

[Toolpusher]

Hi

I have a DB that will be used on various networks and PC's. I have set it up that some departments have full access to everything and some only have access to fill in certain parts of certain forms. Done this by recreating the forms and locking various fields. This may not be too professional but works fine.

i would also like to add to my switchboard a command for anyone to access the complete DB but with read only access. Googled this but dont see any easy way of doing this when the DB will be on various PC's & networks. Any ideas?

regards

TP

 

[gemma-the-husky]

read only access is not so easy to implement. you can make a form set "allowedits = false" - but then you can't even change combo boxes, which is very impractical

it's a similar problem to trying to make excel read only.

however you don't have to create a new form to lock the fields - you can just test the user, and then enable/lock the controls/fields as appropriate based on the user. it's just a bind to do for every form.