远程连接到MS访问 [英] Connecting to MS access remotely

问题描述

我正在寻找连接到远程服务器上的Access数据库的最佳方式。



我尝试过：



在c＃和c / c ++中寻找源代码

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++

推荐答案

参见访问连接字符串 - ConnectionStrings.com [ ^ ]。

远程访问数据库并非完全远程。



Access是基于文件的数据库。没有数据库引擎服务器可以通过TCP / IP连接到SQL Server或Oracle。



数据库必须驻留在所有的共享驱动器上用户具有读写权限。



但是，Access并非设计为多用户数据库。哦，它可以作为一个使用，但你使用它的用户越多，你输入的数据越多，查询的性能就越差。这是因为数据库引擎位于客户端，使用远程文件。必须对每个要过滤的记录执行操作的查询必须将数据库的整个内容传输到客户端进行处理和过滤。



它可以是使用，但Access不是为它设计的。



使用真正的数据库引擎，如SQL Server，旨在远程工作。

"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".

这篇关于远程连接到MS访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！