Converting Data from Access97 to 2002

[Sawanee]

Is there a way to convert Access data from 97 to 2002? Or
is it too far a conversion? Thanks.

 

[John Nurick]

Hi Sawanee,

The data shouldn't be a problem at all. Access 2002 can open Access 97
files, and conversion is just a matter of using Tools|Database
Utilities|Convert Database.

If the database also contains forms, reports, VBA modules etc. the
conversion usually works smoothly but there can be complications.

If you need to share data between Access 2002 and Access 97, split the
database in Access 97 so that all the tables are in the back end file.
Leave this in Access 97 format. On the Access 97 computers, leave the
front end in Access 97 format; but convert it to Access 2000 or Access
2002 format for use with Access 2002. (Access 2002 actually uses the
Access 2000 file format by default.)

 

[Gil]

Will this also show the GUI on the access db, I converted
the db and does not show the GUI option.

-----Original Message-----
Hi Sawanee,

The data shouldn't be a problem at all. Access 2002 can open Access 97
files, and conversion is just a matter of using Tools|Database
Utilities|Convert Database.

If the database also contains forms, reports, VBA modules etc. the
conversion usually works smoothly but there can be complications.

If you need to share data between Access 2002 and Access 97, split the
database in Access 97 so that all the tables are in the back end file.
Leave this in Access 97 format. On the Access 97 computers, leave the
front end in Access 97 format; but convert it to Access 2000 or Access
2002 format for use with Access 2002. (Access 2002 actually uses the
Access 2000 file format by default.)

Is there a way to convert Access data from 97 to 2002? Or
is it too far a conversion? Thanks.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[John Nurick]

I'm sorry, Gil: can you explain what you mean by "show the GUI option"?

Will this also show the GUI on the access db, I converted
the db and does not show the GUI option.

-----Original Message-----
Hi Sawanee,

The data shouldn't be a problem at all. Access 2002 can open Access 97
files, and conversion is just a matter of using Tools|Database
Utilities|Convert Database.

If the database also contains forms, reports, VBA modules etc. the
conversion usually works smoothly but there can be complications.

If you need to share data between Access 2002 and Access 97, split the
database in Access 97 so that all the tables are in the back end file.
Leave this in Access 97 format. On the Access 97 computers, leave the
front end in Access 97 format; but convert it to Access 2000 or Access
2002 format for use with Access 2002. (Access 2002 actually uses the
Access 2000 file format by default.)

Is there a way to convert Access data from 97 to 2002? Or
is it too far a conversion? Thanks.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.