Hi Mark,

I already tried what you suggested but still the result set is not up to date.
this is the connection string that I made in the load event of my form

Public VCONNSTR2,PVDBCPATH
PVDBCPATH = F:\ACCTFILE\ACCOUNTING.DBC
sConn = "Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;SourceDB="
sConn = sConn+pvDBCPath+";SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"
Open Database &pvDBCPath
DBSETPROP("ACCTGCONN","CONNECTION","CONNECTSTRING",sConn)
nConn = SQLSTRINGCONNECT(sConn)

IF nConn>0
VCONNSTR2 = sConn
ELSE
=MESSAGEBOX('Cannot connect to Static Database!',0+16,'Connection Problem')
RETURN
ENDIF
thisform.vconnstr2 = SqlStringConnect(vConnStr2)

&& So when I query a remote table, I do it this way
csql = [select * from Accounting!items]
sqlexec(thisform.vconnstr2,csql,'cur_items')


is there a possible way on how to refresh my connection to the database?