>>>I have a table named zip that is stored on disk as \vfpapps\sc\data\sczip.dbf in a database named sc.
>>>
>>>I issue the command in one form use zip in 0 and it works fine but in another form it does not work. With the form that it does not work in I get the error message that \vfpapps\sc\zip.dbf is not found. I determined that the database is open by issuing dbused('sc') and it returns true.
>>>
>>>I cannot determine why I get different results from the exact same commands in 2 different forms.
>>>
>>>Thanks,
>>>
>>>Paul
>>
>>I can't tell you why it works in the one form, but I can tell you why it's not working in the other. If you do USE Zip, it expects to find a table named Zip. If you want an alias, you need to do USE sczip ALIAS zip IN 0.
>>
>>-Michelle
>
>Hi Michelle,
>
>Is this the case even when I have gone in to modi stru for the table and on the 3rd page changed the name of the table to zip? Because I have been doing this with a lot of tables and it has seemed to work except for this one case.
>
>Sorry for dumb question,
>
>Paul

It can't be too dumb of a question; I didn't even know you could do that! :) In that case, I don't know. Is there some reason you can't just call it what it is?

-Michelle