Announcement

Collapse
No announcement yet.

Database Enhancement

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Enhancement

    Is there something that I need to configure to get reporting from Tools>Generate Report to export to MS Access? Everytime I try I am prompted with a box notifying me that the database was created with a previous version and Access will upgrade the DB. What do I need to do to make this work correctly? I am on version 7.7c with MS Office 2007.

  • #2
    Re: Database Enhancement

    You just need to let Access convert the database to your version of Access. It will create a new copy of the database, that you will then need to rename to hyenarpt.mdb and put that in your Hyena directory.

    Comment


    • #3
      Re: Database Enhancement

      It creates a file named hyenarpt1.accdb. If I change the file extension to mdb then the action failes.

      Comment


      • #4
        Re: Database Enhancement

        By default Hyena looks for hyenarpt.mdb, so make sure that is what you name the converted copy.

        Comment


        • #5
          Re: Database Enhancement

          Ok, I started the process over. When I choose to convert the DB I get a message stating MS Office encountered one or more errors during conversion.
          I renamed the new file to what the old file was and it tells me that the action failed.

          Comment


          • #6
            Re: Database Enhancement

            What is the exact error?

            Comment


            • #7
              Re: Database Enhancement

              I run Generate Report and Access 2007 opens with a box that states:
              Action Failed
              Macro Name: RunReport
              Condition: True
              Action Name: RunCode
              Arguments:RunReport()
              Error Number: 2950

              Comment


              • #8
                Re: Database Enhancement

                Try the information here for the 2950 error:

                http://www.systemtools.com/toolboard...sta-Office-2k7

                Comment

                Working...
                X