Access front-end SQL back-end : quickly switch between prod & dev box
Posted on 2014-11-14
I have two boxes - prod & dev. I have an Access 2007 front end, with an SQL back end.
I'm looking for the quickest way to switch the entire DB between pointing at the different boxes.
Unfortunately, I connect to the server in pretty much every way possible, including VBA (ADO & DAO), pass through queries, linked tables.
Now this is fairly easy to do in VBA for the coded connections, but I wonder whether there's quick way of doing the same for all my pass through queries and tables.
Does anyone have any pre-scripted routines? Or perhaps there's a way to make the connections rely on a central file wherein I can change the connection string?
Any pointers would be appreciated.