Entering database password using code

[infinitx]

Hi,

I have a front-end and a back-end database. I set a database password in the back-end. However, everytime I open the front-end database which is linked to the back-end, I get a message that says something along the lines of "the password is invalid."

It didn't even prompt me for a password in the first place! However, I would like to code that when the first form opens (before it gets the chance to link to the back-end database) the program enters the database password by itself.

The only reason why I even have a database password is because I do not want the users to be able to access the back-end freely. Although I have disabled the shift-key, I still believe that, one, it is quite easy to bypass that security feature, and two, I think that a password would be a good addition.

Do any of you know how I would go about coding so that the program enters the database password by itself, without prompting the user.


Thank you very much!

 

[ghudson]

Go through the motions of relinking your linked tables. You will be prompted for the password and the frontend will store the password [but the users will not be able to find or hack it out] so that the frontend will not ask the user for the password when ever they open the frontend.

 

[infinitx]

Thank you very much!

That got the job done!

 

[ghudson]

Another satisfied customer!