Change or Update Query from Website

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
Back
Top