Database corrupted from 97 to Access 2000 !!!!!!

[sha7jpm]

right,

this is a good query!!

I have a 97 database which I copied and then tried to convert in access 2000.

firstly it would not convert. said it had undertaken the convert but did not write the new file to the hard drive.

secondly when I open the file as a 97 file within 2000 I lose all the forms in my database, every single one. the table remains as does the queries and reports. all seem to run fine, but all the forms are lost.

I have tried these procedures with another database and all seems fine.

so it is likely that there is something wrong with this particular database. its operates perfectly in '97.


anybody got any rafts of light or genius light bulbs popping above their heads????

ta

John

 

[The_Doc_Man]

Do the forms ALL contain class modules?

This MIGHT (stress MIGHT) be a references problem. But I've got to admit I've never seen this particular problem.

Do you have OLE objects linked (embedded) in the AC97 versions of these forms?

 

[sha7jpm]

re

not sure what you mean about class modules. but I do not have anything in the modules section.

I have a form that sends out an email through outlook,

also a few forms with clipart, and a couple with Gif animation.

but otherwise nothing ovretly different..

I agree it is a bizarre problem.

think my only solution may be to build the forms again as at least I do have the underlying table and queries

many thanks for your reply.

John

 

[The_Doc_Man]

Class modules are what you have when a form contains at least one event routine. (Reports could have them too.) If you don't have event routines then perhaps you don't have class modules.

Unfortunately, that doesn't help decipher the problem. I would say that if you could regenerate the forms, you might do best to take that approach. But I sympathize with you that it is not a pleasant idea.

 

[Pat Hartman]

Try going back to your original version and compiling all modules. There may be compile errors that are preventing a proper conversion.

 

[sha7jpm]

how to....

sorry,

can you explain how to run the compile method?

thanks

john

 

[Pat Hartman]

The easiest way is to open a module. Since you said that you don't have any, select new to create a new one. Then click on the Debug menu item and select compile "your db name" or for older versions of Access, select compile and save all modules. Fix any errors that you find and then try the conversion again.

 

[sha7jpm]

thanks,

ran that and helpfully Access said tht I dont have a Active X control registered, but did not tell me which one.

so am working my way through the list of those to see if that solves the problem.

many thanks

John

 

[sha7jpm]

compiling method

well,

tried the compiling idea,

sorted out the activeX problem, made a module complied and saved the modules, but unfortuatly no conversion.

so am back to building all my forms again, joy!

think my plan of action will be to strip down the database and hope that the bare bones will be converted, then add in the forms.

its weird that when I just open the database in 2000 it opens but as read only and that all the forms dissapeer leaving the tables, queries and reports..

many thanks for all your help

john