nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Encuentra más publicaciones etiquetadas con

Accepted answers

rzufelt

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.

All comments

rzufelt

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.

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.

rzufelt

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

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.