Relocating Backends - Need quick method to update the Front Ends

[meagain]

Hi,

I'm relocating several backends to new locations. As you know, the front ends will require their linked .mdb tables redirected to the new locations. The only thing that is changing is the drive letter.

Does anyone have a solution/code which would replace the drive letter of all of these table locations, rather than me doing this all manually? Every front end has multiple backends that need to be reconfigured, so it is quite a timeconsuming process.

Using Access 2002.

Thanks!
LP

 

[1DMF]

Look in CurrentDb.TableDefs

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music