Hello Zoran,
Could you advise how to turn off excusive lock for OPENROWSET as below:

SELECT *
FROM OPENROWSET('MSDASQL',
'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;SourceDB=C:\SPCTesterSrc\SFH\ALS_Pre_Tank_Data\;',
'SELECT * FROM [ALS_PRE_TANK_SENTINES1_2008_08_26.dbf]')

The above query works, but I need move the DBF file to another location after I finish this query. I always get an error message saying "Cannot move ALS_PRE_TANK_SENTINES1_2008_08_26: It is being used by another person or program. Close any programs that might be using the file and try again".

Your help is appreciated...