Change reference databases with VBA

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

This is pretty esoteric question...

I have a 'master' Access database that is referenced to about ten other
Access databases. All databases (including the master) are in several
different dated directories. Example of filepath 1:
"S:\whatever\whatever\2008\09\whatever\database1_200809.mdb" I would like to
write a piece of VBA code that will allow me to update my references from one
set of dates to another, by simply feeding a date to the VBA through a method
of my choice. Example: I supply a date of 12/1/2008 to my VBA in the master
DB, and the VBA code would now change my reference to filepath 1 from
"S:\whatever\whatever\2008\09\whatever\database1_200809.mdb" to
"S:\whatever\whatever\2008\12\whatever\database1_200812.mdb" Note that all of
the non-dated text in any particular file name or file path never changes for
any of my referenced databases. I would be thoroughly grateful (and
incredibly impressed) if anyone knows how to do this. I'm hoping that it
won't be 500 lines of code, either, if that is possible!
.

Relevant Pages

  • RE: Change reference databases with VBA
    ... I have a 'master' Access database that is referenced to about ten other ... All databases are in several ... write a piece of VBA code that will allow me to update my references from one ... and the VBA code would now change my reference to filepath 1 from ...
    (microsoft.public.access.modulesdaovba)
  • Re: In Praise Of Mark Hudon
    ... kinda depends on how you define "it" ... ... one shot at a time in a bolt action -- as you can only do so much ... 'master of the masters'. ... references they forgave me. ...
    (rec.climbing)
  • Re: Gormenghast
    ... characters as such. ... And there were several references in it to brain-disease, ... one similar reference to that in _The Master and Margarita_, ... < _Master i Margarita_ ...
    (rec.arts.sf.written)
  • Re: Amend Access database from Excel
    ... I followed your post to the letter including setting references to the ... Microsoft ActiveX Data Objects 2.x Library and ran the code directly from ... | The code below uses ADO to connect to the Access database. ... | Set oConn = New ADODB.Connection ...
    (microsoft.public.excel.programming)
  • Re: Can Access 10 and 12 Get Along?
    ... both Access versions can work on same PC, but you have to follow rule that you develop Access database on Access version it will run at users PCs ... message "The expression OnOpen you entered as the event property setting ... When I look at the References I see that Microsoft Access 12 Object Library ...
    (microsoft.public.access.modulesdaovba)