Object Browser discussion

[MichaelRed]

Does anyone know where to find a discussion; 'map'; deffinition; etc of the object browser?

I confess to realizing that it contains a huge amount of information. I further confess to a degree of confusion on finding the specific information I want at any particular time.

The current 'object of my afection' is the various properties and attributes of the basic MS Access (ver 2000 or 2003?) data structures, such as tables, fields, indicies, relationships and any others I may have completly overlooked.

In some (many / most) of my exploration it (the Object Browser) appears to have multiple references to the 'same' collections with some of them containg different information.



MichaelRed

 

[dhookom]

The object browser is like a interface to the Object Model. You might want to search the web on "Microsoft Access Object Model".

Duane
Hook'D on Access
MS Access MVP

 

[MichaelRed]

sigh ... moan ... sigh (again). I know I am just repeating myself.

MS (press) ALWAYS has an answer ... it's just that their answers are usually (always?) in their jargon.

I am of the opinion that the jargon they 'speak' is at least influenced by the lawyers propensity to minimize the clients'
exposure (to simple truth?).

Perhaps (mostly probably) it is just that I still have and use some of the earliiest MS Manuals, even though I have updated the apps. The exolinations and discussions seen more useful (complete?), not hidden behind the sparse (minimized) definitions.

I did use the reference. I did NOT find anything beyond the bare facts couched in modern techno-speak. I 'get' that. Up to the point.

Where I am deficient is in the broader capability in interperting what the difinitions mean in terms of using the ob ject(s) to obtain real and reasonable answers. How can I use this to, for example) to get and use this to get the complete and in depth information regarding a (any / all) tables in a database? Down to the various 'attributes' and properties of the fields, indexes, relationships (and their properties, attributes ... )?

I have tracked through a lot (most) of this. I do not know if I have found (much less obtained or understood) ALL of it.

I was hoping for a reference to more of a discussion and illustration of taking an object (or set of objects) and tracing through the various levels of this infloration.



MichaelRed

 

[JoeAtWork]

If you want to examine what's inside a database you would use the DAO (Data Access Objects) library.

Here's a good high-level overview:

http://allenbrowne.com/ser-04.html

And here's a bunch of code examples:

http://allenbrowne.com/func-dao.html

Hint, if your code is inside the Access database you want to examine, you can bypass the dbEngine and Workspace levels and get directly to the database object with CurrentDB (or CurrentDatabase, I don't quite remember which at the moment).

I'm also pretty sure there are existing Tek-Tips posts and/or FAQs about code to scan through a database.