I had some strange error with databases and different datasessions so I started to see what's really happening. And the result for me is that databases are not datasession specific, and I don't like that becouse tables are really tied to a datasession.

Try this:

OS1 = CREATEOBJECT('SESSION')
OS2 = CREATEOBJECT('SESSION')
set datasession to 2
open database 'data1\myproj'
set database to myproj
? DBUSED('myproj')   && Returns .T., thats right...
? DBC()   && Returns the right file and path...
set datasession to 3
? DBUSED('myproj')   && Returns .T., NO I DON'T WANT THAT, I'm in datasession 3...
set database to odyssey  && Shouldn't work but it dose...

So now I have the same database in two different datasession and this is not how it works with tables, if I open a table in one datasession, USED() will not return .T. in another datasession...

Has someone else encounterd this problem? Is it a bug from Microsoft in VFP6 or is this the way it should work?

Please help me out here!