将MS Office 2007 db与 [英] connect ms office 2007 db with
本文介绍了将MS Office 2007 db与的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
先生
我使用vb.net 2008作为前端,使用MS Access 2007作为后端.我想用局域网连接来自三台以上计算机的一个数据库.谁能说出这个的连接字符串.
谢谢
sir
i using vb.net 2008 as a front end and MS Access 2007 as a back end. I want to connect one database from more than three machine with in LAN. Can any one say connection string for this one.
Thank you
推荐答案
连接字符串相同...
1)与MS Access 2007数据库共享文件夹(例如说MyDatabase
).
2)在每台前端计算机上,使用驱动器号将此文件夹添加到已映射文件夹的集合中(例如:G:\
).怎么样?
http://www.lostintechnology.com/how-to /how-to-map-a-network-drive-or-folder/ [ http://www.makeuseof.com /tag/how-to-map-a-local-windows-folder-to-a-drive-letter/ [ http://www.connectionstrings.com/access-2007 [ ^ ]
请记住,您的数据库位于G:\
(映射的文件夹)驱动器上;)
The connection string is the same...
1) Share the folder with MS Access 2007 database (let sayMyDatabase
).
2) On each front-end machine, add this folder to the collection of mapped folders, using drive letter (let say:G:\
). How?
http://www.lostintechnology.com/how-to/how-to-map-a-network-drive-or-folder/[^]
http://www.makeuseof.com/tag/how-to-map-a-local-windows-folder-to-a-drive-letter/[^]
Here, you''ll find the connection string: http://www.connectionstrings.com/access-2007[^]
Remeber, your database is onG:\
(mapped folder) drive ;)
这篇关于将MS Office 2007 db与的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文