You'll also get this error if City table is opened already under different alias.

>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