VB6与MS ACCESS 2007 [英] VB6 with MS ACCESS 2007

问题描述

我使用VB6和Ms Access（后端）创建了一个应用程序，它使用台式PC工作正常。如果我要将数据库放在服务器中，我必须更改我的任何代码（连接字符串等）。我可以将MS Office安装到服务器计算机吗？请帮忙。谢谢

I created an application using VB6 and Ms Access(Back End) it works fine using Desktop PC. If i'm going to put the database in a server do i have to change any of my codes(connection string, etc.). Can i install MS Office to a server computer? Please help. thanks

推荐答案

您不需要安装Office来访问mdb或accdb文件，您只需要在服务器上使用正确的ODBC驱动程序即可。您需要更改连接字符串以连接到服务器上的正确位置，这实际上取决于您访问服务器的方式。



您是否使用网络凭据将其安装到本地LAN上的服务器？您想将其上传到网站并在那里访问吗？在我们说出如何更改连接字符串以及您的连接方法是否有效之前，需要获取有关您的预期用途的更多信息。请发布您的连接字符串和相关代码部分以连接到DB（当然删除任何密码）。

You don't need to install Office to access an mdb or accdb file, all you need are the proper ODBC drivers available on the server. You will need to change your connection string to connect to the proper place on the server, it really depends on how you access the server.

Are you installing it to a server on a local LAN with network credentials? Are you wanting to upload it to a website and access it there? Need to get more information about your intended usage before we can say how to change the connection string and if your method of connecting will work. Please post your connection string and relevant code section for connecting to the DB (removing any passwords of course).

首先，Access是一个DESKTOP，基于文件的数据库，并非真正设计用于多用户访问。为了让您的客户端使用Access数据库，数据库文件必须位于服务器上的文件共享上，使用该数据库的每个人都具有读取和写入访问权限。这会带来安全问题。



是的，您必须修改连接字符串以将其指向数据库文件的位置。



报废并切换到SQL Server或其他一些通过TCP / IP工作的真实数据库引擎。

First, Access is a DESKTOP, file-based, database, not really designed for multiuser access. In order for your clients to use an Access database, the database file would have to be on file share on a server that everyone who uses the database has both read and WRITE access to. This poses security problems.

Yes, you would have to modify the connection string to point it at the location of the database file.

Scrap this and switch to SQL Server or some other real database engine that works over TCP/IP.

这篇关于VB6与MS ACCESS 2007的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！