Access as an RDBMS
An Access desktop database (.accdb or .mdb) is a fully functional RDBMS. It provides all the data definition, data manipulation, and data control features that you need to manage large volumes of data. If you’re using an Access Services web app, SQL Server serves as the RDBMS.
You can use an Access desktop database (.accdb or .mdb) either as a stand-alone RDBMS on a single workstation or in a shared client/server mode across a network. A desktop database can also act as the data source for data displayed on webpages on your company intranet. When you build an application with an Access desktop database, Access is the RDBMS.
Access 2000, Access 2002 (XP), and Access 2003 databases use the .mdb file format, but beginning with ...