Renaming field names in linked database

[Helge]

I am using a modelling system GAMS that is able to export data to an Access database, my Back-End database. The export facility makes Access tables with field names 'Dim1', Dim2' etc. Therefore I have made a VBA subroutine that changes these field names to something meaningful.
But then the next problem arises: I have an Access Front-End database that links to the Back-End database - and this Front-End is made with links to tables with field names 'Dim1', Dim2' etc. So when I change field names in the Back-End, my Front-End no longer works.
Therefore my question is: Can I in some way make the Front-End database follow or accept the field renaming in the Back-End database?
(I am using 'Name AutoCorrect' in both databases. The Back-End holds some hundred tables, and the Front-End some hundred queries.)

 

[Helge]

Re: Renaming field names in linked database: Problem solved

I have for a couple of days been working with other things,
but when I returned to the field renaming problem I found an easy way through
1) Copy all queries from Front End to Back End.
2) Back End: Make sure that "Name AutoCorrect" is enabled.
3) Back End: Change field names by hand or by VBA.
4) Front End: Delete all queries.
5) Copy all queries from Back End to Front End.
--- that's all!