Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Globally change an Access connection string
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\Producti on\GrossMargin\GrossMargin_Equipment.accdb;Mode=Sh are 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Connection String - How to hide it? | Excel Discussion (Misc queries) | |||
Relative path in database query connection string | Excel Discussion (Misc queries) | |||
Excel data connection to Access | Excel Discussion (Misc queries) | |||
How do I use a connection string? | Excel Discussion (Misc queries) | |||
Can Excel and access update each other like a two way connection | Excel Discussion (Misc queries) |