I have been away from VFP for a long time, took a job that wanted VB. Anyway, I'm trying write a quick little program to SCAN through a remote view which is pointing to an Access database called Calibrations. From the VFP command window I can make updates to the remote view using REPLACE and TABLEUPDATE and everything works fine. When I use the following code to loop through the database I get "Connection Calibration is busy." error. Here is the code:

OPEN DATABASE fix
USE "calibrations" IN 0 ALIAS "Cal"

SELECT Cal
GOTO top

strTag = Cal.Tag_Number
dteCal = Cal.Date_Calibrated
dteNext = Cal.Next_Calibrated_Date

SCAN
   IF Cal.Tag_Number == strTag 
      IF dteCal < Cal.Next_Calibrated_Date then
         replace Cal.Next_Calibrated_Date WITH dteCal
         =TABLEUPDATE()
      ENDIF
   ELSE
      strTag = Cal.Tag_Number
   ENDIF
	
   dteCal = Cal.Date_Calibrated
   dteNext = Cal.Next_Calibrated_Date
ENDSCAN

USE IN SELECT("Cal")
CLOSE DATABASES

Any ideas what could be causing this? Like I mentioned above, if I go into the table manually or from the command window everything will update fine. I need to get this working ASAP. Thanks for any help in advance.

Randyjavascript:MessageSubmit()
[Save this message so it will appear for other members immediately]