Post reply

The message has the following error or errors that must be corrected before continuing:
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.
Attachments: (Clear attachments)
Restrictions: 20 per post (20 remaining), maximum total size 32.00 MB, maximum individual size 32.00 MB
Uncheck the attachments you no longer want attached
Click or drag files here to attach them.
Other options
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

Topic summary

Posted by sukishan
 - Aug 20, 2009, 01:32 PM
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.