none
ACCDE sharing and maintenance RRS feed

  • Question

  • I have a accde file as front end and common accdb file and both reside on shared folder .I want to share the front end  among 50 + users. As of now I have asked each one to copy the file and put their name initials. But this is very tedious task and much difficult if I want to make any further changes on the front end file. Is there a better way? Please advise.   
    • Edited by Santosh Vi Thursday, June 30, 2016 4:46 PM
    Thursday, June 30, 2016 4:45 PM

Answers

All replies

  • Hi. You can do a quick search for Auto-FE Updater in the UtterAccess Code Archive. Cheers!
    Thursday, June 30, 2016 4:54 PM
  • Take a look at http://www.devhut.net/2015/06/30/ms-access-deploying-your-database-front-end-to-your-users/ for some approaches to deploying your database to your end-users.

    A simply bat/vbscript that copies the file from a server to a local directory and the launches it would enable you to create a simply shortcut for your users to use, but allow you to push updates very easily.


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

    Friday, July 1, 2016 1:01 AM
  • >>>As of now I have asked each one to copy the file and put their name initials. But this is very tedious task and much difficult if I want to make any further changes on the front end file. Is there a better way? 

    According to your description, there is  "Auto FE Updater" third-party tool can be used to achieve your requirement.

    In addition you could refer this article about Automatically Deploy a New Access Client

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.
    Friday, July 1, 2016 2:29 AM