Setting ODBC Connection string of Pass thru query dynamically

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Queries / November 2005

Setting ODBC Connection string of Pass thru query dynamically

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jayashree Krishna - 25 Nov 2005 04:17 GMT

Hi,

I have the ODBC Connect str of access 2000 pass thry query ,pointing to
oracle driver.How can I set the ODBC Connection string of Pass thru query
dynamically from the VBA code. I want the string to point to production
environment or development environment based on the choice the user makes.

Any help is greatly appreciated.

Thanks,
Krishna

Reply to this Message

Duane Hookom - 25 Nov 2005 06:50 GMT

A little DAO code like:

Currentdb.QueryDefs("qsptYourQuery").Connect = "...."

Signature

Duane Hookom
MS Access MVP

> Hi,
>
[quoted text clipped - 7 lines]
> Thanks,
> Krishna

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.