Reports not working with packaged application

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sslavens
    New Member
    • Mar 2008
    • 2

    Reports not working with packaged application

    I have packaged an Access Development Project with the Packager.
    The project has forms and reports which are based upon SQL Server.
    I have views and tables.

    All forms work fine when distributing the Runtime.
    But when an there is an attempt to run a report, an error message comes back indicating that the view that the report is based upon does not exist.

    This same view is being used by forms in the application which work perfectly fine.

    Can someone please lend a hand on this?

    Thanks
    Scott
  • PianoMan64
    Recognized Expert Contributor
    • Jan 2008
    • 374

    #2
    Originally posted by sslavens
    I have packaged an Access Development Project with the Packager.
    The project has forms and reports which are based upon SQL Server.
    I have views and tables.

    All forms work fine when distributing the Runtime.
    But when an there is an attempt to run a report, an error message comes back indicating that the view that the report is based upon does not exist.

    This same view is being used by forms in the application which work perfectly fine.

    Can someone please lend a hand on this?

    Thanks
    Scott
    In simple terms, it's a permissions issue with the report and the user running the report. Please review your account setups and make sure that the receiving machine has the as Service account that it has access to, and so on.

    Hope that helps,

    Joe P.

    Comment

    Working...