Read only ODBC linked tables

[skaurd]

Hi

Is there a simple way to make the ODBC linked tables read only for all users?

The database is going to be used purely for reporting and I don't wish for anyone to tamper with the data.

thanks

S

 

[khood]

The easiest way, short of setting up a secured application, is to change the ODBC driver to be read-only on all of the client PCs.

Good Luck,
K. Hood

 

[skaurd]

khood

How do I make the ODBC driver read only? It is a sybase ODBC driver. I cannot find a property to select.

thanx

S

 

[khood]

Forgive me if this is what you have already tried, but did you go to CONTROL PANEL-ODBC Data sources, select your data souce and hit the "configure" button? For Win 2k, it's within "admin services" (or something like that).

I don't have the same drivers that you are referring to, but the ones that I am using allow me to choose "read only" from the "other" tab within configure.

K.Hood