How to add field in existing access database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to add a new field in an existing access database?

The help file says to
goto datasheet view
click in col to the right of col where desired new column is to be
on Insert click column
...

But with an existing database, column is ont an option on the insert menu!
Similar problem using design view mode.

Jerry
 
Just go to your list of tables, highlight the one you want, and open it in
DESIGN VIEW. Then add whatever you want.
 
With your table in design mode you most definitely can add a field -
but it won't look like a column in design mode.

HTH
 
Back
Top