Adding a field to an existing table that has data

[Guest]

Is this as simple as the help feature and the Access Bible make it sound? Do
I just go to Design View and add the new field?

 

[Brandon]

Yes . . . that's the best place to add it. You can also add it directly in
the table Datasheet view, but doing it this way doesn't allow you to set the
data type.

--
Brandon

==================
Presentations Direct - Binding Machines, Laminators and Paper Shredders
http://www.presentationsdirect.com
==================

 

[Joan Wild]

Yes. If your database is split, then you need to make the change in the
backend mdb.

If you ever are uncertain about doing anything, just backup the file first.
If it doesn't turn out the way you like, you can always restore the backup.

 

[Guest]

Will this corupt any data in the table?

This table is populated from an 2nd database via a batch file that pulls the
data in. Will I need to update the batch file extract to pull in my new
field?

 

[John W. Vinson]

This table is populated from an 2nd database via a batch file that pulls the
data in. Will I need to update the batch file extract to pull in my new
field?

Probably. That depends entirely on the nature of the code run by the
batch file... which, of course, we cannot see.

John W. Vinson [MVP]