Sunday, April 12, 2009

Microsoft Jet Database Engine

http://support.microsoft.com/kb/239114

Download MS Access 2007 Runtime



-----
The Microsoft Office Access 2007 Runtime enables you to distribute Access 2007 applications to users who do not have the full version of Access 2007 installed on their computers.


  1. https://download.cnet.com/Access-2007-Download-Access-Runtime/3000-2070_4-10726092.html
  2. http://www.mediafire.com/?azig0nngknn

Download MS Access 2003 Runtime



The Microsoft Access Runtime enables you to distribute Access applications to users who do not have the full version of Access installed on their computers.

Application developers can create Access solutions and distribute it for use by non-Microsoft Access owners.

However, unlike the regular version of Access, the runtime version allows users to use the Access application but they cannot use its design tools.

1) http://support.sagekey.com/files/access2003runtime/

Download MS Access 2000 Runtime



The Microsoft Access Runtime enables you to distribute Access applications to users who do not have the full version of Access installed on their computers.

Application developers can create Access solutions and distribute it for use by non-Microsoft Access owners.

However, unlike the regular version of Access, the runtime version allows users to use the Access application but they cannot use its design tools.

1) http://www.foxvillage.com/Access2KRT.asp

2) http://www.mediafire.com/?tozwmz3tnzb














Download MS Access 97 Runtime
















Saturday, April 11, 2009

MS Access from WikiPedia


Microsoft Access is known for its ability to empower non-professional developers to create database applications on their own. Users can easily create tables, queries, forms and reports, and connect them together with macros. Advanced users can use VBA to write rich solutions with advanced data manipulation and user control.
The original concept of Access was for end users to be able to “access” data from any source. Access offers the ability to import and export data to many formats including Excel, Outlook, ASCII, dBase, Paradox, FoxPro, SQL Server, Oracle, ODBC, etc. It also has the ability to link to data in its existing location and use it for viewing, querying, editing, and reporting. This allows the existing data to change and the Access platform to always use the latest data. It can even perform heterogeneous joins between data sets stored across different platforms. Access is often used by people downloading data from enterprise level databases for manipulation, analysis, and reporting locally.
A significant strength of Microsoft Access is its Jet Database format (MDB or ACCDB in Access 2007) which can contain the application and data in one file. This makes it very convenient to distribute the entire application to another user, who can run it in disconnected environments.
One of the benefits of Access from a programmer's perspective is its relative compatibility with SQL (structured query language) — queries can be viewed graphically or edited as SQL statements, and SQL statements can be used directly in Macros and VBA Modules to manipulate Access tables. Users can mix and use both VBA and "Macros" for programming forms and logic and offers object-oriented possibilities. VBA can also be included in queries.
Microsoft Access offers parameterized queries. These queries and Access tables can be referenced from other programs like VB6 and .NET through DAO or ADO. From Microsoft Access, VBA can reference parameterized stored procedures via ADO.
SQL Express or MSDE (Microsoft SQL Server Desktop Engine) 2000, a scaled down version of Microsoft SQL Server 2000, has been a free download for a decade and may be used with Access as an alternative to the Jet Database Engine.
Microsoft Access is a file server based database. Unlike client server RDBMS, Microsoft Access does not implement database triggers, stored procedures, or transaction logging.
In ADP files (supported in Access 2000 and later), the database-related features are geared more towards a client-server architecture with MSDE or Microsoft SQL Server serving as the back-end instead of using the Jet Engine. Thus, it supports the creation of nearly all objects in the underlying server (tables with constraints and triggers, views, stored procedures and UDF-s). However, only forms, reports, macros and modules are stored in the ADP file (the other objects are stored in the back-end database). This centralization of queries and tables in the database server offers a more restrictive environment which appeals to certain missions.
The advantage of an ADP is that it supports the direct creation and editing of SQL Server tables, views, and stored procedures. The disadvantage compared to the native Access database is the inability to keep temporary tables (the ADP cannot store local tables) or link to data from other sources. By definition, this eliminates the ability to query across different data sources. As a result of these limitations and improvements to the native Access database, Microsoft is recommending the use of linked tables in Access for getting to SQL Server data rather than ADPs.