Secure Database

[Siddiq]

How can I secure my database in visual fox that no one can
open/browse/append or any type of amandment..

[sig][/sig]

 

[dgrewe]

From Inside a application ?
or
From Windows Explorer ?
[sig]<p>David W. Grewe<br><a href=mailtoave@internationalbid.net>Dave@internationalbid.net</a><br>[/sig]

 

[foxdev]

There are several ways, Siddiq, and I'm sure Dave has quite a few tricks up his sleeve. Several ways that come to mind:

[tab]changing a header byte so that the programs will refuse to read the DBF.

[tab]moving the DBFs into a ZIP file with password encryption.

[tab]putting the files on a secure resource, such as an NT volume, that restricts who and when the files can be accessed. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[JDurbin]

You can also use Application Securtiy logic in your app too. For instance in the init of a textbox control displaying salary information:

IF Thisform.nUserLevel < 1
This.Visible=.F.
ENDIF

Actually I am betting more and more security will be based on NT Authentication of the user logged in to Windows. You can substitute an API call to get the user logged on and check the group level. That would work along with Robert's idea of throwing the dbf's on an NT machine.

[sig]<p>John Durbin<br><a href=mailto: john@johndurbin.com> john@johndurbin.com</a><br><a href=

http://www.johndurbin.com>

</a><br>MCP Visual FoxPro<br>
<br>
ICQ #9466492<br>
ICQ VFP ActiveList #73897253[/sig]