OpenReport cancelled error after MS Access upgrade

Posted on 2007-07-26
1 Ratings
Last Modified: 2008-01-09
I have one computer that will not allow me to run reports or modify reports on it.  I continue to get an 'OpenReport action cancelled' error.

I have a network of 5-6 computers using an Access 2000 database.  These computers are connected to a MS SBS 2003 server.  All computers had Access 2003 on them except for one computer.

The computer in question has XP Pro w/SP2, Access 2000, and MS Office 2003 Basic installed on it.  I requested that it be upgraded to Office 2003 Professional so that all computers would have Access 2003 on it and the database could be converted to 2003.  Instead the support tech removed Access 2000 and added MS Office 2003 Professional (Access 2003 & Publisher 2003 only).

I am at a loss why this is happening.  Please help!!
Question by:TSFLLC
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    PLease try this:

    A **DeCompile** may help here ...

    But first, if you have not already:
    Check for any **Missing References via the VBA Editor>>Tools>>References ....

    Then, follow this procedure:

    0) **Backup your MDB**
    1) Compact and Repair the MDB, as follows:
    Hold down the Shift key and open the MDB, then from the menu >>Tools>>Database Utilities>>Compact and Repair ...
    2) Execute the Decompile (See example syntax below) >> after which, your database will reopen.
    3) Close the mdb
    4) Open the mdb and do a Compact and Repair (#1 above).
    5) Open the mdb:
        a) Right click over a 'blank' area of the database window (container) and select Visual Basic Editor. A new window will open with the title 'Microsoft Visual Basic' ... followed by then name of your MDB.
        b) From the VBA Editor Menu at the top of the window:
            Note ... after the word Compile will see the name of your 'Project' - just an fyi.

    6) Close the mdb
    7) Compact and Repair one more time.

    *** Executing the DeCompile:
    Here is an example of the command line syntax  (adjust your path and file name accordingly) for executing the


    Run this from Start>>Run, enter the following command line ...

    "C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile


    For more detail on the Decompile subject ... visit the Master on the subject (and other great stuff) Michael Kaplan:

    LVL 65

    Expert Comment

    You did an upgrade

    ok, does any of your code use early binding of office objects? eg. dim x as outlook.application or excel.application
    if so, then compile your code, fix errors, fix references, compile again and try again

    have you changed any printers? do u have default printers defined? does the printer defined for the report still exist (file/page setup or something like that)
    ensure a valid printer is selected

    Author Comment


    I have 3-4 other computers tied to this network who are using the application without any problem.  Just this one computer.  The only difference between the one not working properly is that it started with Access 2000, Office Basic 2003, and then installed Office 2003 Professional.

    Since your posting, I had them remove all of the above and perform a full installation with Office 2003 Professional.  Still receivnig problem.
    LVL 65

    Accepted Solution

    is the setup the same as the other pc's? i.e. printer setup, the default printer on the other pc is same as this one

    having same version of office clears the problem of binding


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now