Walter,

>There are a lot of things you can do about this, however a lot of depends on the nature of your application. Reclycling records and using random generated PK fields help to let your indexes say balanced and keep the tables compact. Table or row buffering with transactions helps to avoid almost all corruption problems i've ever encountered.

If you're saying "Begin Transaction", these gives us a lot of file locks if you have 100 plus users connected/accessing specific table. I don't know why? I presumed it's the limitation of VFP table. Before, we blamed the server, cabling, etc. In short we upgraded Server and did recabling but the problem still occured. I already asked it here in UT before and the consensus was, we must consider whiching to high-end databases, and so we did. SQL Server is not a silver bullet solution to problem but stable enough.