Pass-Through, Default DSN?
From: Gerard (anonymous_at_discussions.microsoft.com)
Date: 04/29/04
- Next message: George Schneider: "Crosstab error"
- Previous message: Luther: "Re: Update Query Follow-up"
- Next in thread: Les: "Pass-Through, Default DSN?"
- Reply: Les: "Pass-Through, Default DSN?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Apr 2004 08:25:03 -0700
Hey all,
I am running Access 2k on Win 2k with SQL Server 2k.
I am converting my companies Access database to SQL
Server. In the meantime while I develop the VB
application, we are using the Access database application
as a front end to connect to SQL Server. I made a Pass-
Through query so it connects to the ODBC to run the query,
instead of running it against the MSJet. This method is
much faster with one small exception. Every time the
query runs, a dialog pops up asking what DSN to connect
to. I want to eliminate that dialog. Is there a way to
specify a default DSN or something similar, so this dialog
doesn't pop up every time. As always, I appreciate all
the help in advance.
Gerard - GMS
Programmer / Processor
P.S. I have a box of recycled bits for the best post ;)
- Next message: George Schneider: "Crosstab error"
- Previous message: Luther: "Re: Update Query Follow-up"
- Next in thread: Les: "Pass-Through, Default DSN?"
- Reply: Les: "Pass-Through, Default DSN?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
