>Because any user with a copy of VFP can open the databse of my application and view or change data outside of the application, how can I implement a level of security to my application like including a password to my database.

One security improvement you can make is to group any tables that don't need user DBC updates into a separate DBC and put that into a readonly server directory. I do that with most of my DBCs, and many tables as well.