astarbyfar
Registered User.
- Local time
- Today, 11:01
- Joined
- Apr 27, 2003
- Messages
- 93
Ive created a group level account which prevents prohibited users from accessing database utilities which they dont have access to. Now if a user who has no write access attempts to enter a data entry form then the database crashes and the only way out is to exit the database. Im just wondeing if anyone has any idea how I could have a message appear to say that they dont have the access which will then direct them back to the original form.
Secondly on a number of forms I have used a button which allows the user to print a report. Now in the code for each button I have the acSave command which means that the information currently stored on the form is saved then prints out the required form with this information. However, again the user who has no writing access is displayed with an error saying that the save command can not be used at the moment.
Has anyone any ideas how to overcome these problems. The message box would not be a problem usually but because weve got no way of displaying the user rights I cant understand how to do it!
Regards Mike
Secondly on a number of forms I have used a button which allows the user to print a report. Now in the code for each button I have the acSave command which means that the information currently stored on the form is saved then prints out the required form with this information. However, again the user who has no writing access is displayed with an error saying that the save command can not be used at the moment.
Has anyone any ideas how to overcome these problems. The message box would not be a problem usually but because weve got no way of displaying the user rights I cant understand how to do it!
Regards Mike
