Discussion:
DBF Encryption
(too old to reply)
Leonard
2005-10-05 16:50:04 UTC
Permalink
Hi:

I have an application developed in VisualFoxpro 6.0, and i need to find a
way to encryp the .dbf files, (maybe using a password), someone of you guys
know some way to implement this?

Thanks in advance!!


Leonard
Lee Mitchell
2005-10-05 18:04:48 UTC
Permalink
Hi Leonard:

Visual FoxPro does not offer any mechanism to prevent a user from opening
and reading its table files from another application that can read .DBF
files. In Visual FoxPro 7.0 and later, we added DBC events that allow you
to prompt a user to enter a password before they can open a database
container. However, if some one had a copy of VFP they could always issue
a FREE TABLES command to remove the table from a database container and
then view the table data. Therefore, the DBC events offer no real
production against an individual with even a moderate knowledge of VFP.

Visual FoxPro 8.0 and later ships with a _crypt.vcx. You can use this class
that uses the Windows encryption API function to encrypt data.

Since VFP offers no native capability to secure tables, you need to look at
other options. First, if the tables are on an NTSF partition, you may be
able to use group policies and NTFS properties to limit who can access the
folder containing the tables. Second, you could move the data to a product
like SQL Server, which offers much better security than VFP. Finally, you
might want to look at using a third-party product, such as Cryptor, to
encrypt the data.

For more information on Cryptor and other third-party products, see
www.hallogram.com <http://www.hallogram.com>.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003
Post by Leonard
I have an application developed in VisualFoxpro 6.0, and i need to find a
way to encryp the .dbf files, (maybe using a password), someone of you guys
know some way to implement this?
Thanks in advance!!
Leonard
Leonard
2005-10-05 19:21:02 UTC
Permalink
Hi Mitchell:

Thank you so much for your kind help!!

Leonard.
Post by Lee Mitchell
Visual FoxPro does not offer any mechanism to prevent a user from opening
and reading its table files from another application that can read .DBF
files. In Visual FoxPro 7.0 and later, we added DBC events that allow you
to prompt a user to enter a password before they can open a database
container. However, if some one had a copy of VFP they could always issue
a FREE TABLES command to remove the table from a database container and
then view the table data. Therefore, the DBC events offer no real
production against an individual with even a moderate knowledge of VFP.
Visual FoxPro 8.0 and later ships with a _crypt.vcx. You can use this class
that uses the Windows encryption API function to encrypt data.
Since VFP offers no native capability to secure tables, you need to look at
other options. First, if the tables are on an NTSF partition, you may be
able to use group policies and NTFS properties to limit who can access the
folder containing the tables. Second, you could move the data to a product
like SQL Server, which offers much better security than VFP. Finally, you
might want to look at using a third-party product, such as Cryptor, to
encrypt the data.
For more information on Cryptor and other third-party products, see
www.hallogram.com <http://www.hallogram.com>.
I hope this helps.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell
*-- VFP9 HAS ARRIVED!! --*
http://msdn.microsoft.com/vfoxpro/
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003
Post by Leonard
I have an application developed in VisualFoxpro 6.0, and i need to find a
way to encryp the .dbf files, (maybe using a password), someone of you
guys
Post by Leonard
know some way to implement this?
Thanks in advance!!
Leonard
Goupil
2005-10-07 14:38:48 UTC
Permalink
About encryption for passwords and such strings,
have a look at
http://www.atoutfox.com/articles.asp?ACTION=FCONSULTER&ID=0000000165
wich gives an easy way to encrypt datas.
Richard
Post by Lee Mitchell
Visual FoxPro does not offer any mechanism to prevent a user from opening
and reading its table files from another application that can read .DBF
files. In Visual FoxPro 7.0 and later, we added DBC events that allow you
to prompt a user to enter a password before they can open a database
container. However, if some one had a copy of VFP they could always issue
a FREE TABLES command to remove the table from a database container and
then view the table data. Therefore, the DBC events offer no real
production against an individual with even a moderate knowledge of VFP.
Visual FoxPro 8.0 and later ships with a _crypt.vcx. You can use this class
that uses the Windows encryption API function to encrypt data.
Since VFP offers no native capability to secure tables, you need to look at
other options. First, if the tables are on an NTSF partition, you may be
able to use group policies and NTFS properties to limit who can access the
folder containing the tables. Second, you could move the data to a product
like SQL Server, which offers much better security than VFP. Finally, you
might want to look at using a third-party product, such as Cryptor, to
encrypt the data.
For more information on Cryptor and other third-party products, see
www.hallogram.com <http://www.hallogram.com>.
I hope this helps.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell
*-- VFP9 HAS ARRIVED!! --*
http://msdn.microsoft.com/vfoxpro/
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
Post by Lee Mitchell
69-4500-8bf2-3f06689f4ab3&type=ovr
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003
Post by Leonard
I have an application developed in VisualFoxpro 6.0, and i need to find a
way to encryp the .dbf files, (maybe using a password), someone of you
guys
Post by Leonard
know some way to implement this?
Thanks in advance!!
Leonard
Loading...