ACE model request (1 Viewer)

[JohnPapa]

I have been unable to find a diagram of the ACE structure, as exists for JET.

 

[Pat Hartman]

Can you post a link to the Jet diagram? I can't envision what you are referring to.

 

[GPGeorge]

I have been unable to find a diagram of the ACE structure, as exists for JET.

I rather doubt anything like a diagram of the entire ACE structure exists, but if it does, wouldn't that be something Microsoft might not want to share with the world?

As Pat says, though, maybe you mean something other than "the ACE structure" for the database engine in Access?

 

[The_Doc_Man]

Look for "Access Object Model" - which would tell you a lot about the LOGICAL structure of objects managed by ACE. You will not find a PHYSICAL diagram because Access is not an open-source product.

For the "as exists for JET" - the ACE model is just a newer version of JET.

 

[JohnPapa]

Can you post a link to the Jet diagram? I can't envision what you are referring to.

Please see attachment

 

[Edgar_]

May I suggest you simply go ahead and do the following?
1. Open the VBA IDE
2. Go to View > Watch Window
3. Right click > Add watch

4. Write "application" in the expression input box and keep procedure and module to "All Procedures" and "All Modules", respectively

5. Expand the resulting Application node

6. Expand DBEngine

7. Expand Workspaces. You'll find items there, expand one

8. Expand Databases. You'll find items there, expand one

Doing that gives you a better picture of everything you're dealing with, with the advantage of seeing values and types loaded. You can also fine tune your expression to reach only what you need. For example, to reach Databases, you could write this expression, instead of just "application":
Application.DBEngine.Workspaces(0).Databases(0)

 

[JohnPapa]

May I suggest you simply go ahead and do the following?
1. Open the VBA IDE
2. Go to View > Watch Window
3. Right click > Add watch
View attachment 119907
4. Write "application" in the expression input box and keep procedure and module to "All Procedures" and "All Modules", respectively
View attachment 119911
5. Expand the resulting Application node
View attachment 119912
6. Expand DBEngine
View attachment 119913
7. Expand Workspaces. You'll find items there, expand one
View attachment 119915
8. Expand Databases. You'll find items there, expand one
View attachment 119914
Doing that gives you a better picture of everything you're dealing with, with the advantage of seeing values and types loaded. You can also fine tune your expression to reach only what you need. For example, to reach Databases, you could write this expression, instead of just "application":
Application.DBEngine.Workspaces(0).Databases(0)

Very useful.

Was looking at something not that detailed as a start.

 

[jdraw]

Was looking at something not that detailed as a start.

I found this online"DAO Object Model".

 

[GPGeorge]

Please see attachment

Where did you find that "diagram"? You cut off the part of the page showing that information. It appears to be part of someone's explanation of the hierarchy of objects. I like Edgar's approach a lot, but it's not exactly what I envisioned when you asked for a diagram.