Best DB For Commercial Application

Hi,

I'm putting together a commercial application - one I want to sell through te Internet.  I'm very worried about someone 'hacking' to my tables once they are deployed and doing whatever with teh data.  I'm currently using Paradox, but I have access to create a dBASE table through P7 (of course) and I have Access97.  Which of these databases are the most secure for commerical applications.

I know I could add a password, but there are tricks all around on how to break the enturnal DB security schemes.  i also 'heard' encrypting and decrypting DB tables tend to have an adverse effect on them in the long run.  Can someone refer me to a good DB encryption program - preferably Freeware?

Thanks
LVL 3
d4jaj1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

anilmsCommented:
If your choice is limited to DBF, Paradox and Access, I would say that Access is the best for commercial deployment. DBF is no doubt the easiest to use, but then anybody can break into DBF files and do what they want. Access is atleast a proper database with all the tables in one single MDB file. You can also consider using BTrieve, your data is not only much more secure, your processing speed also goes up drastically.

Encryption/Decryption may not be a good option as people will still try to open the files using any editor and they might end up corrupting files ( For example, almost all editors replace chr(0) with chr(32) ). That is why among most RDBMS, encryption is used for transferring data and not for storing data.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.