April 13, 2007 at 12:05 pm
We've got a situation in which we're going to re-write one of our oldest apps (~8 year old VB app). Currently it uses MS Access 2000 for local data storage, when the user takes the application off-site on their laptops. I would like to use SQL Server 2005 Express instead with the re-write. However, one of the biggest concerns is keeping the data confidential, due to HIPAA regulations. Currently, with the Access database, each user of a laptop has their own copy of the Access database in their My Documents folder, and we encrypt the folder using EFS in Windows XP. If we go to SQL Express, then I don't think it would be a good idea to have multiple instances of SQL Express for all of the users on a laptop. So, is it possible to encrypt the SQL Express database, or at least those tables with relevant client identifiers, so that if it were ever stolen then an unauthorized person could not access that data?
Kindest Regards, Rod Connect with me on LinkedIn.
May 5, 2007 at 11:20 am
You can encrypt data in 2005. See: http://www.microsoft.com/technet/itshowcase/content/sqldatsec.mspx
---------------------------------------
elsasoft.org
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply