PROBLEM SOLVED!

The transaction log when I got the error said something about ODBC drivers so I went to the ms web site and downloaded the lastest MDAC drivers

(http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en)

I then...

Thanks for the reply Stacenic. I will look at the link and try it out later today. I will post back in the next few days to let you know...