新的MS Access管理员，如何修改现有的宏 [英] New admin for MS Access, how to modify existing macro

问题描述

我是MS Access数据库的新管理员.我对MS Access还是很陌生，所以如果我在这里问不合理的话，请原谅我.

I'm a new admin for an MS access database. I'm very new to MS Access so please forgive me if I ask something that does not make sense here....

当前员工的桌面上有一个很小的(.5MB左右).mdb文件.单击该文件将打开访问权限，并在访问权限的左侧列出查询.我已将此文件复制到我的笔记本电脑中，以开始工作/维护数据库器.但是，单击任何查询都会产生错误(提示加载/运行)，该错误实质上表明找不到网络位置(文件).

The current staff has a small (5MB or so) .mdb file on their desktop. Clicking that file opens access and lists queries on the left hand side of Access. I've copied this file to my laptop in an effort to start working/maintaining the databaser. However clicking any query yields in an error (vice loading/running) that essentially says the network location (file) cannot be found.

其台式机上的.mdb文件包含通过网络共享加载主.mdb文件(33MB更大)的宏.但是，当我从桌面打开此.mdb文件并通过宏"选项卡查看宏时，我看不到任何试图从网络共享中加载.mdb文件的宏.此外，某些宏也会失败.其中之一就是尝试通过网络共享加载主.mdb文件.我的桌面上有主要的.mdb文件，除其他事项外，我想更改该宏以使其指向本地副本与该宏所指向的网络副本.旨在根据需要修改此类宏的.mdb文件中的所有宏的最佳方法是什么?

The .mdb file on their desktops includes macros to load the main .mdb file (much bigger at 33MB) via a network share. Yet when I open this .mdb file from my desktop and view the macros via the macro tab I do not see any macro that tries to load the .mdb file from the network share. Additionally some of the macros fail. One in particluar is trying to load the main .mdb file over the network share. I have the main .mdb file on my desktop and would like to change, amongst other things, that macro to point to the local copy vs. the network copy to which the macro points. What is the best way to view all macros in an .mdb file of this nature with the intent on modifying them as needed?

我还应该提到我在笔记本电脑上安装了Access的新版本(2010年).其他所有人都在使用2003.Unfortunatley由于公司政策，我无法在笔记本电脑上安装旧版本.当人们经常使用数据库时，理想情况下，我需要在运行2010的笔记本电脑上修改.mdb文件.

I should also mention that I have a new version of Access on my laptop (2010). Everyone else is using 2003. Unfortunatley I am unable to install the old version on my laptop due to corporate policy. As people use the database regulary I ideally need to modify the .mdb file on my laptop which runs 2010...

推荐答案

我怀疑您遇到宏或VBA问题.

I doubt you're having macro or VBA problems.

更有可能的是，您在屏幕左侧看到的表实际上是驻留在网络上其他数据库中的附加"表.

What is far more likely is that the tables you see listed on the left hand of the screen are actually "Attached" tables which reside in the other database on the network.

在这种情况下，每个表格名称左侧的图标将带有一个小箭头.

If this is the case, the icon just to the left of each table name will have a small arrow.

您说您现在在PC上本地有一个较大数据库的副本，因此您要做的是转到较小的DB，然后在外部数据"下选择链接表管理器".

You say you now have a copy of the larger database locally on your PC, so what you need to do is to is go to the smaller DB, and under "External Data" choose "Linked Table Manager."

选择所有显示它们已附加到较大数据库的服务器版本的表，选择始终提示输入新位置"，然后单击确定".

Select all of the tables which show they are attached to the server version of the larger DB, choose "Always Prompt for New Location" and click "OK."

系统将为您提供打开文件对话"，使您可以浏览到较大数据库的 local 副本.只需单击该文件名，然后单击确定"或完成"或任何其他按钮即可.

You will be given an "Open File Dialogue" which will allow you to browse to your local copy of the larger database. Simply click on that file name and click "OK" or "Done" or whatever button means you're done.

这篇关于新的MS Access管理员，如何修改现有的宏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！