Connecting to MS access remotely

"Remote" Access databases are not exactly "remote".

Access is a file-based database. There is no database engine server that you can connect to over TCP/IP like SQL Server or Oracle.

The database has to reside on a shared drive that all of the users have read and write access to.

But, Access is NOT designed as a multi-user database. Oh, it can be used as one, but the more users you have using it and the more data you push into it, the worse the performance of queries. This is because the database engine is on the client-side, using a remote file. Queries that have to do operations on each and every record to filter must transfer just about the entire content of the database to the client for processing and filtering.

It can be used, but Access isn't designed for it.

Use a real database engine, like SQL Server, that is designed to work "remotely".