DSN-Less Past Thru Query [WiredBox.Net

Group: Microsoft Access » microsoft.public.access.odbcclientsvr
Thread: DSN-Less Past Thru Query

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10

DSN-Less Past Thru Query

Foo.sg 04.09.2006 09:13:02

I know how to make my ODBC linked tables (mdb to SQL 2000) DSNLess. How do I
make my Pass Thru Query DSNLess?

Re: DSN-Less Past Thru Query

Stefan Hoffmann <stefan.hoffmann[ at ]explido.de> 04.09.2006 09:44:14

hi,

Foo.sg wrote:
[Quoted Text]
> I know how to make my ODBC linked tables (mdb to SQL 2000) DSNLess. How do I
> make my Pass Thru Query DSNLess?

With CurrentDb
.QueryDefs("QueryName").Connect = _
.TableDefs("LinkedTable").Connect
End With

--> stefan <--

Home | Search | Terms | Imprint | Contact

Newsgroups Reader - provided by WiredBox.Net