Click here to Skip to main content
16,017,207 members
Please Sign up or sign in to vote.
2.33/5 (3 votes)
See more:
I am looking for the best way to connect to an Access database which resides on a remote server.

What I have tried:

Looking for source code in c# and c / c++
Posted
Updated 25-Aug-18 5:38am

 
Share this answer
 
"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".
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900