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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|