VBA in access

I have code to do various things in access, such as deleting fields, tables, etc.

The code consists of "snippets" of SQL, for example to delete fields F6 and F7:

strSQL = "ALTER TABLE [mytable] DROP COLUMN F6, F7"

CurrentDb().Execute strSQL, dbFailOnError

My question is how can this be done in access VBA, without using SQL statements and if so, would it be quicker?

Dugdugdug,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.