If u r using ms access 97 then use adodc connection drag this from tool box then make a right click and do the connection then test ur connection if it is donn then go to ur module code and write there code as Set cn = New Connection
|