Yes, it's actually just an extension of known BeforeOpenTables code.
>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
Edward Pikman
Independent Consultant