Hi Mr. Excel, I have set up an ODBC to a SQL 2005 server to link the tables. I have set the ODBC up correctly and when i test the connection it is successful i nthe set up wizard. However once i try to open this table or query against it the connection fails. is there a setting in Access 2007 that enables the dialog box to enter the sql
credential in like access 2003?
Many thanks in advance
wdknisel
credential in like access 2003?
Many thanks in advance
wdknisel