>I currently working with a SQL server with had a tables contain 1000 of records. My problem is when I create the remote view and logon to the server is ok, but when I try to save the view it gives me connectivity error. Is weird that when I use MS Access everthing works.
>The SQL server is use as LAN and required ODBC driver which I had installed in my pc.
>The thing is that if there's a ODBC error it shouldn't allows me to logon and selected the table, right!!!
>
>Does anyone knows what that error means!! (connectivity error[Oracle][ODBC Oracle driver]operation cancelled)
>
>Thanx in advance!!!
I am not sure exactly what you are doing. Are you saying that you can use the remote view to look at the records but when you try to make a change you get an error? Or are you getting an error when you create the view and try to save it? With a little more info maybe I or someone else here can help.