A possible reason: you have an error handler that ignores the access is 
denied error on the  opening of postcode


Sytze de Boer wrote:
> Can anyone suggest how this could end up in error 8, No table is open in the
> current work area
> 
> IF FILE("POSTCODE.DBF")
>    WAIT WINDOW NOWAIT 'Reindexing postal codes'
>    Select 0
>    Use postcode Exclusive
>    IF FILE('POSTCODE.CDX')
>       Delete Tag All Of postcode
>    endif
>    Index On Upper(town)   Tag postc1
>    Index On Upper(street) +Upper(town) Tag postc2 For !Empty(street)
>    Index On Upper(town)  +ruraldel    Tag postc3 For !Empty(ruraldel)
>    Index On Upper(town)  +Str(pobox1)+Str(pobox2) Tag postc4 For
> !Empty(boxdisp)
>    Index On Code            Tag postc5
>    Use
> ENDIF
> 

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to