Results 1 to 3 of 3
  1. #1
    itm is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    69

    Running Access for multiple users

    Hi,


    I have an MS Access application for about 40 users. The problem is that the company does not want to have to buy all these licenses and put it on each machine. Also because each person had to bring in their own set of data multiple people cannot be hitting this at once. So they want to know if there is a way to allow the people to use it without having the application on their machine; and thereby saving the money of buying 40 licenses. They thought of making an MDE butot my knowledge the user still has to have Access installed on there machine.

    Thank you
    itm

  2. #2
    10 Gauge's Avatar
    10 Gauge is offline Getting the hang of it...
    Windows 7 64bit Access 2007
    Join Date
    Feb 2011
    Location
    Fredericksburg, VA
    Posts
    202
    You will need to package it for use with the Access Run-Time Components which is a royalty-free way to distribute your database to the company without needing to purchase licenses for each machine.

    Here's an excellent write-up of the whole process to do this:

    http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

  3. #3
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Hi itm,

    If you make an MDE and you install the Access Runtime on the machine, the user does not need to have MS Access installed on the machine to be able to use the MDE.

    Installing the Runtime is a very simple and painless process.

    Do a search for AccessRuntime or AccessRuntime.exe

    All the best.

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

Similar Threads

  1. Multiple Users :)
    By greatfallz in forum Access
    Replies: 1
    Last Post: 08-21-2011, 02:40 PM
  2. Need advice on sharing access among multiple users
    By Buakaw in forum Import/Export Data
    Replies: 2
    Last Post: 07-21-2011, 01:57 AM
  3. Multiple Users
    By jo15765 in forum Forms
    Replies: 2
    Last Post: 12-03-2010, 09:51 PM
  4. multiple users
    By ramkitty in forum Access
    Replies: 1
    Last Post: 03-22-2010, 07:15 PM
  5. How to have multiple users
    By Eric1066 in forum Access
    Replies: 5
    Last Post: 11-19-2009, 05:14 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