I did set up a DSN but it's not set for exclusive. Below is my connection string in the vb com object and how I call it in VFP. I've tried FileDSN's, User,System, and making a connection without using an ODBC data source. This code will work if all tables are closed but ofcourse I need the tables open for my various form controls.



cn.Open "FileDSN=D:\foxproado\vfpapp\fp.dsn;UID=;PWD=;Exclusive=No;OLE DB Services=-2"

rs.CursorLocation = adUseClient

rs.Open "update getrequirements set frag='test'", cn, adOpenKeyset, adLockBatchOptimistic



SET EXCLUSIVE OFF
thisform.olecontrol1.submit("GETREQUIREMENTS 98040 1")