>>
>>Good ol' SELECT-SQL. In VFP we have to use & or EVAL() to build strings dynamically for our SQL. (I forget now whether EVAL() works with SELECT-SQL). VBA uses DoCmd.RunSQL("stringexp"), so you can build the stringexp according to convenience.
>
>I should repeat that I know Access isn't compiled. I also should say that I have no VB experience. I know that VB programs use a small runtime vb300-500-600.esl or whatever. I suppose that small runtime doesn't include a data engine. I don't know which Access VBA functions are available in VB.

Also we should note that DoCmd.RunSQL is an Access thing and not a VBA thing. That is to say no Access-specific functionality is present in VB. You have to add the appropriate references in each project.