But it looks like you've figured out how to create and delete tables in code. There is a section of the MS Access help called the JET SQL Reference (or similar) that gives a brief overview of the ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

In the table selector, choose the ‘Stored Procedure’ tab and select all of the stored procedures you want to access in your app. Then you can directly access the stored procedure in your app by ...