I have been running some VBA code in MS Access for some time (3+ years), but it is now givimg me issues. When I wrote the code, I was using Windows XP, VISIO 2007, MS Access 2007, and Adobe reader. Since then, sever migrations have happened to me. I moved to VISIO 2010 (Code still worked). I moved to Office 2010, with Access 2010 (Code still worked). I then had the full Adobe Acrobat application installed (Unsure of version number, but the code still worked). Recently, I was just migrated to Windows 7, which required re-installation of Office 2010, VISIO 2010, and Adobe Acrobat (now version XI pro). Since that time, my code is giving me problems. I have the following line of code --
Set shpObj = visapp.ActiveWindow.Page.InsertFromFile(Stacking_rpt, visInsertAsEmbed)
-- Which is intended to insert an Access report on a VISIO sheet as an imbedded PDF report. Since this latest upgrade, this line of code produces an Adobe Acrobat Icon with my file name under it instead of the report.
My boss also had her machine upgraded at the same time. She runs this same code from the same Access database as I do, but hers runs fine. The only thing that I see differently is that she only has Adobe Reader, not the full Acrobat application. That leads me to believe (possibly incorrectly) that there is a setting/option in either Adobe or Access which is causing my issue. I have looked extinsively, but have not found anything that might be related.
Does anyone have any idea?
Set shpObj = visapp.ActiveWindow.Page.InsertFromFile(Stacking_rpt, visInsertAsEmbed)
-- Which is intended to insert an Access report on a VISIO sheet as an imbedded PDF report. Since this latest upgrade, this line of code produces an Adobe Acrobat Icon with my file name under it instead of the report.
My boss also had her machine upgraded at the same time. She runs this same code from the same Access database as I do, but hers runs fine. The only thing that I see differently is that she only has Adobe Reader, not the full Acrobat application. That leads me to believe (possibly incorrectly) that there is a setting/option in either Adobe or Access which is causing my issue. I have looked extinsively, but have not found anything that might be related.
Does anyone have any idea?
