Ignore connection string changes on Access BE tables

[ronmcca]

I have a Access BE under source control. In development I attach to a test BE derived from the production BE. I keep a rotation for testing in multiple folders ex. X1, X2, X3, X4, X5. I would like to ignore the change when I attach to a different test BE and export source files.

ex changing from
"Connect": ";DATABASE=\\Server\BEFolder\Backup\X3\BEDatabase.accdb"
to
"Connect": ";DATABASE=\\Server\BEFolder\Backup\X4\BEDatabase.accdb"

All these table changes makes reading the Diff much more difficult.

[ronmcca]

After Adam's presentation on AUG 2-6-25, I don't think this is possible and still build from source.

[joyfullservice]

One approach you could take on this would be to add a function to run during the BeforeExport hook that links the table to the same back end table. This would keep the export consistent, but would relink the tables each time you export, which might not be ideal.

A second approach would be to tie into the AfterExport hook and create a function that would edit the affected source files and replace \X3\ with \X1\. This would be much more performant, and would give you the consistency in the linked table paths, eliminating the noise. You could still build from source as long as \X1\ was a valid back end path.