Hi Jim,

What do you mean by use Transactions? It is large table used for contact management. No real calculations, just client address information and a notes field. The main form has a grid and the data is accessed through a modal details window that flushes every time it is exited or moved to another record.

We are using VFP6, Our new Dell server is running Windows 2000 Server and the workstations are on Windows 2000 & XP, total of 4 stations. We are all completely accessing the program and files that are stored 100% on the server. Is this the best method or do we install on each desktop and only the data on the server?

What do you mean by buffering type?

Thanks you for all of your input.

Jeff

> It sounds strange that "all of the days data is lost...". Do you use
> TRANSACTIONs?

> What version of FP/VFP is this?

> If its VFP, what is the buffering type used for the table in question?

> What version of Windows is running on the workstations?... How many
> workstations typically?

> What brand/version is the file server running?

> Do you know which particular user it is? It seems you do, given your
> statement '...someone turns their computer off with proper exiting...'. IF > you do, is there something unusual about that person's usage, like maybe
> sitting on an update all day and then only saving just before shutting
> down?? Or maybe switching to do work in other applications DURING some
> editing process in the (V)FP app. and then getting back to it later?? Does
> this user possibly have a network connection different from others, or a
> PC that's on a flaky power supply that browns out sometimes?

> I've always believed that a FLUSH will handle indexes and memo files too,
> but I can't say with 100% surety.

> Still, the strangest thing you say is that the entire day's work is lost.
> That leads me to believe that you do use transactions and that someone
> starts something early and only finishes that transaction near closing
> time.

> good luck

>Hello All,
>
>I have a currupt index problem that keeps poping up. Our master table has 350,000 records, 140 fields and about 50 indexes. About once a month when someone turns their computer off with proper exiting we get corrupt indexes and need to reindex. All of the days data is lost even though I issue a Flush command every time a record it exited. I don't have these problems with smaller 10,000 record tables?
>
>Any ideas? Also does the flush command also save memo fields to disk?
>
>Thanks in advance,
>
>Jeff