04-15-14, 12:27 #1Registered User
- Join Date
- Apr 2014
Unanswered: prohibit front end-user from changing back-end unless using a form
I setup a database. I split the database into a front-end and back-end. In the front-end I created a form with some VBA code that updates the back-end by clicking a button. Basically, I have a front end user that receives a paper report, which they then input into the form and click a button that will append the report to a back-end database.
Now I only want the front-end user to update the back-end by using the form but on the front-end version there is a table that is linked to the back-end and any changes made to the linked table also happen in the back-end. I want to make it so that the only way a front-end user can change the back-end is through the form. What is the best way to approach this? I do not want to just hide the linked table as this is more of a band-aide approach than a solution.
Thank you in advance for any feedback.
04-15-14, 13:31 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
deploy the application as an encrypted db (mde or accde), BUT keep the MDb/ACCDB so you cna make chanegs to trhe applications
in the MDE/AACCDE your users can only see what they are allowed to seeI'd rather be riding on the Tiger 800 or the Norton