Re: Microsoft Access as Front End to MySQL

On 01/06/18 21:33, Joseph Hesse wrote:
> Hi,
>
> I have MySQL server running on a remote server. There is a database on
> the server that I want users to access from their local computers.  I
> want an easy user interface, no direct SQL queries.
>

My response to that is to say 'write them some PHP forms then, and let them use web based access'

The damage users can do with seemingly easy to use GUI interfaces that have almost unlimited access to data is immense.

> I know that Microsoft Access or LibreOffice Base can be used as a front
> end to the back end server.
>
So can phpmyadmin...but do you want to let the users loose with that?

> I have never tried this before and am wondering if anyone has tried and
> was satisfied with this approach?
>
Frightens the shit out of me frankly.

Ther is a very good reaosn why every database operator in te world who has a multiuser commercial application writes very specific forms for their users limiting access to what they need, and only what they need, to do the job in hand.

If the users want to download entire huge data sets and play spreadsheets, well allow them that facility.

Just dont give them write access to anything.

It is not clear how secure the link is to the 'remote server' either.

The thought of someone hacking a name/password and fooling around with a MySQL server is frightening if the data is valuable.

> Thank you,
> Joe
>

-- 
To ban Christmas, simply give turkeys the vote.