如何通过局域网访问MS-Access数据库? [英] How to access MS-Access Database over Lan?

问题描述

我是Srinivas，

在我的Windows窗体应用程序中，我正在使用MS-Access数据库，在这里我要连接位于另一个系统共享文件夹中的数据库.

以下是连接字符串:

i am Srinivas,

in my Windows-Forms Application i am using MS-Access database, here i want to connect database which is located in another system shared folder.

The following is the connection string:

string strconn = "Provider=MS Remote; Remote Server=192.168.200.168; Remote Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:/LAN_Testing_Windows/LAN_Test.mdb;";

上面的代码是完美的作品，我能够使用上面的连接字符串连接到数据库，但是当我执行任何操作(如插入，更新，删除等)时，它会返回错误

错误是:

无法创建业务对象.

请帮帮我.

谢谢
D. Srinivasa Rao，

the above code is works perfectly, i am able to connect to the database with above connection string, but when i perform any operation like Insert, update, delete etc. it returns an error

Error is :

Business Object Cannot be Created.

Please help me.

Thanks
D. Srinivasa Rao,

推荐答案

可能是您没有所连接文件/文件夹的权限.在计算机上检查共享它们，以确保您具有写许可权.

顺便说一句:您是否意识到直接在多用户中使用Access文件是一个痛苦的过程?除非您是唯一更新此数据库的用户，否则我强烈建议您将其附加到SQL Server实例上...

Chances are you don''t have permissions for the file / folder that you are connecting to. Check on the machine the shares them, to ensure that you have write permission.

BTW: You do realize that using Access files directly in multiuser is a process full of pain? Unless you are the only user updating this database I would strongly suggest you attach it to an SQL server instance instead...

这篇关于如何通过局域网访问MS-Access数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！