Globally change an Access connection string

P

PJFry

I am trying to establish a UAT environment for my staff to test excel
reports. These files have a number of embedded queries that use this
connection string:

Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data
Source=Q:\Departments\Finance\DataSources\Production\GrossMargin\GrossMargin_Equipment.accdb;Mode=Share
Deny Write;Extended Properties="";Jet OLEDB:System database="";Jet
OLEDB:Registry Path="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking
Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk
Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System
Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale
on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet
OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False

Is there a way to change all of the Data Source= strings so I can point the
file at the production copy of the database from the UAT copy? I have been
just manually editing the text, but that gets old really fast.

Any thoughts?

Thanks!
PJ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top