I want to retrieve data from foxpro table with "UNION" sql statement using
datacontrol with oledb for odbc(using dbase). When I execute sql error
occur, message say:
"The database engine could not lock table "mst01" because it is already in
use by another person or process"
just for information the foxpro table on mycomputer.
the syntax :
adodc1.recordsource = "select acc_no from mst01 a UNION select acc_no from
any help is appreciated.