All,

We have encountered an intermittent problem with one of our major applications. This application is "mission critical" and runs 7X24. It is installed at a number of sites on NT 4 servers each with two or three data entry/browsing clients. We are using VFP 6. The NT is a file server. However, there are some VFP data loading applications that run on the server too.

Recently at the site with the largest database (60 Meg, 33,000 records)we have experienced strange behaviour in code that has been running day-in, day-out for many months.

The symptom is that when a database is selected in fact a prior selected one is selected instead. This appears to happen on the NT server and we have just encountered it on a client Windows 95. There are about 10 databases active.

On this client we have now proved the following code (snippet) works

select aliasname
if used("aliasname")
select
end if

...... other stuff

BUT

select aliasname

...... other stuff

ends up selecting the wrong database.

Does anyone have any ideas?

Regards

Richard Schneller
Director, Synergistic Systems