Microsoft access is a mere file or data-base server

Question

A database-server serves all requests, weather coming from local-host or remote client and to listen any request, a database server must run on a port to listen requests on that port.

As far as i know, Microsoft access don't run on any port, and it is not possible to request Microsoft access on remote machine using

DriverManager.getConnection("URL", "user", "password");

but possible if your data-source is MySql, Oracle, etc... using,

DriverManager.getConnection("jdbc:mysql://ipAddress:portNo./schemaName", "user", "password");

(if i am wrong, please correct me).

Please u guys here help me with the concept, weather Microsoft access is a

a mere file for storing data (because it don't runs on any port),

or a database server (because for Microsoft-access Type-1 driver is available , it means it must be a data-source because drivers are only available for data sources).

Answer 1

Access does not provide networked connectivity beyond a file share. There is no "Access" port.

Answer 2

Access is not a database to begin with.

It is an application development environment that ships with a default database engine, Jet (or ACE in A2007, which is just an updated version of Jet), and that uses Jet MDBs or ACE ACCDBs for storing its application objects.

Your question is not about Access. It is about the Jet database engine.

Jet is not a server database. There is no process running on the server through which all communication with the Jet data store is managed.

Instead, Jet is a file-based database system. Each user runs Jet locally in memory, and opens the database file in shared mode. Locking of the database file is managed via the LDB file.

ODBC does not provide server functionality to Jet data. It is simply another user of a file.