Convert Access 97 to 2000

[Jade5]

Hello:
I am trying to convert an Access 97 database to 2000. The 97 currently uses
DAO library 3.51. 2000 uses 3.6
I have both 97 and 2000 installed. I tried converting an older test 97
database and it worked. However, now that I am trying to convert the real
database, it is not working. I tried changing the DAO library and then
opening with 2000 to activate the convert dialog box but the file doesn't
open. I was going to try to use the Convert Database menu item but it is
greyed out. Why is it unavailable.
Any suggestions would be greatly appreciated.

Thanks,
Jade.

 

[strive4peace]

Hi Jade,

'~~~~~~~~~ Compile ~~~~~~~~~

Whenever you change code or references, your should always compile
before executing.

from the menu in a module window: Debug, Compile

fix any errors on the yellow highlighted lines

keep compiling until nothing happens (this is good!)

after converting, you may need to preface DAO objects when you Dim them

ie:

dim rs as DAO.recordset

you should not have any trouble with the DAO library being a different
version -- hte biggest problem seems to be not as much help, but
functionally, I have not found any differences.

~~~

if you have trouble converting, do this:

make a new, blank database in 200 format and import all of your objects

File, Get External Data, Import...


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Allen Browne]

There's a good chance the the decompile and compile will solve the problem.

For other issues, see:
Converting from Access 97
at:
http://allenbrowne.com/ser-48.html

 

[Van T. Dinh]

You don't need to use Access97 software to open the Access97 and change the
Reference to DAO 3.6. In fact, this may (???) give you problems as DAO 3.6
is designed to work with Access2000 or later (JET 4 engine), not Access97
(JET 3.5).

Usually, when you open Access2000 the use this instance to open an Access97
database, Access2000 will offer you the option of converting the database to
A2000 file format or simply opening the Access97 database (in this case, you
cannot change the *design* of the database). If you select to convert,
Access2000 will ask for a name (since it will create a new database file in
Access 2000 file format), "convert" to the new file and adjust the common
References (Access Object Library, DAO, etc ...) of the new database to the
correct version for Access 2000. You can then go into the References, check
& adjust the References if required.

 

[Jade5]

Thanks Crystal. You're awesome

Hi Jade,

'~~~~~~~~~ Compile ~~~~~~~~~

Whenever you change code or references, your should always compile
before executing.

from the menu in a module window: Debug, Compile

fix any errors on the yellow highlighted lines

keep compiling until nothing happens (this is good!)

after converting, you may need to preface DAO objects when you Dim them

ie:

dim rs as DAO.recordset

you should not have any trouble with the DAO library being a different
version -- hte biggest problem seems to be not as much help, but
functionally, I have not found any differences.

~~~

if you have trouble converting, do this:

make a new, blank database in 200 format and import all of your objects

File, Get External Data, Import...


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Jade5]

Thanks Allen! You are a lifesaver as always.

There's a good chance the the decompile and compile will solve the problem.

For other issues, see:
Converting from Access 97
at:
http://allenbrowne.com/ser-48.html

 

[Jade5]

Thanks Van. I recompiled as Crystal and Allen suggested and then tried your
instructions below and it worked. Thank you so much.
Jade.

 

[strive4peace]

you're welcome, Jade happy to help

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*