MS Access 2007 800A0E7A Error Provider cannot be found

Question

I have a vbs script running on my XP x32 machines that sends data to my 2007 Access db. All except 1 work. It generates the "Provider cannot be found" error. All systems are patched and running the same XP 5.1.2600 ver. I checked the MDAC and I have 2.8 SP1 on the rogue machine. The connection string is ...oConn.connectionstring= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDataSource & ";" with strDataSource = \\pcname\share\share\db.mdb. As stated it works fine on 50 systems but #51 is not a team player. Anywhere else that I should be looking? THX

Answer 1

The connection string you specified will not connect to an Access 2007 database. You need the ACE OLEDB Provider for Access 2007:

http://www.connectionstrings.com/access-2007
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 2

Thanks Paul I give it a try