Restore Deleted columns with Forms in Datasheet view

[high_low_jack]

I have a form with table data in Datasheet view (looks like an Excel spreadsheet with rows and columns).

Access 2010 has a 'Delete' menu option if you right-click a datasheet column header.

How can I restore deleted columns when the database is re-opened?

 

[boblarson]

As I posted in the other thread, if you close the form without saving (not talking about records but design changes) then it will return when someone reopens it.

Also, if you compile to an ACCDE they may not be able to remove the column because you can't do design changes to forms, reports, macros, or modules in an ACCDE.