People often miss one important detail, shared access to the DBC. This is common:
USE SomeTable IN 0 SHARED
But it only opens the table shared, not the DBC. There are two solutions
SET EXCLUSIVE OFF before any file access
or
OPEN DATABASE SomeDBC SHARED before any other file access
>When a table is open in another datasession and another program attempts to :
>
use sometable again in 0
>The Fox growls loudly. Since the current program cannot change datasessions because it depends on other open tables in the current session and it cannot forcibly close the table in the other data session what is the programmer to do? what would you do?
>
>Thanks
>
>Glenn
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer