使用具有网络驱动器的拆分Access 2007数据库 [英] Using a split Access 2007 database with a networked drive

问题描述

我被一个小组询问，该小组使用我作为临时业务基地的地方来创建一个存储员工信息的数据库。 目前，我已经使用Access 2007的Split功能来创建一个后端系统，该系统目前位于网络驱动器上，价格为
。 如何设置安装程序包以指向该服务器以查找后端数据库以使应用程序正常运行？

I have been asked by a group that uses the place where I work as temporary base of operations to create a database to store employee information.  As it stands, I have used Access 2007's Split function to create a back-end system that is currently located on a networked drive.  How can I set up the installer package to point to that server to find the back end database in order to allow the application to function correctly?

推荐答案

您不能用标准的Packager做到这一点。您必须包含要重新链接的代码，或者必须首先重新链接表（如果您提前了解后端的最终位置）。

You can't do that with the standard Packager. You must instead include code to relink, or you must first relink your tables (if you know the final location of the backend ahead of time).

最简单的方法是重新链接表：

The simplest way is to relink your tables:

1）放置你的"后端" （即数据表）在共享网络驱动器文件夹上。确保您的用户都可以访问此文件夹，并确保为所有用户提供该文件夹的至少修改权限

1) Place your "backend" (i.e. the data tables) on a shared network drive folder. Make SURE that your users can all reach this folder, and make sure to provide all users with at least Modify permissions on that folder

2）链接您的"frontend"副本。 （即表格，报告等）到新的后端数据库位置。为此，请单击"数据库工具"功能区部分，然后找到"链接表"管理器。单击此选项，选择要重新链接的所有表格（注意：如果
查看以"MSys"开头的任何表格，请不要选择这些表格），请务必选中"新位置"。框，然后单击确定。

2) Link your copy of the "frontend" (i.e. the forms, reports, etc) to that new backend database location. To do that, click the Database Tools ribbon section, and locate the Linked Table manager. Click this, select all your tables to relink (Note: If you see any tables beginning with "MSys", don't select those), make sure to check the "new location" box, then click OK.

3）重新链接后，将FE的COPY部署到每个用户。

3) After relinking, deploy a COPY of the FE to each user.

如果您不知道最终结果位置，然后您需要包含代码，以便用户可以重新链接他们的表。以下是这样做的一个示例：
http://www.granite.ab.ca/access/relinkingtables热媒。这包括指向可用于自动执行重新链接过程的代码的链接。

If you will NOT know the final location, then you'll need to include code such that the user can relink their tables. Here's one example of doing that: http://www.granite.ab.ca/access/relinkingtables.htm. This includes a link to code that you can use to automate the relink process.

这篇关于使用具有网络驱动器的拆分Access 2007数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！