SQL table & MAOL table

[fatalshears]

Hi guys!
I 've just begin to learn access, I would like to know what is the difference between creating a table using SQL and creating a table using MAOL (access object library)? I ran into these 2 methods when taking a tutorial on the internet? What are the advantages of each method?
Thanks in advance

 

[CJ_London]

If by MAOL you mean using docmd.createobect etc then the benefit is you can set the additional features available in an Access table which are not accessable using SQL.

However many of these features (such as lookups, calculated fields etc) are not used by seasoned developers because they are not consistent with good or efficient design and are not upsizeable to other db's such as SQL server.

In my own opinion, in terms of creating/amending a table/indexes by using docmd v SQL there is no benefit either way in terms of speed of execution, readability of code etc.