473,375 Members | 1,669 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,375 software developers and data experts.

Read MSysACEs

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
Dec 5 '06 #1
10 10208
"Phil Stanton" <ph**@stantonfamily.co.ukwrote in
news:45**********************@ptn-nntp-reader02.plus.net:
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
Um, why do you care what's in it?

The fact that you're prohibited from seeing the data is probably a
good indication that you have no business seeing it.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Dec 5 '06 #2
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 in
news:45**********************@ptn-nntp-reader02.plus.net:
>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

Um, why do you care what's in it?

The fact that you're prohibited from seeing the data is probably a
good indication that you have no business seeing it.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Dec 5 '06 #3
"Phil Stanton" wrote
>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, 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

Dec 6 '06 #4
Thanks, Larry.

Looks as if I am trying to re-invent the wheel.

Code works a treat though

Phil

Will have a good loo
"Larry Linson" <bo*****@localhost.notwrote in message
news:8wqdh.2147$5D1.497@trnddc06...
"Phil Stanton" wrote
>>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, 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

Dec 6 '06 #5

"Phil Stanton" <ph**@stantonfamily.co.ukwrote in message
news:45**********************@ptn-nntp-reader02.plus.net...
Thanks, Larry.

Looks as if I am trying to re-invent the wheel.

Code works a treat though

Phil
You're welcome.

Sometimes it's fun (at least, interesting) to get down to the "brass tacks."

The first "running of the collections and containers" that I did was back in
early Access days before any of these tools were available or, at least,
before I was aware of any of them. If nothing else, it's interesting to do
enough to understand "How did they do that?"

Larry Linson
Microsoft Access MVP

Dec 8 '06 #6
Have had a quick look at FMS Demo OK, but the thing I have written shows the
relationship between objects, eg where subforms are used.

For example FMS say on their Northwind Db that the Customer Order form
contains Customer Orders Subform1 and Customer Orders Subform2. My effort
shows that Customer Orders Subform1 is used in Customer Order form.
Particularly useful in detecting queries that are not used.

Phil
"Larry Linson" <bo*****@localhost.notwrote in message
news:fg2eh.3518$hh.2392@trnddc01...
>
"Phil Stanton" <ph**@stantonfamily.co.ukwrote in message
news:45**********************@ptn-nntp-reader02.plus.net...
>Thanks, Larry.

Looks as if I am trying to re-invent the wheel.

Code works a treat though

Phil

You're welcome.

Sometimes it's fun (at least, interesting) to get down to the "brass
tacks."

The first "running of the collections and containers" that I did was back
in early Access days before any of these tools were available or, at
least, before I was aware of any of them. If nothing else, it's
interesting to do enough to understand "How did they do that?"

Larry Linson
Microsoft Access MVP

Dec 8 '06 #7
My recollection, from the last time I looked at TAA, was that there are more
options than I cared to try to remember. Thus, there _may_ be a report, or
option, to do what you want, even if it is not the "default."

But, they may not have a report, or option, to show all objects in the way
that you want to see them -- did you look at the code at Jeff Conrad's site?

Larry Linson
Microsoft Access MVP

"Phil Stanton" <ph**@stantonfamily.co.ukwrote in message
news:45**********************@ptn-nntp-reader02.plus.net...
Have had a quick look at FMS Demo OK, but the thing I have written shows
the relationship between objects, eg where subforms are used.

For example FMS say on their Northwind Db that the Customer Order form
contains Customer Orders Subform1 and Customer Orders Subform2. My effort
shows that Customer Orders Subform1 is used in Customer Order form.
Particularly useful in detecting queries that are not used.

Phil
"Larry Linson" <bo*****@localhost.notwrote in message
news:fg2eh.3518$hh.2392@trnddc01...
>>
"Phil Stanton" <ph**@stantonfamily.co.ukwrote in message
news:45**********************@ptn-nntp-reader02.plus.net...
>>Thanks, Larry.

Looks as if I am trying to re-invent the wheel.

Code works a treat though

Phil

You're welcome.

Sometimes it's fun (at least, interesting) to get down to the "brass
tacks."

The first "running of the collections and containers" that I did was back
in early Access days before any of these tools were available or, at
least, before I was aware of any of them. If nothing else, it's
interesting to do enough to understand "How did they do that?"

Larry Linson
Microsoft Access MVP


Dec 8 '06 #8
The information on Jeff Conrad's site indicates that as with FMS the
principal is "here is an object and this is what is in it" as opposed to
"here is an object and this is where it's used"

Can't be sure of my facts as the demo program has a number of restrictions
and I cant afford 150 ( even with the good $ to rate)

Phil

"Larry Linson" <bo*****@localhost.notwrote in message
news:%P4eh.242$7h.117@trnddc02...
My recollection, from the last time I looked at TAA, was that there are
more options than I cared to try to remember. Thus, there _may_ be a
report, or option, to do what you want, even if it is not the "default."

But, they may not have a report, or option, to show all objects in the way
that you want to see them -- did you look at the code at Jeff Conrad's
site?

Larry Linson
Microsoft Access MVP

"Phil Stanton" <ph**@stantonfamily.co.ukwrote in message
news:45**********************@ptn-nntp-reader02.plus.net...
>Have had a quick look at FMS Demo OK, but the thing I have written shows
the relationship between objects, eg where subforms are used.

For example FMS say on their Northwind Db that the Customer Order form
contains Customer Orders Subform1 and Customer Orders Subform2. My effort
shows that Customer Orders Subform1 is used in Customer Order form.
Particularly useful in detecting queries that are not used.

Phil
"Larry Linson" <bo*****@localhost.notwrote in message
news:fg2eh.3518$hh.2392@trnddc01...
>>>
"Phil Stanton" <ph**@stantonfamily.co.ukwrote in message
news:45**********************@ptn-nntp-reader02.plus.net...
Thanks, Larry.

Looks as if I am trying to re-invent the wheel.

Code works a treat though

Phil

You're welcome.

Sometimes it's fun (at least, interesting) to get down to the "brass
tacks."

The first "running of the collections and containers" that I did was
back in early Access days before any of these tools were available or,
at least, before I was aware of any of them. If nothing else, it's
interesting to do enough to understand "How did they do that?"

Larry Linson
Microsoft Access MVP



Dec 8 '06 #9
"Phil Stanton" <ph**@stantonfamily.co.ukwrote in
news:45**********************@ptn-nntp-reader02.plus.net:
The information on Jeff Conrad's site indicates that as with FMS
the principal is "here is an object and this is what is in it" as
opposed to "here is an object and this is where it's used"
Have you considered that for about $100 you could get SpeedFerret to
do all of this for you?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Dec 8 '06 #10
Forgotten about that one. Had it on my old PC but rarely used it.

Will download it again

Thanks

Phil
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...
"Phil Stanton" <ph**@stantonfamily.co.ukwrote in
news:45**********************@ptn-nntp-reader02.plus.net:
>The information on Jeff Conrad's site indicates that as with FMS
the principal is "here is an object and this is what is in it" as
opposed to "here is an object and this is where it's used"

Have you considered that for about $100 you could get SpeedFerret to
do all of this for you?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Dec 11 '06 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Gunnar | last post by:
Hello, I've just written a CPP program that reads integers from a binary file, and used this code while (my_ifstram.read( (char* ) &number, sizeof(int)) { // do something with number } My...
11
by: Markus Breuer | last post by:
I have a question about oracle commit and transactions. Following scenario: Process A performs a single sql-INSERT into a table and commits the transaction. Then he informs process B (ipc) to...
12
by: Steven T. Hatton | last post by:
I know of a least one person who believes std::ifstream::read() and std::ofstream::write() are "mistakes". They seem to do the job I want done. What's wrong with them. This is the code I...
2
by: Sandman | last post by:
Just looking for suggestion on how to do this in my Web application. The goal is to keep track of what a user has and hasn't read and present him or her with new material I am currently doing...
1
by: Poplar Reader | last post by:
Following a crash while using one of out Microsoft Access databases, the following message appears everytime we try to open it. "The Microsoft Jet Database engine could not find the object...
6
by: BBM | last post by:
I have an object that has a fairly complex construction sequence, so I have written a dedicated "factory" class that invokes the constructor of my object class (which does nothing but instantiate...
1
by: Jose Reckoner | last post by:
I'm running python 2.3 on Windows XP. Anyone have a quick small script to convert .DT1 and .DEM data to ASCII or some other format? I don't need a viewer. Thanks!
0
by: phplasma | last post by:
Hey, I am currently attempting to implement a multi-threaded C# socket, using SSL (.pem file/certification/private key combo) server using Visual Studio C# Express. I have successfully made...
1
by: Paul H | last post by:
Each time I run the user-level security wizard to create an mdw for my database I have noticed the following issue... Once I have run the wizard, I close the database and open the .mdw file I...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.