FoxPro database connector - DBF Encryption

Author

DBF Encryption

Leonard

2005-10-27, 8:34 am

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-27, 8:34 am

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/i...cid=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

>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

Leonard

2005-10-27, 8:34 am

Hi Mitchell:

Thank you so much for your kind help!!

Leonard.

"Lee Mitchell" wrote:

> 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/i...cid=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
>
>
>
> guys
>
>
>
>
>

Goupil

2005-10-27, 8:34 am

About encryption for passwords and such strings,
have a look at
http://www.atoutfox.com/articles.as...R&ID=0000000165
wich gives an easy way to encrypt datas.
Richard
"Lee Mitchell" <Leemi@online.microsoft.com> a écrit dans le message news:
47WCJddyFHA.3772@TK2MSFTNGXA01.phx.gbl...
> 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/i...cid=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
>
>
>
> guys
>
>
>
>

Sponsored Links