如何在具有MS访问数据库应用程序的vb.net中建立LAN连接 [英] how to establish LAN connectivity in vb.net with MS access database application

问题描述

我有一个链接到OleDb数据库的vb.net应用程序。

我想在其中建立LAN连接，以便它以3个pc运行，一个PC充当服务器，任何PC都可以更新数据库。

这可能吗？

I have a vb.net application linked to OleDb database.
I want to establish LAN connectivity in it so that it runs in 3 pc and one pc act as server and any pc can update database.
So is this possible?

推荐答案

首先，对于多用户系统来说，Access是一个糟糕的选择。



其次，Access是基于文件的数据库引擎，只有客户端计算机对存储数据库文件的共享具有SMB访问权限（Windows文件共享）才能工作。用户还需要对共享的读写访问权限才能打开数据库。这是一个安全风险。



您必须确保正确设置适当的NTFS和共享权限，否则您可能会意外或故意发现某人，删除了数据库文件及其所有数据。

First, Access is a poor choice for a multi-user system.

Second, Access is a file-based database engine and only works so long as the client machines have SMB access (Windows File Sharing) to the Share where the database file is stored. Users will also need Read AND Write access to the share in order to even open the database. This is a security risk.

You're going to have to make sure that appropriate NTFS and Share permissions are set correctly or else you might find someone accidentally, or intentionally, deleted the database file and all the data with it.

这篇关于如何在具有MS访问数据库应用程序的vb.net中建立LAN连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！