Using OMPM to assess macros? Check out this fix to repair links in the Macro Summary tab

re: Using OMPM to assess macros? Check out this fix to repair links in the Macro Summary tab

Carl Nakamura — Thu, 13 Jan 2011 06:49:42 GMT

Thanks Curtis,

I guess you would have caught that one if you were Access savvy :-)

Anyway, is there any documentation about which tables, forms and queries are used for which reports? That would make it a lot easier and quicker than having to reverse engineer the structure. I want to add the file owner to the macros report but that field is not available to add when opening the macro summary report in Layout View. The information is in there somewhere as it is available in other reports.

Thanks,

Carl

re: Using OMPM to assess macros? Check out this fix to repair links in the Macro Summary tab

Curtis Sawin (MSFT) — Wed, 12 Jan 2011 21:49:33 GMT

Carl - Good question. To edit "accdr" files, one needs to change the file extension to "accdb." Once this is done, the file can be altered. When you're finished making changes, change the extension back to "accdr."

Thanks for the comment!

Curtis

re: Using OMPM to assess macros? Check out this fix to repair links in the Macro Summary tab

Carl Nakamura — Wed, 12 Jan 2011 10:47:14 GMT

Hi,

Is there a reason you don't allow editing the Access file? I can't make any changes to it. Do you only recommend writing custom reports from scratch? It would be helpful to be able to copy a report and change filter criteria, much in the same way Curtis Swahn did. I need to tidy and re-organize the macro information for some reports. Or do you take feedback to include such reports (requested by real customers in real cases of course).

Thanks,

Carl

re: Using OMPM to assess macros? Check out this fix to repair links in the Macro Summary tab

Jill_M [MSFT] — Tue, 07 Dec 2010 17:58:36 GMT

VP, I'm not clear from your post whether you downloaded the new file and are still having problems seeing all records. Did you install the download that is included with this blog post? This new file will allow you to see more than the first 1000 records.

re: Using OMPM to assess macros? Check out this fix to repair links in the Macro Summary tab

VP — Tue, 07 Dec 2010 16:23:09 GMT

I have problem with numbers of rows. In database are 6000 PC, and ompm.accdr shows only 1000...help me please.