Avatar of Ralph Gould
Ralph GouldFlag for United States of America

asked on 

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?
Microsoft AccessMicrosoft Applications

Avatar of undefined
Last Comment
Ralph Gould
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

<< 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.
Avatar of Ralph Gould
Ralph Gould
Flag of United States of America image

ASKER

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"?
<<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.
Avatar of Ralph Gould
Ralph Gould
Flag of United States of America image

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Ralph Gould
Ralph Gould
Flag of United States of America image

ASKER

Jim:
Much thanks for ur help!
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo