Access Reports - Rename Tables Macro

Document ID

Document ID HT4752

Product

  • Juris®


Category

  • Product Features

Was this helpful?

Submitting...
Thank You!
There was an error with your submission. Please try again.
Article Content
Special Notice!
Juris® Suppplemental and Gold Reports are now available for download and import into Juris® Suite. For additional details, see Supplemental and Gold Reports for Juris Suite.


Whenever you have to manually re-link the tables, always run the Rename_Tables macro, and hidden macros for macroH and macroI. They are located under "Macros" in Object Types.

These macros rename all of the database tables, removing the "DBO_" prefix. For example, you may see a table named "dbo_sysconstraint". When the Rename_Tables macro is run, it renames that table to simply "sysconstraint".

Take the following steps to Rename Tables Macro:

  1. Change the Object Type to display the Macros.
  2. Right-click on a blank area below the listing of macros and click Navigation Options. Place a check in the Show Hidden Objects Box. Note: In Access 2003, go to Tools > Options and select Hidden objects
  3. Double-click the Rename_Tables, macroH, and macroI macros to execute them.
  4. Click “OK” to each prompt until it completes.
  5. If you get an “Action Failed” pop-up box, note the name of the Macro that fails in the "Macro Name" box then manually re-run that macro and each macro that appears after it.
Note: LexisNexis® no longer supports setup, installation, troubleshooting or usability of Microsoft® Access based Juris reports. For more information see article: SU8256 Juris Support for Microsoft Access Based Reports Ending 12/31/2020. Due to the end of support for MS Access, this article will be removed from Support Center on or after 7/01/2021.
Recommendation
Submitting...