I want to convert access 97 mdb files to access 2000 files 1

[johnnycoco]

I was wondering if anybody knew how to convert an access 97 file to and access 2000 file. I have tried saving the file as a 2000 file, but it gives some compile errors. Any ideas?
Thanks

 

[nberryman]

First, compile the database in 97. This will higlight any code errors in the database. (they may be there but not used)

I don't know what you mean by Save as 2000 but if you open the database in 2000 it will prompt you to convert. If it doesnt then click Tools, database utilities, Convert

This should take care of it

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[johnnycoco]

Well, I tried to make an mde file, but it gives a "compile error in hidden module Form_frmApplications". Where is this guy hiding?
Thanks for the reply

 

[nberryman]

Open Access and click Tools, Options. On the View tab click the Hidden Objects option

Don't make an MDE file Open the VB editor and compile from the Debug, Complie (database name)

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[johnnycoco]

Forget the mde file... I tried opening the mdb file in access 2000 and converting it. Access asks to save it as a 2000 file, but it locks up my access window. Should I take this to mean that the original is faulty?
Thanks

 

[PJ]

Try copying the SQL for the Tables, Queries etc. from Access 97 to Access 2000.
Open each Object and view it in the SQL language, copy it and then create a new object in 2000, tables etc. and paste it as the SQL language, you should then be able to open your tables etc. in Access 2000
You should find that the objects in your Access 97 copy over okay and work perfectly!
Good Luck PJ

 

[nberryman]

Another way is to create a new blank database in Access 2000.

Click File, Get External Data and Import.

Select your old database and you will see a form, select all the tables and Import. Repeat for the queries and other objects you need.

When Access imports the forms it will compile them and let you know about any errors. this way you will be able to see which form is causing the problem.. Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[Kraeg]

I don't know if this is of any help, but I recently had trouble converting Access 2002 databases to 97 and 2000 (2000 converts but won't load in 2000; 97 conversion freezes part way into the conversion process).

The 2002 database links to tables in a 97 backend database; removing those links then converting it worked (then all I had to do was put the links into the 97/2000 versions).

 

[danvlas]

In Access97:
Open any module
Debug->Compile and save all modules

Search for any declarations of objects as Database, Recordset and Property and fully qualify them as DAO.Database, DAO.Recordset, DAO.Property

Then try to open the database with Access2000 and select Convert database.
It should work...

Dan

 

[johnnycoco]

Berryman had the answer fellas... I created a new blank database in 2000 and imported the external data. I am quickly finding the buggy-assed code left by the developers of the original database. I think it will work in the end though. Thanks for the help !!