none
Publishing Access Database for multiple users RRS feed

  • Question

  • The database will be for about 15 users.

    I have done the following:

    Compile database

    Moved the database to a shared folder

    Split the database(BE and FE)

    Created ACCDE file from the FE

    Created a batch file –

    Start /max "C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" "R:\SHARED\research and reconcilation\TESTING\Reconcilation-Unit-Tracking-System-mde.accde"

    Exit

    I noticed that the batch file will not open the access file if one person already has it opened.

    What do I need to do to fix this issue?

    Is there a way that I can make the user not to be able to see the location of the database? I don’t want people going to mess with the file.

    Am I missing any other procedure?

    Thanks!


    • Edited by Chibut Wednesday, January 18, 2017 6:52 PM
    Wednesday, January 18, 2017 6:13 PM

All replies

  • Hi,

    I think the missing step is to give each user their own copy of the front end. Having all users open the same front end file is not really a recommended practice.

    Just my 2 cents...

    Wednesday, January 18, 2017 7:07 PM
  • Set the db folder to have Traverse Permission and then only give them access to the launch script.

    Also, theDBguy's remark is a critical one.  Every user need to have their own copy of the FE and it should be copied and run locally on their own PC.


    Daniel Pineault, 2010-2016 Microsoft MVP Professional Support: http://www.cardaconsultants.com MS Access Tips and Code Samples: http://www.devhut.net

    Wednesday, January 18, 2017 7:10 PM
  • How do I achieve this?

    Do I create a shortcut of the FE file or do I copy and paste the FE file on their desktop?

     Another, will I be using the ACCde file or the FE accdb file?
    Wednesday, January 18, 2017 7:42 PM
  • How do I achieve this?

    Do I create a shortcut of the FE file or do I copy and paste the FE file on their desktop?

     Another, will I be using the ACCde file or the FE accdb file?

    You can place the master FE (ACCDE or ACCDB) on  the network share and have each user download a copy to their Desktop.

    If you don't want them to mess with your design, only give them access to the ACCDE version.

    Hope it helps...

    Wednesday, January 18, 2017 10:50 PM
  • The most straightforward solution is to create a simple VBScript that performs the copy of the master file to the user's local computer and then launches it for you.

    http://www.devhut.net/2015/06/30/ms-access-deploying-your-database-front-end-to-your-users/ 

    You can even add code to define a trusted location automatically, etc ...

    By using such an approach, you don't have to worry about updating the FE as it will automatically be pushed out by your script as soon as you update the matter copy on the server.

    You can also add code to get the user's name and adjust if you provide them with an accdb or an accde.

    The possibilities are endless!


    Daniel Pineault, 2010-2016 Microsoft MVP Professional Support: http://www.cardaconsultants.com MS Access Tips and Code Samples: http://www.devhut.net


    Thursday, January 19, 2017 2:14 AM