What is an MS Access Project?
Microsoft Access Project gives you access to data stored on SQL Servers via familiar OLEDB technology. With an MS Access Project you can work in the client/server mode as easily as in the file server mode, which you could do with earlier (prior 20 Access 2000) versions. With the Access Project construct, Microsoft has extended the playground of MS Access to the RDBMS arena. The data is all stored in the SQL Server (or, its junior version, MSDE), but the Access application will have access to this data by the OLEDB connectivity which can be implemented in the Access application (or by establishing a connection outside the application) as you will see in this tutorial.

These are some of the significant items to remember with regard to MS Access projects.

The Project file has an *.adp extension and not *.mdb, or *.mde.
The Project file does not have tables or queries. The SQL 2000
server stores tables and views.
SQL Server stored procedures replace Access's action queries.
The project connects to SQL Server by OLEDB and not by
ODBC or Jet.