Converting Access 97 Database to Access 2000

[Guest]

I converted our Access 97 database to Access 2000 and made some changes to
the Design of the 2000 version (i.e. Added some extra fields, forms &
reports). Now that the changes in the 2000 version are done, Can I copy the
data records from the 1997 database or will this cause problems in the Access
2000 version.

Thanks for the help.

Ken K. - 2191

 

[Guest]

You can safely copy the data records of any table that has not changed.
If you have changed the table layout you may or may not be able to reload
the old data, it depends on what you changed.
-Dorian

 

[John Vinson]

I converted our Access 97 database to Access 2000 and made some changes to
the Design of the 2000 version (i.e. Added some extra fields, forms &
reports). Now that the changes in the 2000 version are done, Can I copy the
data records from the 1997 database or will this cause problems in the Access
2000 version.

Thanks for the help.

Ken K. - 2191

Should be no problem. Use File... Get External Data... Link to link to
the tables in the A97 database, and run Append queries to migrate the
data.

John W. Vinson[MVP]

 

[Guest]

Thanks!!
--
akkrug

Should be no problem. Use File... Get External Data... Link to link to
the tables in the A97 database, and run Append queries to migrate the
data.

John W. Vinson[MVP]