>>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