ODBC Databases not available for linked tables

[Robert Mayer]

After having reformatted my workstation, I installed Windows XP and
Office 2000 Premium. However, when I open an Access database to link
to a SQL Server database, I notice that in the "Files of Type"
dropdown list, "ODBC Databases" does not appear. I looked through the
Office 2000 setup, but didn't see any option that I was obviously
missing. How do I restore this feature?

- Robert -

[Steve Jorgensen]

I have to say, that's a new one on me. Perhaps, the ODBC libraries are
missing from the system, or something? Do you still find the Data Sources
(ODBC) tool in the control panel under "Administrative Tools"?

On 22 Oct 2004 07:45:19 -0700, po******@yahoo.com (Robert Mayer) wrote:

After having reformatted my workstation, I installed Windows XP and
Office 2000 Premium. However, when I open an Access database to link
to a SQL Server database, I notice that in the "Files of Type"
dropdown list, "ODBC Databases" does not appear. I looked through the
Office 2000 setup, but didn't see any option that I was obviously
missing. How do I restore this feature?

- Robert -

[Robert Mayer]

Actually, that was the first thing I thought of, so I immediately went
to setup of my ODBC profiles again and the connections all tested out
fine. I then went to do a repair install of Office 2000, but that
didn't seem to have any effect on the link tables feature.

- Robert -

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!