hello,
I hav this application with visual studio.net 2003 environment, nd sql server 2000 runnin on the backend. Thr we hav a provision to tranfer some data from Access to SQL server. Initially it was runnin in 1 machine, but nw thr r 3 more machines with application installed is connected to LAN is accessin the previous machine which is acting as the server. But whenever we try to transfer frm access to sql server frm other machines i m gettin the error msg, 'operation must use an updatable query', but no probs wid tht while usin the main machine........ Why is that so???
I hav this application with visual studio.net 2003 environment, nd sql server 2000 runnin on the backend. Thr we hav a provision to tranfer some data from Access to SQL server. Initially it was runnin in 1 machine, but nw thr r 3 more machines with application installed is connected to LAN is accessin the previous machine which is acting as the server. But whenever we try to transfer frm access to sql server frm other machines i m gettin the error msg, 'operation must use an updatable query', but no probs wid tht while usin the main machine........ Why is that so???