Password for MySQL

[Peter Francee]

Hi Friends

I have developed a MySQL application with MS Access as the front end. In my VBA code to connect to the MySQL, I need to provide the password for the database and this is my concern.

There are many tools and software in the market that can extract the VBA code from a Access MDE file and they can have a look at the code and get to know the password and access the tables in the database as the password is hardcoded in my VBA

I am completely at sea with this issue.

Somebody please point me in the right direction so that I can secure my database from anyone who has a dubious intention.

Hope I am clear. If not, please let me know and I shall explain in another way.

Regards
PF