Access 1.1 Data Base Migration to Access 2002

[R. Allen -California]

I have an older IBM Activa running Access 1.1 under Win
95, with a single 10 columns x 950 records table. I also
have a new Dell running XP and XP Professional. There is
no physical connection between the two PCs.

I am told by Microsoft Support that only Access 97
(release 8.0), and later, are suported by Access 2002. I
really do not want to retype all that data for this wine
cellar inventory! If I could get a copy of the Access 97
upgrade CD, I could upgrade the old 1.1 to 8.0, and then
migrate the file to Access 2002 on the Dell. I would
then kill the old Access, return the CD, and donate my
old Aptiva.

Assuming the above would work. how would I go about
getting an Access 97 upgrade CD? Also, does anyone know
of any utility programs I could use to perform this
simple migration? Thanks.

 

[Matthias Klaey]

I have an older IBM Activa running Access 1.1 under Win
95, with a single 10 columns x 950 records table. I also
have a new Dell running XP and XP Professional. There is
no physical connection between the two PCs.

I am told by Microsoft Support that only Access 97
(release 8.0), and later, are suported by Access 2002. I
really do not want to retype all that data for this wine
cellar inventory! If I could get a copy of the Access 97
upgrade CD, I could upgrade the old 1.1 to 8.0, and then
migrate the file to Access 2002 on the Dell. I would
then kill the old Access, return the CD, and donate my
old Aptiva.

Assuming the above would work. how would I go about
getting an Access 97 upgrade CD? Also, does anyone know
of any utility programs I could use to perform this
simple migration? Thanks.

There is no need for all of this. Copy your 1.1 MDB to the XP Machine.
Create a new MDB in Access XP. In the menu "File / Get External Data"
Select "Import", select the 1.1 MDB and import all objects. If this
should not succeed at once, import one object after the other. With
the tables you should have no problem at all, but most probably you
will have to modify the code, if there is any.
Note that this is an "unsupported" way to upgrade your 1.1 database to
Access XP.

HTH
Matthias Kläy