Adding a column to an Access table in using Access VBA

[mp3909]

I get an error when I try to add a column to a table in Access using the VBA code below:





The error I get is "The query is a DDL query and cannot be used as a row source"

What am I doing wrong?

[mp3909]

Silly me, I removed the recordset part from my code and just used CurrentDb.execute(sql) and it worked

[ranman256]

tho you wouldn't really need to add columns to a table via code when you can just design it and add it manually.