i have an access front end. the backend is a sql server database. can i have users download the runtime and have the full functionality of being able to edit the sql server database from the access front end? why is it free? what makes it different from the whole version?
A:
In a nutshell, the runtime version allows you to change data but not objects (forms, reports, queries, etc).
BenV
2010-09-21 20:59:17
+2
A:
In a nutshell, the Access Runtime version allows you to distribute an Access Database application to machines that do not have Access or Office installed. It won't allow you to open the database in design view or to make any changes to the database apart from adding or editing data. They can contain the data tables or can be set up using linked tables so that you have a central database (in some cases a shared .mdb file on a network, or something like SQL server)
Because many Office 2007 installations are not the professional version (Home and Student, Small Business etc) which does not include Access, making the runtime freely available is to encourage Access Developers to build databases which may be used in such cases or even in instances where office is not installed at all.
Istari
2010-09-21 21:02:04
The runtime is binary identical to full Access. It's the installation configuration that prevents you from using the design tools.
David-W-Fenton
2010-09-22 03:15:33
It's free !!!!!!!!!!!!!!!!!!!!!!
Jeff O
2010-09-23 19:40:55