Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Windows User Privleges and Reports

Discussion in 'Information Technology' started by rogge, Jul 28, 2006.

  1. rogge

    rogge
    Expand Collapse
    Guest

    Here is one line of my code:
    DoCmd.OpenReport "rptIssClosedListDate", acViewPreview

    and it generates this error w/o error handling:
    "Execution of this application has stopped due to a run-time error."
    When one clicks "OK" the application closes

    With erorr handling:
    "Error 1502 (The OpenReport action was canceled) in procedure...."

    The report has no code.

    I have full admin rights on my computer and do not get this erorr; however,
    my co-workers' computers are locked down tighter than Sir Galahad at Castle
    Anthrax. SO i am assuming that these admin rights are the issue. will you
    please shed some light on permissions and report running?
     
  2. Loading...

    Similar Threads Forum Date
    E-mail scam directs users to bogus Windows update (SiliconValley.com) Interfaith Dialogues Apr 10, 2005
    Windows 10-don't Click That Tab! Information Technology Aug 10, 2015
    All Windows Open: Family Fortunes Rise and Fall in the Tropics Book Reviews & Editorials Mar 30, 2013
    Microsoft Unveils New Windows Mobile (AP) Interfaith Dialogues May 11, 2005
    Review: Mac Os X Steps Ahead of Windows (AP) Interfaith Dialogues May 1, 2005

  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    By "the application closes" do you mean that Access closes? If so there is a
    very bad problem with the installation of Microsoft Office. Make sure all
    patches have been applied. Also try running the database on another person's
    computer with similar restrictions as the problem machine.

    Also make sure that the computer has a valid default printer set up. Often
    the lack of a default printer causes problems with reports.
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "rogge" wrote:

    > Here is one line of my code:
    > DoCmd.OpenReport "rptIssClosedListDate", acViewPreview
    >
    > and it generates this error w/o error handling:
    > "Execution of this application has stopped due to a run-time error."
    > When one clicks "OK" the application closes
    >
    > With erorr handling:
    > "Error 1502 (The OpenReport action was canceled) in procedure...."
    >
    > The report has no code.
    >
    > I have full admin rights on my computer and do not get this erorr; however,
    > my co-workers' computers are locked down tighter than Sir Galahad at Castle
    > Anthrax. SO i am assuming that these admin rights are the issue. will you
    > please shed some light on permissions and report running?
    >
     
  4. rogge

    rogge
    Expand Collapse
    Guest

    Yes, MS Access closes immediately after clicking "OK".

    ALL patches have been applied
    ALL of the computer with restriced permissions have the issue
    ALL Computers have a valid, and operational, default printer

    what would cause the OpenReport action to be Canceled

    thanks.

    "Jerry Whittle" wrote:

    > By "the application closes" do you mean that Access closes? If so there is a
    > very bad problem with the installation of Microsoft Office. Make sure all
    > patches have been applied. Also try running the database on another person's
    > computer with similar restrictions as the problem machine.
    >
    > Also make sure that the computer has a valid default printer set up. Often
    > the lack of a default printer causes problems with reports.
    > --
    > Jerry Whittle
    > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
    >
    >
    > "rogge" wrote:
    >
    > > Here is one line of my code:
    > > DoCmd.OpenReport "rptIssClosedListDate", acViewPreview
    > >
    > > and it generates this error w/o error handling:
    > > "Execution of this application has stopped due to a run-time error."
    > > When one clicks "OK" the application closes
    > >
    > > With erorr handling:
    > > "Error 1502 (The OpenReport action was canceled) in procedure...."
    > >
    > > The report has no code.
    > >
    > > I have full admin rights on my computer and do not get this erorr; however,
    > > my co-workers' computers are locked down tighter than Sir Galahad at Castle
    > > Anthrax. SO i am assuming that these admin rights are the issue. will you
    > > please shed some light on permissions and report running?
    > >
     
  5. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    If it only happens on one computer, chances are that it's that computer.
    Anything else strange happening on that computer? Could be hardware like a
    bad memory card or software problem. Unfortunately if it's software, I usally
    have the best luck by wiping the hard drive and doing a fresh install of
    everything.

    If it happens on many computers, that particular report, or a
    form/report/query related to that report, is corrupt. For exampe the
    clicking of the button that runs the report might be the problem or the query
    that drives the report might be hitting some corrupt data in a memo field.

    Tony Toews has an excellent web page on database corruption.
    http://www.granite.ab.ca/access/corruptmdbs.htm

    Allen Brown also has excellent info on corruption.
    http://allenbrowne.com/ser-47.html

    I have a white paper in a Word document named Fix Corrupt Access Database
    towards the bottom this page:
    http://www.rogersaccesslibrary.com/OtherLibraries.asp
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "rogge" wrote:

    > Yes, MS Access closes immediately after clicking "OK".
    >
    > ALL patches have been applied
    > ALL of the computer with restriced permissions have the issue
    > ALL Computers have a valid, and operational, default printer
    >
    > what would cause the OpenReport action to be Canceled
    >
    > thanks.
    >
    > "Jerry Whittle" wrote:
    >
    > > By "the application closes" do you mean that Access closes? If so there is a
    > > very bad problem with the installation of Microsoft Office. Make sure all
    > > patches have been applied. Also try running the database on another person's
    > > computer with similar restrictions as the problem machine.
    > >
    > > Also make sure that the computer has a valid default printer set up. Often
    > > the lack of a default printer causes problems with reports.
    > > --
    > > Jerry Whittle
    > > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
    > >
    > >
    > > "rogge" wrote:
    > >
    > > > Here is one line of my code:
    > > > DoCmd.OpenReport "rptIssClosedListDate", acViewPreview
    > > >
    > > > and it generates this error w/o error handling:
    > > > "Execution of this application has stopped due to a run-time error."
    > > > When one clicks "OK" the application closes
    > > >
    > > > With erorr handling:
    > > > "Error 1502 (The OpenReport action was canceled) in procedure...."
    > > >
    > > > The report has no code.
    > > >
    > > > I have full admin rights on my computer and do not get this erorr; however,
    > > > my co-workers' computers are locked down tighter than Sir Galahad at Castle
    > > > Anthrax. SO i am assuming that these admin rights are the issue. will you
    > > > please shed some light on permissions and report running?
    > > >
     

Share This Page