We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Best DB For Commercial Application

d4jaj1
d4jaj1 asked
on
Medium Priority
231 Views
Last Modified: 2010-04-04
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
Comment
Watch Question

Commented:
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.