Posted by Ed Murphy on 04/22/07 05:55

Erland Sommarskog wrote:

> Isn't Access an SQL database?

http://en.wikipedia.org/wiki/Microsoft_Access#Features

One of the benefits of Access from a programmer's perspective is its
relative compatibility with SQL (structured query language) —queries may
be viewed and edited as SQL statements, and SQL statements can be used
directly in Macros and VBA Modules to manipulate Access tables. In this
case, "relatively compatible" means that SQL for Access contains many
quirks, and as a result, it has been dubbed "Bill's SQL" by industry
insiders. Users may mix and use both VBA and "Macros" for programming
forms and logic and offers object-oriented possibilities.

[Back to original message]