Access is not like a spreadsheet where you can insert columns (in Access they
are called 'Fields') at any time. You have to modify the table structure.

How were you attempting to insert a 'field'? What were you viewing when you
tried?

--
Build a little, test a little.


"Rob" wrote:

I have a db with 5 columns and i want my front end interface to be
able to insert a 6th column. i can do it on the front end but it doesn't
save to the db?