>>I have noticed that when I open a table with the code below, it get's reported as not open when I try to access it from a form. Why?
>>
>>
>>Close Tables All
>>FileName = Getfile("dbf","Select file number","Load")
>>Use &FileName
>>
>
>Are your file names beggining with a digit? (select file number)
>
>If so, they will not have the alias name you expect. Add an ALIAS clause to your USE command so it always has a predictable alias.
There are also some characters (although legal, they probably shouldn't be used) get changed in the alias. I don't have a list of them, but I know that # in a file name is legal but gets modified to _
USE FR#CNTY results in an alias of FR_CNTY