You are here:
- Home
- Computing/Technology
- Databases
- FoxPro
- Database Protection
FoxPro/Database Protection
Advertisement
Question
Hi Carla Fair,
I want to protect my tables so that nobody else
can open and view their contents.
Can you please guide me How Can I do it?
Thanks & kind regards
Zafar Mahmood
Zafar,
The version of FoxPro you are running, OS (XP or Win98) and network (NT or Novell) is important in determining a solution that best fits your needs. But, I can give you some general information.
Security has always been the weak point in FoxPro.
1) You can encrpyt the tables. There are many software packages on the market such as NetLib Encryptionizer DE
see <http://www.netlib.com/file-encryption.htm>
* A google search on 'foxpro table security' will give a full list of packages.
2) You can limit who can access the folder where the tables reside. But, you will need to invoke an API or script like Windows Management Instrumentation (WMI) at runtime to allow users of the application access to the folder.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/wmi_...
3) You can move the tables to a database container and rewite your data access routines.
Related Articles
Carla Fair-Wright
Expertise
I can answer most general questions regarding Visual FoxPro. I am also very good with WSH, WMI,and FSO scripting and most internet technologies. I like to answer questions. To me there is no such thing as a dumb question. Don't be afraid to ask me anything about FoxPro or Visual FoxPro. I will try to answer all questions as quickly as I can. It may take me a day or longer for a complex error or one that is hard to reproduce. Please include the version of FoxPro you are using.
Experience
My professional experience with computer programming started in my early twenties, I went back to college with thoughts of finishing an engineering degree and ended up in computer science.
I have used Oracle, SQL Server, Access, and FoxPro.
Experience in the area
I have been using the product for over 10 years. I am a MCP in Visual FoxPro (Desktop).
I am ASQ Certified in Software Quality Engineering
Publications
Books
Chapter Author, Case Studies and Applications of Web Based Energy Information and Control Systems (Fairmont Press), June 2005
Chapter Author, Encyclopedia of Energy Engineering and Technology 1st Edition, (Francis Books) Spring 2006
Magazines
Component Developer Magazine
Maintenance Technology
Education/Credentials
BS - Computer Science
AS - Management Information Science
AS - Technical Management
AS - Electronic Systems Technology
Organizations
Member of Society of Women Engineers (SWE)
Member of American Society for Quality (ASQ)
©2012 About.com, a part of The New York Times Company. All rights reserved.