>I've had tables with millions of records and not had corruption. >It's more a matter of application design.
I am sure you are right. And I plan to improve my design by making UI working with disconnected data from DB. Currently, the database/tables are open when UI forms are open. Then of course, if network goes down or user shuts off the computer, probability for corruption is much higher. There is another reason I want to move to SQL Server, more "political" than technical. Selling application with VFP database is much harder than with SQL Server. Some organizations when hearing VFP, don't even want to consider it.
>You'll also have transaction difficulties if you need to update the one table in SQL Server and others in VFP.
>
I realize that. Maybe I will have to prepare a small prototype and test it first.
Thank you for your input.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham