Discussion Locked

Auto convert of Access 97toAccess'00 DB

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

A client has advised that they are switching over to Office 2000, and wanted to be assured that converting their Access 97 Database to Access 2000 will not create any problems. I cannot assure them that it will be okay because I have not yet worked with Access 2000.

Has anybody done this type of conversion, and what problems if any can I expect.

7 replies

by vinnyd

I have converted a number of Access 97 databases to Access 2000 with no problems at all.

But with all software conversions do a backup of the database before trying to convert it.

You know the rule! If you do not have a backup, everything goes wrong! If you have a backup, it always works the first time!

by donq

Luckily both Access 97 and Access 2000 use the same daatabase engine(s) (and VB 7) so there are few if any problems. The little desktop icons change in appearance slightly but that is about the only noticible difference.

by glen_mcleod

An often overlooked item in a conversion like this is security.

If you've secured any of the databases by using new workgroup files, the easiest thing to do is give the admin user all rights before the conversion. That way you won't need the workgroup files FOR the conversion, and can create new ones with the Access 2K tools.

Glen

This discussion is closed to new replies.