[thelist] Accessing Access

Dear evolters,
I have been given an assignment and I really need your help before
diving into it.

I have to write a script to open an MS Access file, check some
information, change a value from "FALSE" to "TRUE", and then forward the
user to a page depending on the information submitted from the HTML form
and the information returned.

Here's my question: Would it be possible to perform that function with a
CGI script (hopefully there's one available I can just modify)? The
biggest thing I'm concerned with is if the script will be able to
recognize the table and the fields in that table, and change the value
of one of those fields from "FALSE" to "TRUE". The database consultant
may be able to do it with VBA, if that's a more efficient route.

Any help you can send this way is truly appreciated. Thanks.

</ml>