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

Delores_C
Delores_C used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
You need to give them the Access  2010 runtime:

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=10910

Jim

Author

Commented:
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)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
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.

Jim.
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
You might want to check out the following link:

Basics for Building Access 2007 Runtime-Based Solutions
http://msdn.microsoft.com/en-us/library/cc136539(v=office.12).aspx

Which will answer a lot of the questions you might have.   Acces is unusual in that it's more like a document that is read rather then a program that is executed.  So distributing it is not like anything else that you may have worked with in the past.

Jim.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
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.

Jim.

Author

Commented:
Very helpful.  Thanks alot!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial