>I've inherited a DB with a bunch of remote views which were designed with some ODBC connection on some long gone machine and no documentation.
>
>So when I try to open the view in the designer I get the error "Datasource name not found and no default driver specified"
>
>I imagine the name is somewhere in the DB, but where?
>
>TIA
See if this help:
open database your_db_name
DISPLAY DATABASE
list DATABASE TO c:\hi.txt
MODIFY FILE c:\hi