Results 1 to 2 of 2
  1. #1
    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.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    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 see
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts