I have created a local table in Access 2016 named rptLeqTable
.
I tried to rename the table in the Access Navigation Pane.
After renaming the newly created table from rptLeqTable
to rptMetricsTable
, I looked at the Table Properties.
The table properties still shows the original table name and refers to it as a
Shortcut to Table (Local): rptLeqTable.
There is no entry in the Navigation Pane for an object named rptLeqTable
.
Is there any way to rename the actual local table (and not just the shortcut)?
CodePudding user response:
You are renaming the shortcut in a custom category group you have created:
Go to Object view, Tables, and rename the table itself.
(Source: Andy Tabisz)