[SOLVED] MS Access 2007 renaming shortcuts in custom groups to change the names of the objects

MS Access 2007 renaming shortcuts in custom groups to change the names of the objects

In Access 2007 I create a lot of custom groups to organise the large number of queries and tables in a single database. There are lots of individual sub queries that link up to larger queries. In development, I find it necessary to frequently rename some of the queries permanently after they have been added to a custom group.

But Access only renames the shortcut that is in the group and not the actual object. This causes broken references. So I now have to remove an object from the group, rename it, then add back to the group. This adds further problems if you have lots of queries and tables.

Is there any way to configure Access to rename the actual object and not just the shortcut from within a custom group?

Thanks

Solution

Unfortunately, you cannot do this in Access. That's the idea of shortcuts. Actually, it is the same as in Windows (you can rename the shortcut but the object itself stays intact).