网络数据库访问 [英] Networked Database Access

问题描述

大家好.我正在制作一个图书馆管理系统，该系统到目前为止可以使用Microsoft Access数据库正常运行.唯一的问题是，它只能在数据库驻留在PC上的封闭设置中工作.由于大型图书馆同时为许多人提供服务，因此我需要一个图书馆系统在一个有5台计算机ATMOST的网络环境中工作.
我从来没有为网络环境编写过一个应用程序(好的，所以这只是一个菜鸟，但是，每个人都从一个人开始)，所以我非常感谢您提供帮助，帮助您设置一个由最多5台PC组成的小型网络，包括可能需要的任何其他硬件.它很容易访问硬盘驱动器上的数据库，但是如果它位于另一台计算机上，那么如何指定其路径呢?熟悉连接字符串，我实际上一直在使用oleDB类，因此将非常欢迎任何代码.我知道您可能不愿使用MS Access，但是我所拥有的一切加上它可以很好地处理多个连接(如果它们不多的话)，就像我的情况一样.

Hi guys. Am making a library management system which so far works well using a Microsoft Access database. The only problem is that it works only in a closed setup whereby the database resides on the PC. It has come to a point where I need the library system to work in a networked environment of say 5 computers ATMOST since large libraries serve many people simultaneously.
I''ve never programmed an app for a networked environment (ok, so am just a noob but hey, everyone starts off as one) so I''d appreciate any help on how to setup a small network of at most 5 PCs including any additional hardware that may be required. Its easy accessing a database on your harddrive but how do you specify its path if its located on another computer? Am familiar with connection strings,the oleDB classes which i''ve actually been using so any code will be highly welcomed. I know you may discourage using MS Access but its all i''ve got plus it handles multiple connections nicely if they aren''t too many, just like my case.

推荐答案

您可以使用外部rdbms进行访问''，例如 Microsoft SQL Server Express [

You can use access with external rdbms'' like Microsoft SQL Server Express[^].

There are tools provided that allows you to upgrade your access solution to MS SQL Server.

(The reason many of us frown on Access, isn''t that we like to look down our noses at access developers, it''s based on the number of times we''ve run into serious trouble with the product)

Regards
Espen Harlinn

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