Results 1 to 4 of 4
  1. #1
    Joakim N is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Oct 2016
    Posts
    79

    Location Front End

    Hi,



    I am close to distribute my first application in Access for multiple users. I have some questions where to locate the Front End.

    Local:
    - Is it possible to locate the Front End on each user's computer? Back End is located on a network. Does autonumber and everything else working?
    - Is it any advantage having the Front End on each computer? Like speed or anything else.
    - Disadvantages?

    Network:
    - I tried to have the Front End on a network. All users open the same Front End. I tried to have the folder where Front End is located as READ ONLY to prevent that users remove it by mistake. That didn't work. Is seems that the folder must have WRITE persmission although noone shall change anything in Front End. Is that correct? Back End is placed in a folder with WRITE permission.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    DO put the FE on each persons PC.
    It doesnt matter where, the BE points to the server.
    but
    for easier distribution, you can put the FE on each user's private network folder. Then you can distribute upgrades simply by running code to copy the master FE to everyone's folder.
    The user would have a shortcut on their desktop to run their network FE db.

  3. #3
    Joakim N is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Oct 2016
    Posts
    79
    Thanks for youi reply!

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Agree with ranman, copy to each user PC or in their network user folder. In our system I had to put the copy on each user PC at C:\ root because that was only place the autocopy code would work with. Worked for years then IT upgraded Windows and tightened security and now the autocopy code won't work at all. Had to change code to a notification to users to manually copy the file. The code cancels opening the db and auto opens the folder location with the revised frontend that they then copy/paste.

    I never published the frontend as trusted and/or executable. Not sure that would make a difference.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. location search.
    By Homegrownandy in forum Programming
    Replies: 6
    Last Post: 11-18-2015, 08:34 AM
  2. How to get location of object
    By lawdy in forum Programming
    Replies: 11
    Last Post: 05-29-2014, 01:43 PM
  3. Picture location using vba only
    By trevor40 in forum Forms
    Replies: 1
    Last Post: 03-22-2014, 08:29 AM
  4. Hyperlink Location
    By Mahendra1000 in forum Access
    Replies: 1
    Last Post: 09-26-2013, 09:00 AM
  5. File Location
    By Mitch87 in forum Programming
    Replies: 1
    Last Post: 02-19-2010, 11:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums