Avatar of Delores_C
Flag for United States of America asked on

How can I distribute a Access database created iusing 2010 version to someone without the Access program?

I have create a database using Access 2010, and I need to distribute it to someone who does not have the Access program on their computer.
Microsoft ApplicationsMicrosoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon
Jim Dettman (EE MVE)

You need to give them the Access  2010 runtime:



I've downloaded the file, and install it.  However, I do not see any sign of it in Access.  How do I apply it in Access.  Shouldn't there be a option some place in the program?
Jim Dettman (EE MVE)

The "Access Runtime" is a full install of Access, but has all the design feature disabled.

 If you already have a full install of Access, you don't need it.

 Your end user can download and install the runtime, and then they simply need a copy of your DB.  Double clicking on the DB will start it with the runtime.

 You can go a bit further and create an install package for it, which would be a distribution of the runtime along with your DB.

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Jim Dettman (EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jim Dettman (EE MVE)

BTW that article is for 2007, but 2010 (or any other version) in general is no different.  This is how the runtime and distribution for every version has worked.

The only difference is that for 2007/2010, Microsoft made runtime distribution free.

You should also knwo that if you decide to build a installer/deployment package, that most go with a 3rd party tool such as Sage/Wise or Inno.  The Package and Deployment Wizard that Microsoft offers with the runtime is lacking in many features and doesn't work well at all if multiple versions of Access may be running on the same machine.


Very helpful.  Thanks alot!