且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

新的MS Access管理员,如何修改现有的宏

更新时间:2023-12-02 21:48:10

我怀疑您遇到宏或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.