>>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.

I am trying to create the view and save it. The SQL server doesn't allow anyone make any change to there server.