Re: EXCEL spreadsheet to INFORMIX through ODBC

> Hi all, > I set up an Excel spreadsheet to our production database > through ODBC driver to get a report. Everything was working > fine, and life was good until I found a little problem with the > SQL tool in Excel. Normally, to get a report Excel will write > a select statement according to criterias that the users input/ > choose. It also allows anyone to Edit the select statement it > writes in a little box. What I did was changing that select > statement to delete/update statement. And it ran. What > surprised me was that it actually ran the statement against > the database and delete/update tables accordingly. This is > not what we want. I have not been able to find any options > to turn this thing off so that the user cannot edit the generated > select SQL. I know all the permissions the user has are > defined through the username that is defined in ODBC. > We don't want to change all the user permissions on the > database side. Is there any other way ? > > MS Excel 2000 > IDS 9.30 UC1 > Dynix/ptx V4.5.3 > > Thanks > N. > > Hello N., What ODBC drivers are you using? Native? I know that my own company's drivers implement a variety of features, which are designed to prevent unauthorized database updates. They range from simple read-only check boxes on the client to advanced server-side security rules. Quite possibly, your driver may have such features? Netrista Khatam Technical Services Manager OpenLink Software Universal Data Access & Virtual Database Technology Providers http://www.openlinksw.com