To anyone that ever has this same problem!

I was correct in that my mdac installation was corrupt. Not sure how it became corrupt but I reloaded windows xp pro...

I have done some checking on mdac. It appears that since I'm running Windows XP Pro, MDAC version 2.7 SP1 on Windows XP SP1 should be on my machine. I...

It has to be a problem with my machine because I just had another person in my dept. connect using the same username and password I am using, no problems...

I am using sql authentication. I have been working with the dba that set up the database for me and he says nothing has been altered with my permissions. He...