Security with MySQL server

[Guest]

We are using MySQL as the backend server and MsAccess as the front end.
MySQL is secured and MsAccess can only link to the tables via ODBC. But I
want to secure the front-end so that the users can not delete or make
changes to any forms, reports, etc. I've read Micorsoft's FAQ on security and
browse through this newsgroups, but I'm not getting much information that
fits this setup (MsAcess FE and MySQL BE).
From what I've read so far: I can't make the .mde file because I have a
backend (this option is also not available for me to use on the
Tools/Security menu).
Any pointers are very much appreciated.

 

[Rick Brandt]

We are using MySQL as the backend server and MsAccess as the front
end. MySQL is secured and MsAccess can only link to the tables via
ODBC. But I want to secure the front-end so that the users can not
delete or make changes to any forms, reports, etc. I've read
Micorsoft's FAQ on security and browse through this newsgroups, but
I'm not getting much information that fits this setup (MsAcess FE and
MySQL BE).
From what I've read so far: I can't make the .mde file because I
have a backend (this option is also not available for me to use on the
Tools/Security menu).
Any pointers are very much appreciated.

You certainly can make an MDE of a front end. That is what the vast majority of
developers do. Your file is either in the wrong file format for your Access
version or you have some compile errors. Correct those and then you will be
able to make an MDE.