Amanda,
Why does it reference FoxCode table? Did you try running VFPClean.app to fix the VFP settings?
Do you have combobox or textbox with AutoComplete turned on?
In addition, for your USE command try adding AGAIN keyword to avoid that error.
>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
If it's not broken, fix it until it is.
My Blog