asp forms. Update from Microsoft.Jet.OLEDB. 4.0 to 12.0.

Question

User876561910 posted

I have an old website which uses an Access database to provide the data for asp form drop downs, etc. the forms also write to the database.

Following an update by the web hosts of their server my website has stopped working.

I have this error the microsoft.jet.oledb.4.0 data provider is not registered on the local machine

The web host has said that their servers only support 'Microsoft.Jet.OLEDB.12.0.

I don’t have time to rebuild the website until the summer so is there some way of updating the database links to Jet 12.0 that is simple to do.

Thank you

Answer 1

User753101303 posted

Hi,

This is actually  ACE.OleDb. You would need to change the connection string: https://www.connectionstrings.com/access/

Not using Access but I'm fairly sure you'll need to upgrade your mdb file to the accdb file format (using Access) else you should be able to read but not write this file..