Ok, this problem is maddening.
I have an older section of code that has worked for years. Recently, it started throwing Error #: 3 File is in use.
The full error is:
Error #3
Message: File is in use.
Line 240
Code Foxcode table is not found, is not correct version or is incompatible.
Line 240 is attempting to use the city table in my code.
The city table is in the CDMS DBC.
This code is on the click of the OK button to check for updates.
Here is my code.
if dbused(lcCurrentDataLocation + 'cdms')
set database to (lcCurrentDataLocation + 'cdms')
close database
endif
if used( ("cdms" + right(upper(laDataFolder[lnCount,1]),4)) )
use in ("cdms" + right(upper(laDataFolder[lnCount,1]),4))
endif
set exclusive off
close tables all
if ! used("City")
use in 0 (lcCurrentDataLocation + "City") ----line 240
endif
** as you can see, getting despereate here to ensure table is closed.
Using the tool 'unlocker', I do not see any file locks on this table. What on earth could be going on?
TIA
Amanda
Amanda Morton
System Analyst
Harrisburg Project