Stopping ODBC Updates

[PeteJohnston]

We have some "knowledgable" users who use MS Access 2000 to access data in an AS400 library via ODBC. I have nothing against MS Access (far from it, I've done some contract work in Access) but the users have been known to change data then deny that they have done it. I'm trying to find out if there is anything you can do to stop them updating files. I know that you can make an Access database "Read only" but I think that only stops them changing the database objects, ie. table definitions, forms, modules etc. and still allows them to change the data.

Any ideas about how this can be done? PeteJ
(Contract Code-monkey)

It's amazing how many ways there are to skin a cat
(apologies to the veggies)

 

[as400pro]

You will need to write an Exit Program.
Search the archives at

http://www.midrange.com

using searchwords ODBC, exit, and program, to find the topic discussed in several threads. You will also find sample code that others have written.

 

[khood]

PeteJohnston,

One of my clients had the same problem. They solved their issue by purchasing a third-party product called HIT ODBC. They offer an ODBC driver which can be read-only for the users. Their website is at hitsw.com.

I've used this personally & know it worked in a VBA application that I had written (as of 2 years ago).

Good luck.