access 2003 and 2000

D

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
 
S

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!
 
G

Guest

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

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
 
G

Guest

Thank You Allen - I will try this and post back the result
-----Original Message-----
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
Click to expand...
office\office\msaccess.exe" /decompile
 
R

Roberta

I am having the same issues after upgrading from 2000 to 2003 with WinXP as Op system and the Reports no longer open. Doublie clicking, Prefview nor design view works with reports...nothing happens, not even an error message. Would I hIt works on my co-workers machine...could it be a path issue? I'm at a lost!!!!!
 
A

Allen Browne

Didn't follow the bit about "hlt works", but here is a suggestion to rebuild
the database quickly using A2003.

1. Using A2003, create a new (blank) database.

2. Go to Tools | Options | General, and uncheck the boxes under Name
AutoCorrect. For an explanation, see:
http://allenbrowne.com/bug-03.html

3. Import everything from the A2000 database:
File | Get External | Import
Note: if you have linked tables, link them first before importing the other
objects.

4. Press Ctrl+G to open a code window. Choose References from the Tools
menu. Deselect any references you do not need. More on references:
http://allenbrowne.com/ser-38.html

5. Still in the Immediate window, choose Compile from the Debug menu. Fix
any errors.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Roberta said:
I am having the same issues after upgrading from 2000 to 2003 with WinXP
Click to expand...
as Op system and the Reports no longer open. Doublie clicking, Prefview nor
design view works with reports...nothing happens, not even an error message.
Would I hIt works on my co-workers machine...could it be a path issue? I'm
at a lost!!!!!
 
Top