Upgrading to a new database

[Guest]

Hi,

We've got a database which is very limited and we need to transfer the
information from it to a new database. We have similar fields however the
new database has much more validation in the form of input masks along with
required fields.

Many of the required fields do not exist in the old database and the new
database is a copy of one thats being used in another part of our
organisation. I'm not sure how to proceed or even if it will be possible at
all.

Can somebody please help?

Many thanks

Ian

 

[Arvin Meyer [MVP]]

Before you can import the data from old to new, you'll need to add the
required fields to the old tables, and update the values to the defaults in
the new tables. Generally, it is necessary to provide default values for any
required fields.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[John W. Vinson/MVP]

Hi,
Many of the required fields do not exist in the old database and the new
database is a copy of one thats being used in another part of our
organisation. I'm not sure how to proceed or even if it will be possible
at
all.

Once you've followed Arvin's advice and determined where the data for the
new required fields will be coming from, you can use File... Get External
Data... Link in the new database to link to the tables in the old, and run
Append queries to migrate the data. It's quite possible you'll be able to
provide the defaults as calculated fields in the Append query without
needing to actually put them into the table.

John W. Vinson/MVP