Search This Blog

19 January 2011

Setup Access ODBC Driver

Perform following steps to setup Access ODBC Driver

  • Click Start, Settings, Control Panel
  • Switch the control panel to "Classical View", if it's already not in classical view
  • In Windows 2000, XP, Vista ODBC located inside Administrative Tools folder. Double click Data Sources (ODBC)
  • ODBC Data Source Administrator window displays
  • Select System DSN tab and click Add button
  • Select "Driver do Microsoft Access (*.mdb)" from the popup opened.
  • Then "ODBC Microsoft Access Setup" window displays.
  • Type name (We will enter name AccessCon) for Data Source Name and click Select button.
  • Select Database window displays. Find your database and click OK button.
  • Click OK on Microsoft Access Setup window and OK on ODBC Data Source Administrator window.

No comments:

Post a Comment