You could emulate it in VFP by logging all transactions and doing a roll-forward or roll-back when the system is restarted. This is what SQL Server does. Of course, performance would probably be awful and you'd have to write and maintain all the code yourself. It would be much cheaper and easier to use SQL Server.
>Let's also consider the fact that SQL Server will finish a transaction when a server reboots from a crash/power failure. This is built into the product requiring no coding from the programmer. Could you even emulate this with VFP?
>
>Jack Mendenhall
>Reinsurance Management, Inc.