Greetings!

How do I use VBA to delete an entire field from a table? I initially need
this field, but later I would like to get rid of the field entirely. I do
not want users going into the table design to delete this field, and would
rather use VBA to delete the field. Any suggestions?

Jessica

This should do it:
strSql = "ALTER TABLE [MyTable] DROP COLUMN [DeleteMe];"
DBEngine(0)(0).Execute strSql, dbFailOnError

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jessica" <(E-Mail Removed)> wrote in message
news:E8A5F8C5-7987-4FD8-9E6F-(E-Mail Removed)...
> Greetings!
>
> How do I use VBA to delete an entire field from a table? I initially need
> this field, but later I would like to get rid of the field entirely. I do
> not want users going into the table design to delete this field, and would
> rather use VBA to delete the field. Any suggestions?
>
> Jessica

That worked. Thank you!

"Allen Browne" wrote:

> This should do it:
> strSql = "ALTER TABLE [MyTable] DROP COLUMN [DeleteMe];"
> DBEngine(0)(0).Execute strSql, dbFailOnError
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Jessica" <(E-Mail Removed)> wrote in message
> news:E8A5F8C5-7987-4FD8-9E6F-(E-Mail Removed)...
> > Greetings!
> >
> > How do I use VBA to delete an entire field from a table? I initially need
> > this field, but later I would like to get rid of the field entirely. I do
> > not want users going into the table design to delete this field, and would
> > rather use VBA to delete the field. Any suggestions?
> >
> > Jessica
>
>
>