+ Reply to Thread
Results 1 to 2 of 2

Access as a backend - prevent direct user access

  1. #1
    Forum Contributor
    Join Date
    03-11-2021
    Location
    india
    MS-Off Ver
    365
    Posts
    154

    Access as a backend - prevent direct user access

    Hello,

    I use Access as a backend that is on the server. Users have front end clients which connects to it but there is nothing to stop them opening the folder where the Access file is stored. It has a password but they could just delete it.

    The front ends are a mix of Office files but also some VB programs.

    Is there a way to allow front ends to access, but prevent users from going there directly?

    If not what would be a solution that would allow this?

    Thank you

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Access as a backend - prevent direct user access

    You network engineer could extend reading rights only or full control at a user access level
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Share query without direct access to file
    By Undo in forum Excel General
    Replies: 3
    Last Post: 03-08-2023, 10:44 AM
  2. What is the best solution Excel frontend Access Backend as database
    By nordicdust in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2019, 07:41 AM
  3. [SOLVED] Excel=FrontEnd and Access=Backend DB
    By M P in forum Excel General
    Replies: 5
    Last Post: 04-12-2012, 05:19 AM
  4. Make the code working for Access backend
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-27-2011, 03:29 AM
  5. Excel 'app' with MS Access backend
    By winshent in forum Excel General
    Replies: 0
    Last Post: 10-12-2009, 12:12 PM
  6. Can i use Ms-Access as backend for surveys
    By L_ter in forum Access Tables & Databases
    Replies: 2
    Last Post: 04-08-2009, 07:44 AM
  7. How To run Access database without having to install Access on user PC's
    By Reema in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2009, 04:02 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1