Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 143
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Connection String - How to hide it? fijieddie Excel Discussion (Misc queries) 4 March 4th 09 04:46 AM
Relative path in database query connection string DanL Excel Discussion (Misc queries) 1 February 20th 09 07:09 PM
Excel data connection to Access Sharon Excel Discussion (Misc queries) 1 February 14th 08 09:33 PM
How do I use a connection string? BrandenK Excel Discussion (Misc queries) 0 September 25th 07 07:10 PM
Can Excel and access update each other like a two way connection CmK Excel Discussion (Misc queries) 0 February 23rd 07 02:01 PM


All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"