如何通过局域网访问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屋!