Access Document for Reports

[melisahansen]

Hello,

Previously, in ArcMap I used a mdb which allowed me to export reports to a word document and email them. Since Pro does not support this, does anyone know of a solution? 

Basically, the process previously was, run a script that processed the data, then when you open the mdb it allowed you to select export the report, or email the report. 

Any suggestions are greatly appreciated!

[RhettZufelt]

I have something similar, but I now create the data tables in SQL Server instead of the .mdb.

Then, I connect the mdb to the SQL Server tables instead of internal stored tables and run the report(s).

R_

[melisahansen]

Did you first need to convert your mdb to a file gdb? In Pro the script that create the data for reports needed to be changed to run from a gdb in order for the scripts to even run. 

[RhettZufelt · Accepted solution]

I exported my tables from Access to SQL Server geodatabase.  Then, "linked" Access to the "new" tables in SQL Server.

Pro see's all the "new" tables in the SQL Server geodatabase and can process them directly.

Then, Access just links to these SQL Server tables instead of the "old" tables that were in the mdb for use in the report(s).

Don't think FGDB is an option as Access doesn't have a link to datasource option for FGDB's.

R_