A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

where is database metadata?



 
 
Thread Tools Display Modes
  #1  
Old February 24th, 2009, 03:59 PM posted to microsoft.public.access.tablesdbdesign
Oldtimer
external usenet poster
 
Posts: 17
Default where is database metadata?

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?


  #2  
Old February 24th, 2009, 11:49 PM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default where is database metadata?

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
--
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.

"oldtimer" wrote in message
...
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?


  #3  
Old February 25th, 2009, 01:28 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default where is database metadata?

On Tue, 24 Feb 2009 06:59:02 -0800, oldtimer
wrote:

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!

--

John W. Vinson [MVP]
  #4  
Old February 26th, 2009, 05:13 AM posted to microsoft.public.access.tablesdbdesign
David W. Fenton
external usenet poster
 
Posts: 3,373
Default where is database metadata?

John W. Vinson wrote in
:

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?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
  #5  
Old February 26th, 2009, 06:30 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default where is database metadata?

On 26 Feb 2009 04:13:19 GMT, "David W. Fenton"
wrote:

John W. Vinson wrote in
:

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?


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

John W. Vinson [MVP]
  #6  
Old February 27th, 2009, 07:33 AM posted to microsoft.public.access.tablesdbdesign
David W. Fenton
external usenet poster
 
Posts: 3,373
Default where is database metadata?

John W. Vinson wrote in
:

On 26 Feb 2009 04:13:19 GMT, "David W. Fenton"
wrote:

John W. Vinson wrote in
m:

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?


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

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




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.