Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
"Andy Kent" — — source: Informix-list mailing list archive (1991-1998)
> I have an order entry application that has been written with the Fourgen
> Case Tools and Informix 5.01 SE on a RS/6000. I would like to use a
> third party product for simple ad-hoc reporting like MS Access using
> ODBC and INET. Is there a way to protect the database from any
> unfortunate updates while using MS Access? I will be using the same
> user-id for the order entry application as well as MS Access.
Deny update permissions to the tables, and have the application do its
updates via Stored Procedures. Check the section on SPL in the "Guide to
SQL: Tutorial" - it's one of the things SPL was designed to allow you to
do. Going through a stored procedure bypasses the table-level
restriction. Could be a bit tedious modifying the Fourgen code though.
Alternatively, use a product like Informix-Viewpoint which was
specifically designed for end user querying. It would almost certainly be
easier to set up and quicker to execute than going through ODBC.
akent@cix.compulink.co.uk (Andy Kent)
-------------------------------------
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.