Originally Posted by
Gicu
DaveC,
Can you give us some more info on how exactly do you attempt to link to your SQL server db? What Access version do you use (your forum id shows 2002)?
When you click on the External Data in any post 2007 Access versions you would see an icon for ODBC databases that, when clicked, opens the wizard that allows you to select an existing DSN or create a new one. If you select new it should guide you through the process (and during that process you should normally see Minty's screen to select the default database). If you don't see it I suggested you save the DSN as a file DSN as opposed to user or system DSNs, open it in Notepad, add your Database=...., save the file and select that the second time you click the ODBC button on the ribbon (instead of creating a new one browse to where you save the file DSN and select it).
Cheers,
Vlad