不要链接到后端的系统表 [英] Don't link to system tables in backend
问题描述
我的前端代码手动链接到后端文件。
我想知道是什么阻止了Access链接到
后端的系统表文件。它只是凭借它们被隐藏了吗？
这最近出现了因为我一直在玩我的
前端到A2003格式。在某些时候，我有一个腐败问题与一个
系统文件MSStorage的东西。访问一直说不能找到它。
当我查看数据库窗口时，我可以看到它的链接。
所以我运行了删除所有链接然后重新启动我的应用程序的代码。在
启动时，应用程序会重新创建所有链接。这解决了腐败问题。
但它让我想到了与后端系统文件的链接。
我应该明确包含阻止链接到系统的VB代码桌子
（也许还有其他我不知道的桌子）包含在后端。
谢谢。
-
通过 http：//www.accessmonster发布的消息.com
My front-end code manually links to the backend file.
I was wondering what stops Access from linking to the system tables in the
backend file. Is it just by virtue that they are hidden?
This has recently come up because I''ve been playing around with converting my
front end to A2003 format. At some point, I had a corruption issue with a
system file MSStorage something. Access kept saying it couldn''t find it.
When I looked in the db Window I could see a link to it.
So I ran the code that deletes all links and then restarted my app. At
startup the app recreates all links. That solved the corruption problem.
But it got me thinking about the linking to backend system files.
Should I explicitly include VB Code that prevents linking to system tables
(and maybe other tables that I''m not aware of) contained in the backend.
Thanks.
--
Message posted via http://www.accessmonster.com
推荐答案
rdemyan通过AccessMonster.com写道：
rdemyan via AccessMonster.com wrote:
我的前端代码手动链接到后端文件。
我想知道什么阻止Access链接到系统表
后端文件。只是凭借它们被隐藏起来了吗？
这最近出现了因为我一直在玩
将我的前端转换为A2003格式。在某些时候，我有一个
腐败问题与系统文件MSStorage的东西。访问保持
说无法找到它。当我查看数据库窗口时，我可以
看到它的链接。
所以我运行代码删除所有链接，然后重新启动我的应用程序。
启动时，应用程序会重新创建所有链接。这解决了腐败问题。但它让我想到了连接到后端系统
文件。
我应该明确包含阻止链接到系统的VB代码
$ b
后端包含$ b表（也许还有其他我不知道的表）。
谢谢。
My front-end code manually links to the backend file.
I was wondering what stops Access from linking to the system tables
in the backend file. Is it just by virtue that they are hidden?
This has recently come up because I''ve been playing around with
converting my front end to A2003 format. At some point, I had a
corruption issue with a system file MSStorage something. Access kept
saying it couldn''t find it. When I looked in the db Window I could
see a link to it.
So I ran the code that deletes all links and then restarted my app.
At startup the app recreates all links. That solved the corruption
problem. But it got me thinking about the linking to backend system
files.
Should I explicitly include VB Code that prevents linking to system
tables (and maybe other tables that I''m not aware of) contained in
the backend.
Thanks.
我没有方便检查，但我很确定
自动链接/刷新代码这些组经常推荐使用
有逻辑来专门跳过系统表。
-
Rick Brandt， Microsoft Access MVP
电子邮件（视情况而定）至...
在Hunter dot com的RBrandt
I don''t have it handy to check, but I''m pretty sure that the
auto-linking/refreshing code that is frequently recommended in these groups does
have logic to specifically skip the system tables.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
我看了在mvps网站上的重新链接代码中，并没有看到任何向我弹出的b
。我只是一名中级程序员，所以也许我错过了它。
所以选中了在后端显示隐藏表和系统表的选项
文件然后启动我的前端。然后我在我的
前端查看dbWindow。
我可以看到系统表灰显。然而，
左侧没有箭头表示它们是链接的，除了MSysAccessXML ..
但是，这个系统表已显示为链接在我的前面结束几个月。
即使我删除链接它再次出现。它似乎没有造成
问题。
Rick Brandt写道：
I looked at the relinking code on the mvps site and didn''t see anything that
popped out at me. I''m only an intermediate level programmer so maybe I
missed it.
So checked the option to show hidden tables and system tables in my backend
file and then launched my front end. I then looked in the dbWindow on my
front end.
I can see the system tables "grayed out". However there are no arrows on the
left hand side indicating that they are linked, except for MSysAccessXML..
However, this system table has showed up as linked in my front end for months.
Even when I delete the link it reappears. It hasn''t seemed to cause a
problem, yet.
Rick Brandt wrote:
>我的前端代码手动链接到后端文件。
>My front-end code manually links to the backend file.
[引用文字剪辑 - 17行]
[quoted text clipped - 17 lines]
>>
谢谢。
>>
Thanks.
我没有方便检查，但我很确定这些组中经常推荐的
自动链接/刷新代码
有逻辑来专门跳过系统表。
I don''t have it handy to check, but I''m pretty sure that the
auto-linking/refreshing code that is frequently recommended in these groups does
have logic to specifically skip the system tables.
-
通过 http://www.accessmonster.com
--
Message posted via http://www.accessmonster.com
rdemyan通过AccessMonster.com写道：
rdemyan via AccessMonster.com wrote:
我查看了mvps网站上的重新链接代码，并没有看到
任何弹出的内容在我身边。我只是一个中级水平
程序员所以也许我错过了它。
因此选中了在我的
后端文件然后启动我的前端。然后我在前端查看了
dbWindow。
我可以看到系统表格灰显。但是左侧没有
箭头表示它们是链接的，除了
for MSysAccessXML ..但是，这个系统表已经显示为
在我的前端链接了好几个月。即使我删除链接它再次出现
。它似乎没有引起问题。
I looked at the relinking code on the mvps site and didn''t see
anything that popped out at me. I''m only an intermediate level
programmer so maybe I missed it.
So checked the option to show hidden tables and system tables in my
backend file and then launched my front end. I then looked in the
dbWindow on my front end.
I can see the system tables "grayed out". However there are no
arrows on the left hand side indicating that they are linked, except
for MSysAccessXML.. However, this system table has showed up as
linked in my front end for months. Even when I delete the link it
reappears. It hasn''t seemed to cause a problem, yet.
好的，我想看看它是如何工作的。代码遍历并且
重新创建现有链接表的链接。因此会自动跳过本地表（例如系统表中的
）。
-
Rick Brandt，Microsoft Access MVP
电子邮件（视情况而定）至...
在Hunter dot com的RBrandt
Okay I had a look to remind myself how it works. The code loops through and
recreates the links of existing linked tables. Therefore local tables (such as
the system tables) are automatically skipped.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
这篇关于不要链接到后端的系统表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
