access 2003 and 2000

[desperate]

I built an aplication in access 2000.
When i upgraded to Access 2003 I opened the aplication in
Access 2003. Everything works but the reports. WHen I
try to open any of the reports from a form by clicking on
a button that is supose to open it I get the following
message:
"the OpenReport action was canceled"
If I try to open the report in design or preview mode
from the database screen - it won't open

Everything works when I use Access 2000.

I looked on Microsoft database and couldn't find anything
on this subject.

How can I solve this ?

Thanks for helping

 

[Scott H.]

Can you convert the database to 2003?

I have some databases in use at work on a worldwide
basis, built in 2000/2002, and when users open them using
2003, the databases become corrupt with no hope of
repair. Beware!

 

[Guest]

YES - I CAN CONVERT - SAME THING HAPPENS WITH BOTH
DATABSES - THE CONVERTED AND THE ORIGINAL WHEN I OPEN
THEM WITH ACCESS 2003

 

[Allen Browne]

If the damaged database still works in Access 2000, you can probably use
A2000 to repair it.

1. Open it in A200, and compact:
Tools | Database Utilities | Compact.

2. Close Access. Open a command prompt, and enter something like the
following. It is one line, and include the quotes. Make sure the path is to
the A2000 version of msaccess.exe if you have multiple versions on the
computer:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

3. Open the file in Access, and compact again.

4. Now try converting to A2003 again.

If that still fails, create a new (blank) A2003 database, and import
everything:
File | Get External | Import