Convertion to XP Issue (Corrupt VBA?)

[DeutchBose]

I have an Excel 97 Database that I'm trying to convert to XP. The database has only one form with some very simple vba behind it as well as a handful of macros. I've compiled the code in '97 and everything works just fine...All the the linked tables have been refreshed and are accurate.

I have all the correct odbc and drive settings on my xp box...but when I convert to XP, I get a "The Visual Basic for Applications project in this database is corrupt"...and I am unable to convert.

I tried changing the Reference Library from DAO 2.5/3.5 to DAO 3.6, but that didn't make a difference. I deleted the form entirely (along with its' vba code), but that didn't make a difference either.

Any ideas?

 

[Joe4]

What happens if you open a new, blank database in Access XP, then import all your objects from the old database? This may be a way of getting around the conversion errors.

 

[Sully38]

Using Tools\References. Make sure the following is referenced:

DAO 2.5/3.5 compatibility Library

 

[bat17]

It could be worth trying to Decompile the DB first. Work on a copy though! Check out this article for details

HTH

Peter