多个pc和1个微软访问数据库 [英] multiple pc and 1 microsoft access Database

问题描述

朋友您好我使用microsoft access 2007作为数据库



我有5台PC在局域网我想只使用一个数据库，但我的项目在所有5台PC'' s，



在Sql Server中没有问题，但我是MS Access的新用户



所以寻找有关连接字符串或解决方案的详细信息..



寻求您的帮助



谢谢

Hello friends I Using microsoft access 2007 as Database

I Have 5 PC In LAN I wanted to Use Only One Database but My Project In All 5 PC''s,

There Is No Problem In Sql Server But I Am New in MS Access

So Looking For Detailed Information Of Connection String or solution..

Looking for your help

Thanks

推荐答案

MS Access不是共享数据库的更好解决方案。

访问有许多并发问题，但我不认为如果你的用户数超过你可能有问题，5个并发用户会崩溃。



但是如你所愿/>


http：// www。 microsoft.com/en-us/download/details.aspx?id=23734 [ ^ ]



基本访问权限

http://www.c-sharpcorner.com/uploadfile/puranindia/ado-net- application-using-ms-access-2007-database / [ ^ ]



http://richnewman.wordpress.com/2007/ 08/25 / a-beginner％E2％80％99s-guide-to-calling-a-net-library-from-access / [ ^ ]

Hi,

MS Access is not a better solution for Shared Database.
Access have many concurrency problems but I dont think it will crash for 5 concurrent users if your user count exceed then you may have problem.

But as you wish

http://www.microsoft.com/en-us/download/details.aspx?id=23734[^]

Basic OF Ms Access
http://www.c-sharpcorner.com/uploadfile/puranindia/ado-net-application-using-ms-access-2007-database/[^]

http://richnewman.wordpress.com/2007/08/25/a-beginner%E2%80%99s-guide-to-calling-a-net-library-from-access/[^]

感谢回复但我会解决....



我把我的主电脑的连接STRI这将解决...





答案是：



公共静态字符串strFile = @" \\ [IP地址] \ [共享文件夹名称] \Project \Database \ dateateBaseName.accdb" ;;

Thanks For Reply But I''ll Solved ....

I Put My Main PC''s Connection String And It will Solved...


Ans Is :

public static string strFile = @"\\[IP Address]\[Share Folder Name]\Project\Database\dateBaseName.accdb";

这篇关于多个pc和1个微软访问数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！