where is database metadata?

[oldtimer]

I have to copy Access97 databases to Oracle.
To do so I need access to the Access97 metadata.
I have found the table names in MSysObjects but cannot find the column
descriptors.
Can you help?

 

[Allen Browne]

Best way to get all details on the fields in Access (JET) tables is through
DAO code.

The TableInfo() function shows how to enumerate the fields and their
properties:
http://allenbrowne.com/func-06.html

Here's basic info on the DAO object model:
http://allenbrowne.com/ser-04.html

Here's a list of the DAO names/constants and those of other libraries:
http://allenbrowne.com/ser-49.html

And some more examples of working with DAO:
http://allenbrowne.com/func-DAO.html

 

[John W. Vinson]

I have to copy Access97 databases to Oracle.
To do so I need access to the Access97 metadata.
I have found the table names in MSysObjects but cannot find the column
descriptors.
Can you help?

MSysObjects is not documented, and has changed in structure from version to
version.

There are no simple equivalents to SQL or Oracle's metadata tables,
unfortunately!

 

[David W. Fenton]

MSysObjects is not documented, and has changed in structure from
version to version.

Michael Kaplan claimed that once something was implemented in the
system tables, it was never changed. So, things may have been added,
but nothing that has ever existed is supposed to have been changed.
Do you have an example that would contradict what MichKa used to say
about that subject?

 

[John W. Vinson]

Michael Kaplan claimed that once something was implemented in the
system tables, it was never changed. So, things may have been added,
but nothing that has ever existed is supposed to have been changed.
Do you have an example that would contradict what MichKa used to say
about that subject?

Nope. I'd trust Michael on this one! I've never delved into the mysteries of
the MSys tables, and he has (deeply).

 

[David W. Fenton]

Nope. I'd trust Michael on this one! I've never delved into the
mysteries of the MSys tables, and he has (deeply).

He was reporting what Microsoft told him. Here's where he conveyed
this information:

http://trigeminal.com/usenet/usenet017.asp?1033