Error on opening Access2K in 2k2

[J9]

All of my written applications are in Access 2000. I
recently had Access 2002 installed on my computer. I can
open the 2000 DB using the shift & enter key from the
explorer window without getting the "Microsoft has
encountered an error" problem but when I try to open run
a form I get the error and have to shut down the app.

I get the error when trying to access the code, when
trying to convert the app to 2002, when trying to run the
app using double click from the explorer. I cannot get
past this error.

Please advise so that I can actually work on my 2000 apps
without having to uninstall XP and reinstall 2K.

 

[John Nurick]

Hi J9,

You don't make it clear whether you're having this problem with all your
Access 2000 databases, some of them, or just one. Normallly, Access 2002
runs Access 2000 apps just fine with no need to convert.

If it's all of them, try running Help|Detect and Repair. If that doesn't
fix it, try something like this with a copy of a database:
1 Open Access with no database.
2 Back in the Access window, use File|Open to open the database,
holding down Shift to bypass the startup code.
3 Compact and repair

If compact and repair crashes, repeat steps 1 and 2 and open the
VBE window. Can you view the modules in the database? If so, try setting
a breakpoint at the beginning of the startup code and then running it.
With luck this will let you discover the line of code that's causing the
error. If you can edit the code, make a trivial change (e.g. adding a
comment) and see if it will compile.

If it's only one or some applications that's crashing Access, start by
assuming that the problem is in that/those database/s. Try some or all
of the following:

-Create a new database in Access 2002 and import all the objects from
the suspect database.
-Working in Access 2000:
open the suspect database
compact and repair
ensure that the VBA project compiles without a hitch
try opening in Access 2002
if that fails, go back to Access 2000 and
decompile and recompile before trying Access 2002 again
if that fails, create a new database in Access 2000 and
import all the ojbects from the suspect database.