如何找到链接到我的表的远程数据库？ [英] How do I find the remote DB's that link to my tables?
问题描述
我们使用Access 97.在大多数情况下，我们正在使用SQL以
迁移到2003。我们有一个包含
非常重要的表的生产数据库，我们想知道我们的网络链接到这个表的其他数据库
。
原因是因为我们计划在这个
表中添加/删除某些字段，当我们把它放在SQL中时我们想提前知道
哪个数据库会受此影响。
我似乎记得一个报告，它会告诉我哪些其他数据库
链接到我的特定表数据库。
谢谢
这里有一个快速''n''脏的方式获取链接表的列表以及它们与
链接的内容：
函数ShowConnect（）
Dim db作为DAO.Database
Dim tdf作为DAO.TableDef
设置db = CurrentDb（）
For每个tdf在db.TableDefs中
If（tdf.Attributes和dbSystemObject）= 0然后
如果tdf.Connect<> vbNullString然后
Debug.Print tdf.Name，tdf.Connect
结束如果
结束如果
下一步
设置tdf = Nothing
设置db = Nothing
结束功能
- -
Allen Browne - 微软MVP。西澳大利亚州珀斯。
访问用户提示 - http：// allenbrowne.com/tips.html
回复群组，而不是mvps dot org的allenbrowne。
" Bruce Lawrence" < BL ***** @ gmail.com>在消息中写道
news：11 ******************** @ f14g2000cwb.googlegrou ps.com ...我们使用Access 97.在大多数情况下，我们正在使用SQL迁移到2003年。我们有一个生产数据库，其中包含一个非常重要的表格，我们想知道我们网络上哪些其他数据库链接到这个表格。
原因是因为我们计划当我们把它放在SQL中时添加/删除这个表中的某些字段但是我们希望提前知道
哪些数据库会受此影响。
我好像记住一个报告，告诉我哪些其他数据库链接到我数据库中的特定表。
谢谢
< blockquote>这到底是做什么的？从我可以告诉它打印出一个列表
我的数据库中的链接表和他们去哪里？如果是这样......它的关闭
但不是quiiiite我正在寻找的东西。
我有一个带有一个名为OPENORD的表的数据库。我想知道我网络上其他数据库链接到该OPENORD表的内容是什么
。
你描述的情况反映了忽视或无能为力
的管理层。拥有一个重要的数据库是不应该的，而不是
关于它的所有内容的完整文档。移动到你的任何地方
的意思是SQL可能会使情况恶化..
聘请知识渊博且能干的数据库管理员。
We use Access 97. We are in the process of migrating to 2003 along
with SQL in most cases. We have a production database that contains a
pretty important table and we would like to know which other databases
on our network link to this table.
The reason is because we plan to add/remove certain fields in this
table when we put it in SQL but we would like to know ahead of time
which databases will be affected by this.
I seem to remember a report that would show me which other databases
are linking to specific tables in my database.
Thanks
Here''s a quick''n''dirty way to get a list of the linked tables and what they
are linked to:
Function ShowConnect()
Dim db As DAO.Database
Dim tdf As DAO.TableDef
Set db = CurrentDb()
For Each tdf In db.TableDefs
If (tdf.Attributes And dbSystemObject) = 0 Then
If tdf.Connect <> vbNullString Then
Debug.Print tdf.Name, tdf.Connect
End If
End If
Next
Set tdf = Nothing
Set db = Nothing
End Function
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Bruce Lawrence" <BL*****@gmail.com> wrote in message
news:11********************@f14g2000cwb.googlegrou ps.com...We use Access 97. We are in the process of migrating to 2003 along
with SQL in most cases. We have a production database that contains a
pretty important table and we would like to know which other databases
on our network link to this table.
The reason is because we plan to add/remove certain fields in this
table when we put it in SQL but we would like to know ahead of time
which databases will be affected by this.
I seem to remember a report that would show me which other databases
are linking to specific tables in my database.
Thanks
What exactly does this do? From what I can tell it prints off a list
of linked tables in my database and where they go? If so... its close
but not quiiiite what I''m looking for.
I have a DB with a table in it called OPENORD. I want to know what
other databases on my network link to that OPENORD table.
The situation you describe reflects neglect or incompetence on the part
of management. It''s reprehensible to have an important database without
complete documentation of everything about it. Moving to whatever you
mean by "SQL" is likely to worsen the situation..
Hire a knowledgeable and capable database administrator.
这篇关于如何找到链接到我的表的远程数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
