Hi Ed ---
Sounds reasonable to me. Someone once told me that VFP gets "confused" if you have multiple open databases and tables where the table names/structures are the same.
>>Hi evereyone!
>>I have a form where I have three buttons so that I can access info from separate databases each time. The problem is how can I open each database for each click and close the ones not in use. Do i need to add all the tables from all databses to the data environment. Actually these databses have same tables, stucture-wise and name-wise, but databse names are different.
>>PLEASE HELP!
>
>I think it would be enough to change database (CLOSE/OPEN DATABASE) and then fire:
>cDbcpathname=dbc()
>Thisform.DataEnvironment.CloseTables
>Thisform.Setall("Database",cDbcpathname,"Cursor")
>Thisform.DataEnvironment.OpenTables
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05