Results 1 to 6 of 6
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168

    Deployment and Installation


    Not sure if this belongs here as it doesn't specifically relate to SQL Server, but I am curious if there good way to deploy My Access front end.

    What I need is some sort of installation package that will first install Access Runtime 2016, then install the ODBC driver, and then install the database into a directory location.

    I have just played with windows installer but it seems to only want to work with .exe files and it didn't look like it would do what I wanted.

    Any thoughts are appreciated.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    depends what you mean by deploy? if you are in a corporate environment, usual basis is to send the new user a shortcut to a batch file to install the app. The same batch file can also do things like check for current version and replace the fe if required

    But if you want an installer there are a number of installer apps out there - I use Inno

    be aware the runtime is large so if you are planning to email your installer it is likely to fail. There are also potential issues if your client already has a different version of access (or same version bit different bitness) and/or in a corporate environment does not have the rights to install a program.

    Better to have your script inspect the client setup to determine if access is installed and its version then point them in the direction of a site to download the appropriate runtime.

  3. #3
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168
    Thanks Ajax,

    Not in a corporate environment, I have my backend in an Azure type Cloud Service and my users are all over the state, and mostly not very tech savvy. (trying to deploy this to a bunch of sober living homes, most computers don't have MS Office, and I would be suppressed if any of them had Access)

    I know Runtime is big and haven't figured out what I am going to do about that. just in the early stages of "What if" and "Maybe this will work"

    thank you for the Inno idea I will look into that.

    Thanks again

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Inno is free and works well but is entirely script based.
    There are various other installation software programs available that use a wizard like approach including SSE Setup and SamLogic Visual Installer.
    I use SamLogic VI Pro which also includes a scripting feature which makes it particularly powerful.

    If you really want to include Runtime as part of the EXE file produced, consider distributing via a website or a Dropbox folder shared with selected clients.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    After you get Access loaded, you can check in VBA what ODBC drivers they have loaded, and carry on or prompt them to download the latest version.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  6. #6
    Join Date
    Oct 2021
    Posts
    9
    If there are a lot of users using access, you should make copies of accde version for each user. This will perform the fastest as they are not sharing the same access ui and minimize corruption.

    I used a custom access app to deploy access apps to hundreds of users via click of a button. I can upload it somewhere if you want to review it.

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

Similar Threads

  1. V-Tools installation
    By Lou_Reed in forum Access
    Replies: 3
    Last Post: 07-18-2017, 10:08 AM
  2. Deployment
    By Fatmonkeymedia in forum Access
    Replies: 13
    Last Post: 12-03-2016, 10:22 PM
  3. SQL 14 installation problems
    By George in forum SQL Server
    Replies: 0
    Last Post: 02-26-2016, 05:25 AM
  4. Deployment
    By GraeagleBill in forum Access
    Replies: 0
    Last Post: 06-27-2013, 10:09 AM
  5. SQL Server Installation
    By JohnnyCash in forum SQL Server
    Replies: 0
    Last Post: 02-07-2013, 12:22 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