Perhaps the table is indeed open somewhere else? How about adding:
use ... again
>I am trying to catch the choice of the wrong table name. If a user picks the wrong table, I want to display a messagebox that tells them to choose another file, then on clicking OK the user is returned to the getfile() routine. However, I am getting table is already open errors and must be opened exclusively. I have tried quite a few ideas but the errors persist. There must be a way of doing this. Do you know how?
>
>Here is the main bit of code that I am using to open a table.
>
>
>pcFileName = ""
>pcFileName = Getfile('DBF')
>
>Select 0
>Use (pcFileName) Alias crime Exclusive
>Select crime
>
>Index On crimedate Tag crimedate
>* Set order to that TAG
>Set Order To crimedate
>
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
