App running Access '97 vs. Access 2K

[Mark in Miami]

I have both Access 97 and 2K running on my machine. I
can 'open with...' and open my database using Access '97
no prob. That's where it was created by someone else
long ago. When I try to open the same database using
Access 2K, I get the following err:

'The Visual Basic for Applications project in this
database is corrupt.'

I looked up this error online and was referred to open a
blank new project and import the differnet objects,
tables, queries, macros, reports, forms, modules,
macros... I did all that there's some mysterious code in
the background that's keeping macros and other stuff from
firing right because I get a yes/no notification asking
that I want to stop the current code execution... bla bla
bla....

this is not being very friendly.

Can anyone assist?

Mark

 

[Chris Mills]

-A97, though it generally works well, can suffer "corruptions" which may go
unnoticed until you try and convert to a new version (or suffer other
unexplained circumstances). A97 was not actually that stable, only by
comparison to A2k do people think so...
-A2k, I clearly think, is even less stable. General advice is that A2k2 is
more stable. However, the corruption may be in A97.
-Do a full decompile/compile/compact. However, importing to a new database is
considered an even more comprehensive way of "leaving behind corruptions", and
you've already done that.
-You are then faced with debugging to find out what precisely does not work.
We are not to know what the "mysterious code" is! In this case, I'd start
cutting out big portions of the database, then putting it back halves by
smaller halves, until I discover what (halve) is causing the problem. Yes I
have had to resort to this and it took hours or days. Actually, months. There
can also be PC-specific or Windows-specific problems, which may or may not be
due to Access, so it's always worth trying another independent machine.

Chris