>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