[AccessD] Drive mappings & global constants

Dear List

I have just been asked to resolve something, in zero time as usual, and I'm
sure there should be an elegant solution I just can't think of it.

There is a team that has 100+ Access databases, Excel spreadsheets and Word
templates that contain dependencies on a particular network drive that is
currently mapped to 'h:\'. In a few weeks time they will no longer be able to
use 'h:\' and will be given a new drive mapping. At some point shortly after
that, the server will be changed too, so the current DNS path will no longer
be valid either.

I don't know -and nobody will say for definite - what the new mapping & new
DNS path will be. These files are critical and the business insists on no
more than 24 hours downtime.

The dependencies include import/export routines, linked tables & linked
files.

What I would like to do is run a giant F&R on the code modules and replace
the root drives with a constant, and then make the constant available so that
ALL the applications use the constant. Then they can muck about with drive
mappings etc. to their heart's content and I won't have to come back to the
South coast and stay up all night changing code.

Any tips or ideas for making this work? Is it possible? I have code for
updating the code modules that should almost work but I've no idea how to
expose a constant across multiple apps.

TIA

Roz

"DSMP Mission - Building the future of Barclays computing infrastructure.  4K
customers won in 2007, 10k+ to delight in 2008."



This e-mail and any attachments are confidential and intended solely for the addressee and may also be privileged or exempt from disclosure under applicable law. If you are not the addressee, or have received this e-mail in error, please notify the sender immediately, delete it from your system and do not copy, disclose or otherwise act upon any part of this e-mail or its attachments.

Internet communications are not guaranteed to be secure or virus-free.
The Barclays Group does not accept responsibility for any loss arising from unauthorised access to, or interference with, any Internet communications by any third party, or from the transmission of any viruses. Replies to this e-mail may be monitored by the Barclays Group for operational or business reasons.

Any opinion or other information in this e-mail or its attachments that does not relate to the business of the Barclays Group is personal to the sender and is not given or endorsed by the Barclays Group.

Barclays Bank PLC.Registered in England and Wales (registered no. 1026167).
Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom.

Barclays Bank PLC is authorised and regulated by the Financial Services Authority.