Database Files are Distroyer.

[bill993]

Hello All,
Here is common problum over here, The prbolum that The DATABASE files in FOX are Currpted when The Powe is failer, Any body have idia how to protect ?
i also want that The use are not look in database, by useing the Command BROW
please guide me

 

[ramani]

Hi
In all places where you update tables.. use

BEGIN TRANSACTION
Update all my table fields.. etc
END TRANSACTION
FLUSH

This can reduce the incidence of corruption. YOu have to resort to UPS ofcourse for help
ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[rgbean]

To add to want Ramani has said, you might want to go to

http://www.craigberntson.com/articles.htm

and read the "Avoiding Table and Index Corruption" article.

There are a number of ways to prevent "browsing" the data.
1) Restrict individual user's access to this data directory - then programatically change their access rights only in your program.
2) Encrypt the data - they can still browse, they just won't be able to read it!
3) Use the new VFP 7.0 Database Events to prevent them from even opening the files.
4) Move the data to SQL Server (or any other client-server database).

Rick