Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Seek help to understand the Jet Database Engine

Author  Topic 

phuang1226
Starting Member

5 Posts

Posted - 2007-10-04 : 20:02:00
Hi,

I am reading the book by Steven Roman:

"Access Database : Design and Programming" 3rd edition.

On page 120, Figure 7-2, he showed the the structure of the Jet Database Engine, which is very confusing to me.

According to this picture, I come to such an understanding:

1) VBA is just the hosting language for the Jet Database Engine;

2) Microsoft Visual Basic, Excel, Access, Word are hosting languages for VBA.

Isn't this weird? VB hosts VBA?

Thanks for any input!

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2007-10-05 : 07:09:17
VBA is Visual Basic for Applications. I pulled this off the web:

Definition of: VBA

(Visual Basic for Applications) A subset of Visual Basic that provides a common language for customizing Microsoft applications. VBA supports COM, which allows a VBA script to invoke internal functions within Excel, Word and other COM-based programs or to make use of stand-alone, external COM objects. VBA evolved into a common language to consolidate earlier macro and scripting languages. Since 1996, VBA has been licensed to third parties for use in non-Microsoft applications within the Windows environment. Microsoft encourages Windows developers to put VBA support in their software.

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page
   

- Advertisement -