I want to develop some program that front-end is MS-Access and back-end database is MySQL. The way that I choose to make a connection between MS-Access and MySQL is by MyODBC 3.51 with set it on System DSN and now I complete develop this program.
Now I think about security that on DSN config is full with Username and Password to connect MySQL database. That mean every body can be access to this MySQL Database with no security.
However I try to find the solution for this case and found that when remove the password in DSN data source password box after I link it to MS-Access already it can be use by MS-Access with no error or password required again and nobody can connect to this DSN data source again cause it no password filled. But I don't sure that this way is OK or not for security.
How can I make a security on this case?