How to add an additional field in the existing database table

How to add an additional field in the existing database table and adding an
additional table in the existing database without affecting the past data in
that database?

Neither adding a field to the existing table nor adding a table should
affect existing data. If you are adding a required field (that is, data
entry required) I expect you will need to populate that field in all
records, perhaps by way of an update query, but the details depend on what
exactly you are trying to do.

"lvensen" wrote in message
...
How to add an additional field in the existing database table and adding
an
additional table in the existing database without affecting the past data
in
that database?

On Fri, 10 Jul 2009 03:58:00 -0700, lvensen wrote:

How to add an additional field in the existing database table and adding
an additional table in the existing database without affecting the past
data in that database?


Open existing table in design view, add the new field and press save.

In the Tables pane of the db window press "Create new Table" or find that
option in the menu/ribbon.

Neither of these actions has the slightest effect on existing data.



--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Suppose we created an application for a client. That client using that
application and putting datas into the database. After some days or months,
we need to add an field or table in the existing database. At that situation
how to add table or fields without affecting the datas. Is it possible?

On Fri, 10 Jul 2009 04:24:01 -0700, lvensen wrote:

Suppose we created an application for a client. That client using that
application and putting datas into the database. After some days or
months, we need to add an field or table in the existing database. At
that situation how to add table or fields without affecting the datas.
Is it possible?

In a split app you would give them a new front end that would run code
upon first use to modify the existing table and to create the new table.

If your app is not split then you did it wrong. Now would be the time to
fix it.



--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

=?Utf-8?B?bHZlbnNlbg==?= wrote
in :

Suppose we created an application for a client. That client using
that application and putting datas into the database. After some
days or months, we need to add an field or table in the existing
database. At that situation how to add table or fields without
affecting the datas. Is it possible?

Naturally.

But it does show that you didn't design the app very well. This is
the kind of thing that should have VERY RARELY in any production
app. The fact that you need to do it should indicate either that you
didn't design it well, or the client was derelict in describing the
requirements.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/