No System DSN Driver Options

I have looked in the knowledge base and I haven't seen already solved questions that help me.  One of our machines, Win XP Pro SP 2, only shows three items in the Add button of the System DSN tab of the ODBC Data Source Administrator.  The User DSN has an Microsoft Access Driver entry but if you were to click Configure there is an error (attached, UserDSNError001).  And if I click Add on the User DSN tab as well, there are on the same three options.  How can I get all the options that should be available (that I see on my other machines, even those that don't have MS Access installed)?  I have tried to install the Microsoft Data Access Components MDAC 2v8 and received a message that my system is incompatible.  I went to the site to install a lower version and got message that 2v7 was installed successfully, but I have no additional options.  I believe we are 32 bit and I see so much reference to 64.  What's the deal.  Can I simply get these additional driver options in the Source Administrator (without installing Access)?  Thanks in advance.
UserDSNError001.doc
NewDataSourceOptions.doc
dcastronwAsked:
Who is Participating?
 
dcastronwAuthor Commented:
I realize this one is ugly and folks haven't wanted to touch it.  My manager found the answer at http://support.microsoft.com/kb/818954.  Thanks anyway!  Dione
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.