Change or Update Query from Website

G

GrandMaMa

Universities want to create or change queries in our Access database from a
web page so they can see our best students academically.

They have informed me it can be done in Linux.

After they create or atler the Query, we will create a report from it in
house, review the information and mail the report to them.

Does anyone know how this can be accomplished?

Thank You in advance

Granny the Teacher
 
B

Brendan Reynolds

You can execute a DDL query from a web application just as you would execute
a DML query. There are, however, some serious security issues to consider -
DDL can be used to drop or alter tables, and to grant or revoke permissions,
as easily as to create or alter a query.
 
G

GrandMaMa

Brendon;
Thanks for the input. I will research this. We burn our files
twice a day. The computer with the IIS is stand alone only for students
homework and just E-Mail. If something was to happen being a school district
the Federal Law Enforcement would get involved and they would damage nothing
and just put us behind no more than 5 hours. The real files are on a
computer that has no internet access.

Again;

Thanks for getting back to me.
 
Top