Thanks again. Yeah it was something i was considering adding into my appendices and referring to in the report, a user guide for both Access and SQL Server so...

Thank you very much. Yeah i was thinking that i would probably need to include a guide for re-linking the tables also so thanks for confirming that for me.

I have also faced this problem with MSSQL Server 2005 Express Edition then i check connectivity from ODBC i give the solution pls go step by step

Start => Control...