Hi Robert,

I was thinking about this as I was out driving and realised I hadnt checked what references I had included.

Microsoft DAO 3.6 Objects Library
Microsoft ActiveX Data Objects 2.7 library

You have added MDAC 2.8 which is newer than MDAC 2.7 that I have included but I have just tried with 2.8 and it works fine.

Make sure you are using the JET4.0 provider not JET3.51

http://www.devx.com/vb2themax/Tip/18535

I just changed my code to

strConn = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source="
strConn = strConn & "K:\HTML\db\KAT5AV.mdb"
adoConn.ConnectionString = strConn
adoConn.Open

and got the error you are getting.

http://support.microsoft.com/kb/q238401/

says that This problem was first corrected in Visual Studio 6.0 Service Pack Service Pack 4

Service pack available here

http://msdn.microsoft.com/vstudio/do...6/default.aspx