topic Access Document for Reports in ArcGIS Pro Questions

Access Document for Reports

melisahansen — Wed, 01 Feb 2023 15:35:26 GMT

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!

Re: Access Document for Reports

RhettZufelt — Wed, 01 Feb 2023 16:30:39 GMT

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).

Re: Access Document for Reports

melisahansen — Wed, 01 Feb 2023 16:37:17 GMT

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.

Re: Access Document for Reports

RhettZufelt — Wed, 01 Feb 2023 16:45:45 GMT

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.