Solved

Runtime version of Access 2010 with a split database?

Posted on 2014-04-04
5
1,982 Views
Last Modified: 2014-04-06
Is it possible to run an Access 2010 database on a computer that doesn't have Access installed?  How do you do it?

The database will be a split Access database with the back-end file on a server and the front-end on three computers.

I assume the server has to have Access 2010 installed, correct?
0
Comment
Question by:SteveL13
5 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 167 total points
ID: 39978420
<<Is it possible to run an Access 2010 database on a computer that doesn't have Access installed?  How do you do it?>>

 No and yes; you install the "runtime" version, which is nothing more then the full version with all the design features disabled.  Either the full or runtime version must be installed.  You cannot simply hand someone a DB file and be able to run it.  The runtime version is free from A2007 and up and available for download on Microsoft's web site.

You can simulate the runtime version for testing with the full version by starting it with the /runtime switch, or naming your DB with *.accdr

<<I assume the server has to have Access 2010 installed, correct? >>

 No.  With JET DB's, the server only acts as a file share.  All database processing is carried out client side.

Jim.
0
 

Author Comment

by:SteveL13
ID: 39978515
So just so I'm clear...

I would install the B/E file on the server.

I would install the F/E on each client computer.

I would install the runtime file on each client computer.

But how do I link the tables using a runtime version?  Or do I have to load one copy of the full Access 2010 on one client computer for the linking process?

Correct?
0
 
LVL 34

Assisted Solution

by:PatHartman
PatHartman earned 167 total points
ID: 39978604
Unless you will need to have the users relink the BE on their own initiative, you will need to link the BE before you distribute the FE.  The best method is to use the UNC name when you link.  That will avoid drive mapping issues if the users don't all have the same drive mappings.

\\myservername\dir1\dir2\dir3\mydb_BE.accdb

If the users need the ability to relink, you will need to create a form to help them or a button that opens the built in Linked Tables Manager dialog.  I prefer option 1.  If you need a sample, search for the JStreet linker.  It is a free download and you can modify it to suit your situation.

PS - Access does NOT need to be installed on the server.  It only needs to be installed on the computer where you are running the application.   No part of the application runs on the server.  It is all handled on the local computer.

The Runtime is a free download available from MS.  When operating under the runtime, you loose all design options and most ribbons.  You also loose the right click menu so if you are dependent on that for sorting or searching, you will need to add the right-click menu back programmatically.  Essentially with the runtime, the users get only what you give them although it is smart enough to give you the print menu when a report is open.
0
 
LVL 57
ID: 39978626
Yup, Yup, and Yup.

<<But how do I link the tables using a runtime version?  Or do I have to load one copy of the full Access 2010 on one client computer for the linking process?>>

  You need to build re-linking capability into your application.  This is not hard and there is code floating around to do that.

 Typically you have an app start up, check a table, and if it fails, prompt the user for the location of the BE, then refresh all links.  If they don't provide it, you quit the app.

  Your going to find there are many things you need to do and will work differently under the run-time.  

 So before going further, make sure:

1. You read:

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

2. You thoroughly test your app using the full version, but start Access with the run-time switch or if your using the new ACE format (*.accdb), renaming a copy to .accdr

Jim.
0
 
LVL 9

Assisted Solution

by:Armen Stein - Microsoft Access MVP since 2006
Armen Stein - Microsoft Access MVP since 2006 earned 166 total points
ID: 39980039
Pat, thanks for the shout out for our J Street Access Relinker.

Hi SteveL13,

As Pat mentioned, you're welcome to use our free J Street Access Relinker on our J Street Downloads page.  It's a lot nicer than the Linked Table Manager, and works fine with the Access runtime.

http://www.JStreetTech.com/downloads

It's some code that you simply copy into your front-end application.  It handles multiple Access back-end databases, ignores non-Access tables, and can automatically and silently relink to back-end databases in the same folder as the application (handy for work databases or single-user scenarios).  There's a ReadMe table with instructions.

Cheers,
Armen Stein
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now