Access 97 -> 2000 Conversion

[eao]

I am trying to convert an Access 97 db to Access 2000 through the application, and when I select Tools > Database Utilities, the Convert Database option is greyed out.

1. Any idea why?
2. What options do I have for a work around?

Thanks.

 

[Hap007]

Dear Eao,

Couple of items:

A) You can only convert an mdb, not an mde.
B) You must use Access 2000 to convert Access97.mdb to an Access2000.mdb file.
C) If the Access97.mdb was secured with an an access mdw security file, then you will need to first create a new Access97.mdb file without security and then import all objects and tables from your original secured mdb file.(There must be a way around this, but I find that this is easy).

I am assuming that all of these items are correct.
Then, perhaps someone else has the db open or you did not install all the Access options.

Here is how I would do the conversion:
First, you need to have a good copy of your 'Access97' mdb.

1) Backup your Good Access97 mdb first!!
2) Run Access97, open your access97.mdb, select compact and repair.
3) While running Access97, open a code window, select compile and save all. This needs to work, or the mdb is not good.
4) While still running Access97, open a code window, select Tools>References and make a note of all references. You will need these references or their later version set in your new 2000 mdb.
5) Run Access2000, open your access97.mdb, select Tools>Database Utilities>Convert to current version.
6) The Convert will create a new '2000'.mdb based on the name and directory you told Access to create, so close the 'Access97.mdb' and open this new 'Access2000.mdb' file.
Note, you must close the 97.mdb and open the 2000.mdb at this point!
7) Finally, this is the most important step! In the new 'Access2000.mdb', open up a code window and Select Debug>Compile.

Note: The compile must work completely, if it does not, then check the 'References', that we wrote down in Step 4, to make sure the same (or later version) are selected.

Hope This Helps,
Hap

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/groups/accessDevelopers

 

[rosiebob]

Go into ACCESS via Start/Programs etc. It will let you browse access progs. 1st, use the tools button on the bar and it will let you select convert & then select the mdb.

I wrote this from memory, but if you still have a problem send me an email, & i'll reply in better detail.

Good Luck Bob RBPMAIL@aol.com

 

[eao]

Thanks to all. I figured out a few days ago that I needed to open Access, select Convert Database, and then point to the database I wanted to convert. The mistake I was making was opening my source database first, and then trying to convert it.