Change or Update Query from Website

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GrandMaMa - 17 Nov 2005 19:57 GMT

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

Reply to this Message

Brendan Reynolds - 17 Nov 2005 22:02 GMT

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.

Signature

Brendan Reynolds

> Universities want to create or change queries in our Access database from
> a
[quoted text clipped - 10 lines]
>
> Granny the Teacher

Reply to this Message

GrandMaMa - 17 Nov 2005 22:26 GMT

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.

> 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 -
[quoted text clipped - 14 lines]
> >
> > Granny the Teacher

Reply to this Message