From: jmillerWV on 10 Sep 2009 18:40
Hello again all,
Have a SQL backend, and an Access2003 front end. When I run a passthrough
query I get the "Select Data Source" dialogue box. Is there a way to send
info along wiht the command to run the query to choose the data source
without user intervention? code I am using now:
Dim stQry1 as string
stQry1 = "MyPassthroughQuery"
Simple I know but it works to run the query.
Thanks in advance for any assistance.
From: MGFoster on 10 Sep 2009 20:11
> Hello again all,
> Have a SQL backend, and an Access2003 front end. When I run a passthrough
> query I get the "Select Data Source" dialogue box. Is there a way to send
> info along wiht the command to run the query to choose the data source
> without user intervention? code I am using now:
> Dim stQry1 as string
> stQry1 = "MyPassthroughQuery"
> docmd.OpenQuery stQry1
-----BEGIN PGP SIGNED MESSAGE-----
You query needs the correct Connect string w/ userid and password, if
necessary. If you don't want to set up a DSN you can use a DSN-less
connect string. See this site for connection strings to various DB
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
-----END PGP SIGNATURE-----
Prev: Replace Letters
Next: Do I need to convert a hyperlink field to text to change it?