Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Detect for a ODBC connection before continuing with code ? 1

Status
Not open for further replies.
Webkins

Webkins

Programmer
Dec 11, 2008
118
US
I have an Access 2003 database which uses a System DSN ODBC connection to a SQL Server 2000 database on a Windows XP Professional PC. I would like to verify that this connection is present, installed, before proceeding with my Access VBA code and if not then skip the ODBC portion of the code which retrieves the data. Is it possible to detect the presense of this connection using VBA ?

Thank you all for replying.
 
Sort by date Sort by votes
check the errors collection of the connection object
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
3K
SoftwareRT
SoftwareRT
Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
479
Zyborg
Zyborg
Moss100
  • Locked
  • Question
Open filtered for and set cursor at particular record
Replies
1
Views
471
Moss100
Moss100
V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
462
strongm
strongm
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
525
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top