Hi all,
How and what vba code do i need please so that I can allow some users the right to edit and make changes in the database and reports and most users "Read Only" only? Thanks in advance
Hi all,
How and what vba code do i need please so that I can allow some users the right to edit and make changes in the database and reports and most users "Read Only" only? Thanks in advance
You can't really do that other than with possibly network security. If someone knows their way around access you can't secure it from being changed other than at the network level that I know of (and seems to be foolproof)
It depends on what exactly is your terminology:
"edit and make changes"
a. if you mean to the data; then you must set up yourself a log in method so that the database knows who is the user - - and then integrate this into the forms/reports so they only display the appropriate data. It can get complicated but is a fairly common requirement in the real world.
b. if you mean design view of the forms/reports themselves - - then you need to control the type of front end that is distributed; as the compiled mde / accde will prevent design view and is given to those that need to be stopped from design view.
Hope this helps
in point a. above: locking and unlocking fields ....I meant to include that aspect as well.....