Checking you have the correct ODBC Access Database Drivers

Started by sukishan, Aug 20, 2009, 01:32 PM

Previous topic - Next topic


Another frequent problem with using databases on a web server is not having the correct ODBC Microsoft Access Driver installed.

To check what version of the ODBC Microsoft Access Driver you have installed on your system then follow the steps below: -

First you need to open the 'ODBC Data Source Administrator' you will find it under 'Control Panel', 'Administration Tools' and it will be called 'Data Sources ODBC'. If you can't find it on your system then you don't have any ODBC drivers installed.

Once you open the ODBC Data Source Administrator select the 'Drivers' tab . You should now see a list of ODBC drivers installed on your computer.

Look down the list for 'Microsoft Access Driver (*.mdb)'.

Next to the 'Microsoft Access Driver (*.mdb)' there will be a version number. Check that this version number is 4 or above.

If you do not have these drivers or the version number is below version 4 you may find the latest drivers: -
Shipped with the latest Microsoft Office distribution.
Shipped with the latest Microsoft Data Access Components (MDAC) distribution.
A good beginning makes a good ending

Quick Reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it has been approved by a moderator.

Please leave this box empty:
Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:

Shortcuts: ALT+S post or ALT+P preview