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
atabase 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 OLEDBon'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
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
atabase LockingMode=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
on't Copy Localeon 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