Recent upgrade of my sql 2000 server to 2005 brought serious problem whilst my access linked table database consist of several forms and sub forms which has completely gone mad now. When i try to connect to sql database using my ODBC connection it gives out error "ODBC connection error" when i check connecting and test using DSN connection it connects successfully I also tried to connect using "sql server native connection" for sql 2005 server and its same my form brings out mad results. I am totally confused what to do next???? Do i need to do fresh sql server 2000 and restore my database to get result as before or is there any way I can connect to sql server 2005 using ODBC connection??? or can i use any other connection other than ODBC