Solved

Packaging an Access 2010 database with external data

Posted on 2011-02-10
2
387 Views
Last Modified: 2012-05-11
This may seem like a silly question, but I haven't yet been able to find the answer to my specific concern anywhere. I have a database that is designed to run certain queries and formulate reports based on an external SQL database.  So, the Access database has to be able to update its data each time it is opened so that the user has up-to-date data on the reports. So far, users have all had the full Access application installed on their workstations, but now that's going to change. So, I'm looking at deploying the database to users by creating a package (runtime).  I just want to be sure that the data from the backend SQL database will still be updated even though the users have read-only abilities for the Access database itself when using Access Runtime.
0
Comment
Question by:Hypercat (Deb)
2 Comments
 
LVL 39

Accepted Solution

by:
als315 earned 250 total points
ID: 34865569
There is no difference in runtime and full Access in data processing. You can't change DB design only
0
 
LVL 38

Author Comment

by:Hypercat (Deb)
ID: 34865976
OK - that's what I thought, but thanks for the confirmation!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Office 365 home questions 7 65
Access 2016 - Labels prompt to print 4 31
Attachment field in SQL 3 28
Using Multiple  Filters (XLS and XLSX) in File selection dialog 6 33
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

773 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