阅读MSysACEs [英] Read MSysACEs
问题描述
Acees 2000中有各种隐藏表，包括MSysACEs
Engine中的所有者（我认为是Microsoft Jet Engine）;我无法读取
数据或更改权限。任何想法
谢谢
Phil
There are various hidden tables in Acees 2000 including MSysACEs
The owner in Engine (I presume the Microsoft Jet Engine); I can''t read the
data or change the permissions. Any ideas
Thanks
Phil
推荐答案
" ;菲尔斯坦顿 < ph ** @ stantonfamily.co.ukwrote在
新闻：45 ********************** @ ptn-nntp- reader02.plus.net:
"Phil Stanton" <ph**@stantonfamily.co.ukwrote in
news:45**********************@ptn-nntp-reader02.plus.net:
Acees 2000中有各种隐藏表，包括MSysACEs
Engine的所有者（I假定Microsoft Jet Engine）;我不能
读取数据或更改权限。任何想法
There are various hidden tables in Acees 2000 including MSysACEs
The owner in Engine (I presume the Microsoft Jet Engine); I can''t
read the data or change the permissions. Any ideas
嗯，你为什么关心它里面有什么？
事实上你是禁止看到数据可能是一个很好的迹象表明你没有生意看到它。
-
David W 。芬顿 http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
我创建了一个分析其他数据库的数据库 - 例如它
会告诉你所有查询的使用位置（例如表格，报告，以及
子查询，组合框等）
它会告诉你所有表格的使用位置（可能是子表格）和
在它们中使用了什么查询或SQL（例如作为组合框的来源）。
它会告诉你所有com的所有来源说一个表格的形状
（查询，表格，子表格等）
大部分信息是从隐藏表中提取的，但我正在尝试/>
找出表格，查询报告和表格属性的信息
是隐藏的
Phil
" David W. Fenton" < XX ******* @ dfenton.com.invalidwrote in message
news：Xn ********************* *************@127.0.0。 1 ...
I have created a database that analyses other databases - for example it
will tell you where all the queries are used (eg forms, reports, and as
subqueries, combo boxes etc)
It will tell you where all the forms are used (possibly as subforms) and
what queries or SQLs are used in them (eg as a source of a combo box).
It will tell you all the source of all the components of say a form
(queries, tables, subforms etc)
Most of the information is extracted from the hidden tables, but I am trying
to find out where the information on form, query report and table properties
are hidden
Phil
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...
" Phil Stanton" < ph ** @ stantonfamily.co.ukwrote在
新闻：45 ********************** @ ptn-nntp- reader02.plus.net:
"Phil Stanton" <ph**@stantonfamily.co.ukwrote in
news:45**********************@ptn-nntp-reader02.plus.net:
> Acees 2000中有各种隐藏表，包括MSysACEs
引擎的所有者（我推测Microsoft Jet Engine）;我无法读取数据或更改权限。任何想法
>There are various hidden tables in Acees 2000 including MSysACEs
The owner in Engine (I presume the Microsoft Jet Engine); I can''t
read the data or change the permissions. Any ideas
嗯，为什么你在乎它里面有什么？
事实上你是禁止看到数据可能是一个很好的迹象表明你没有生意看到它。
-
David W 。芬顿 http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
" Phil Stanton"写了
"Phil Stanton" wrote
>我创建了一个分析其他数据库的数据库 - 例如它
会告诉你所有查询的使用位置（例如表格，报告） ，以及
子查询，组合框等）
它会告诉你所有表格的使用位置（可能是子表格）和
是什么在它们中使用了查询或SQL（例如作为组合框的来源）。
它会告诉你所有组件的所有来源说一个表格
（查询，表格，子表格等）
大部分信息都是从隐藏表中提取的，但是我想要找出b
$ b关于表格，查询报告和表格的信息
属性是隐藏的
Phil
>I have created a database that analyses other databases - for example it
will tell you where all the queries are used (eg forms, reports, and as
subqueries, combo boxes etc)
It will tell you where all the forms are used (possibly as subforms) and
what queries or SQLs are used in them (eg as a source of a combo box).
It will tell you all the source of all the components of say a form
(queries, tables, subforms etc)
Most of the information is extracted from the hidden tables, but I am
trying to find out where the information on form, query report and table
properties are hidden
Phil
Most ，或许所有你需要的信息来实现你的目的
是以一种形式在数据库中维护的，这样你就可以通过
来获得它的对象模型，是博士umented。系统表没有记录，
并且由于某种原因它们没有记录 - 它们可能会改变。可能
，Access 2002和2003之间的系统表没有变化，
，因为特定于Access的变化非常少。但是每隔一对Access版本之间的系统表有一些改变。因此，
我建议你研究对象模型，集合，容器和
属性。
鉴于Access 2003和2007之间发生了许多重大变化，我希望
期望系统表中出现同样多的变化。
但是，如果你想知道什么是MSysACES，这里有一些代码是'b
$ b开始。请注意，我使用Object
模型访问了TableDef，它的Fields集合以及使用数据访问对象代码的字段的
属性，而不是通过读取MSysACES表直。 （不，我不能在UI中查看
MSysACES，或者......我得到关于权限的相同消息框
你做的。）为了你想要做，你能够在用户界面中查看该表是不是很重要，只有你能够从中获取
来自它的数据。您可以，而不是使用Debug.Print打印到
立即窗口，定义表并将数据保存在表格中，这将更简单地用于报告等等。你可以自己决定使用Fields的原因是什么，以及这些属性是什么意思。我没有包括
我确定了一个字段属性的属性
的步骤，你可以复制/修改一些代码来获取
属性属性（我注意这里有4个，在这里所有情况下）。
Sub ShowTable（）
Dim db作为DAO.Database
Dim td作为DAO.TableDef
Dim fld作为DAO.Field
Dim prop作为DAO.Property
设置db = CurrentDb
每个td in db.TableDefs
如果td.Name =" MSysACES"然后
Debug.Print" Table" &安培; td.Name
对于每个fld在td.Fields
Debug.Print"字段 &安培; fld.Name，道具 &
fld.Properties.Count
For f prop in fld.Properties
Debug.Print" " &安培; prop.Name; ：type &
prop.Type;英寸;继承的&安培; prop.Inherited;英寸; with;
prop.Properties.Count; "属性
下一页
下一页
结束如果
下一页
设置db =没什么
结束子
你打算和FMS竞争吗？你想要的是什么？
听起来很像他们的一些Access工具，或者一些来自
mztools，或MVP Jeff Conrad在他的网站上提供的一些免费软件
at http://home.bendbroadband.com/conrad ... essjunkie.html 。如果你不打算出售这个应用程序，也许你可以通过查看已有的东西来节省很多麻烦。
Larry Linson
Microsoft Access MVP
Most, probably all, of the information you need to accomplish your purpose
is maintained in the database in a form so that you can get to it through
the object model, which is documented. The system tables are undocumented,
and they are undocumented for a reason -- they may change. It is possible
that there was no change to system tables between Access 2002 and 2003,
because there were very few Access-specific changes. But there has been some
change to System Tables between every other pair of Access releases. Thus,
I''d suggest you study the Object Model, Collections, Containers, and
Properties.
Given the many and dramatic changes between Access 2003 and 2007, I would
expect equally many and dramatic changes in the System Tables.
But, if you want to know what is in MSysACES, here''s some code that''s a
start. Note that I accessed the TableDef, its Fields collection, and the
Properties of the Fields using Data Access Objects code, using the Object
Model, NOT by reading the MSysACES table directly. (No, I can''t view
MSysACES in the UI, either... I get the same message box about permissions
that you do.) For what you want to do, it''s not important that you be able
to view that table in the user interface, only that you be able to obtain
the data from it. You can, instead of using Debug.Print to print to the
Immediate Window, define tables and save the data in tables that will be
simpler to use for reporting, etc. You are on your own to determine what
the Fields are used for, and what those Properties mean. I haven''t included
the step where I determined what the Properties of the Properties of a Field
were, and you can copy/modify some of the code to get the Properties of the
Properties of the Properties (I note there are 4, in all cases here).
Sub ShowTable()
Dim db As DAO.Database
Dim td As DAO.TableDef
Dim fld As DAO.Field
Dim prop As DAO.Property
Set db = CurrentDb
For Each td In db.TableDefs
If td.Name = "MSysACES" Then
Debug.Print "Table " & td.Name
For Each fld In td.Fields
Debug.Print " Field " & fld.Name, "Props " &
fld.Properties.Count
For Each prop In fld.Properties
Debug.Print " " & prop.Name; ": type " &
prop.Type; "; inherited " & prop.Inherited; "; with ";
prop.Properties.Count; " properties "
Next
Next
End If
Next
Set db = Nothing
End Sub
Do you intend to go into competition with FMS? What you are trying to
accomplish sounds much like some of their Access tools, or some from
mztools, or some freeware that MVP Jeff Conrad has available on his website
at http://home.bendbroadband.com/conrad...essjunkie.html. If you
aren''t planning on selling this application, perhaps you can save yourself a
lot of trouble by looking into what''s already available.
Larry Linson
Microsoft Access MVP
这篇关于阅读MSysACEs的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
