teknogeek9
Programmer
Fellow geeks,
I am developing reports using MS Access 97 connected to an Informix database. Currently, I am using the ODBC driver provided by Merant (Intersolv). Since the data has to be real-time, the tables are linked rather than imported into Access. Unfortunately, this gives a "smart" user the ability to update records.
Is there any way to restrict an ODBC driver so that the user can only read the records from the database?
Thanks in advance
I am developing reports using MS Access 97 connected to an Informix database. Currently, I am using the ODBC driver provided by Merant (Intersolv). Since the data has to be real-time, the tables are linked rather than imported into Access. Unfortunately, this gives a "smart" user the ability to update records.
Is there any way to restrict an ODBC driver so that the user can only read the records from the database?
Thanks in advance