Data Dictionary

[mis]

Hi,

How would you go about creating a data dictionary ?? I have been told that access creates one but it is hiden is there any way of making it viewable.??

 

[___]

Tables:

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "MSys*") AND ((MSysObjects.Type)=1
Or (MSysObjects.Type)=6))
ORDER BY MSysObjects.Name;

Queries:

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "~sq*") AND ((MSysObjects.Type)=5))
ORDER BY MSysObjects.Name;

Forms:

SELECT MSysObjects.Name FROM MSysObjects WHERE
(((MSysObjects.Type)=-32768)) ORDER BY MSysObjects.Name;

Reports:

SELECT MSysObjects.Name FROM MSysObjects WHERE
(((MSysObjects.Type)=-32764)) ORDER BY MSysObjects.Name;

Macros:

SELECT MSysObjects.Name FROM MSysObjects WHERE
(((MSysObjects.Type)=-32766)) ORDER BY MSysObjects.Name;

Modules:

SELECT MSysObjects.Name FROM MSysObjects WHERE
(((MSysObjects.Type)=-32761)) ORDER BY MSysObjects.Name;


HTH

 

[___]

Or...

SELECT * FROM MSysObjects
ORDER BY MSysObjects.Name;

if you want to view everything.

HTH

 

[mis]

thanks

U know the

SELECT * FROM MSysObjects
ORDER BY MSysObjects.Name;

mysysobjects.name does this have to be a name of the database, table or just name ??

 

[Mile-O]

U know the

SELECT * FROM MSysObjects
ORDER BY MSysObjects.Name;

mysysobjects.name does this have to be a name of the database, table or just name ??

It stays as given. MSysObjects is a hidden table that stores information about the objects you create.