>>Hi Matt,
>>
>>I agree with Naomi on the name.
>>In addition, your procedure assumes that table file name and alias name must be the same?, so it cannot open a table twice.
>
> You can pass in an Alias to use a different name, and open as many times as you want, but if you don't, it will use the table name
>

Oops, sorry - I somehow misread your Return line (probably because of reading too quickly, and because I had expected a "Return Used(theDesiredAlias)" there.

[Edited:] Or didn't I?, this somehow looks wrong to me, given that TableName does not necessarily have to equal AliasName (and in addition to Sergey's point about fullpath and extension):
>> Return (Upper(Alias())==Upper(tcTableName))



Regards
-Stefan