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 crimedate
I ain't skeert of nuttin eh?
Yikes! What was that?