Tweet
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.
-
-
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. -
Re: Database Enhancement
It creates a file named hyenarpt1.accdb. If I change the file extension to mdb then the action failes.Comment
-
Re: Database Enhancement
By default Hyena looks for hyenarpt.mdb, so make sure that is what you name the converted copy.Comment
-
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
-
Re: Database Enhancement
What is the exact error?Comment
-
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: 2950Comment
-
Re: Database Enhancement
Try the information here for the 2950 error:
Comment
Comment