ms access 2k10 Runtime: Can u run external accdb's

I have field techs with laptops that I perioically send updated access apps to. I would not like to license and install MS Access on these since they only run particular apps. I am familiar with creating RunTime App installation packages and distributing, but am looking for a simpler solution. If I install a runtime library on the laptop, can I then just supply .accdb apps and run them using the library?
jsgouldAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<< I am familiar with creating RunTime App installation packages and distributing, but am looking for a simpler solution. >>

 There are other installers, but no simpler solutions.  Access must be installed *assuming* that you are using Access objects (forms, reports, etc).

 There is no "run time" library; the only difference between the "run time" and a full version is some registry keys.   It's the same executable, DLL's, etc.

 If your just storing data, then yes you can install only the database engine (you won't have MSACCESS.EXE)

Jim.
jsgouldAuthor Commented:
Thank you!

The app(which is contained in the users dropbox) is for the user to enter expenses into a form which updates an access table. at some point, accounting imports the table from the accdb in the lockbox into a Job cost app. for each new Job,the user gets an empty accdb in their dropbox. Does this qualify for "Just storing data"?
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<is for the user to enter expenses into a form >>

 No.

 Although I will take back somewhat what I said; a simpler method is to have the user download and install the runtime, then give them a copy of the DB only.  So no installer/packager, but they still need to install Access one way or another.

 Longer term, you might wish to take a look at Access Web Apps in A2013 and up.

 You publish a web front end with SharePoint, at which point a user can add and edit data through a browser.

 That data is stored in SQL Server, which you can point a regular Desktop Access app to.  

 This is a good setup for collecting / displaying data remotely, then processing "back at the office".

 Something to keep your eye on.

Jim.
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

jsgouldAuthor Commented:
Jim:
Good, I think.
If I understand u correctly;
I install access runtime on the users laptop. one time period, without any .accdb's
I then give the user just my access app .accdb and they're good to go running my app
with their pre-installed runtime.

Love ur long term but there are extenuating circumstances here.
This user is sitting in the engine room of a huge ship, 1000+ miles from
anywhere
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<If I understand u correctly;>>

 Yes you do.

 You really don't need an installer, but it helps in some cases.  But it sounds like you have a cut and dry "out of the box" Access app and haven't done anything fancy (i.e. used 3rd party controls, tools, etc).

So they would:

1. Install the runtime from here:

https://www.microsoft.com/en-us/download/details.aspx?id=50040

 Note that this is version specific....if your .accdb was created with A2010, then use the A2010 runtime.   The link above points to the latest, which is 2016.

2. Copy your DB to their hard drive.

3. Create a short cut (one time) to point to the DB.

 After that, they can upload/download just the .accdb.

<<This user is sitting in the engine room of a huge ship, 1000+ miles from
anywhere>>

 Sometimes it's amazing where you can get an internet connection these days, but your probably best with the setup you have.

Jim.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jsgouldAuthor Commented:
Jim:
Much thanks for ur help!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.