In Access I am unable to link to an ODBC database??

[Guest]

I have created a new database in Access and I am trying to link to my
Timberline database thru ODBC. When I click in Files of Type and click on
ODBC nothing happens. I go back to the original window. I have gone thru
Repair - I've uninstalled and reinstalled using Custom and selecting every
option. I was able to do this in Access 2000 but not now in Access 2003.

Any Ideas?

 

[Arvin Meyer [MVP]]

Most likely, the Timberline DSN has gotten corrupted. Since Timberline uses
Pervasive SQL, security sometimes renders the DSN inoperable. I've never
spent much time trying to find out why. What I always do is just delete the
existing DSN and recreate it, then reconnect tables if necessary. That
process hasn't failed me yet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access