>In order to save lookup and SQL select time on a very busy network, I have included the smaller, readonly tables into the project in order to include them in the main .app file. Each user runs their own copy of the .app on a local drive.
>
>Now the problem - if an attempt is made to open a lookup table more than once (the second time under a different alias from the first), the user gets an error message "File is in use" and will not open the table a second time. Inspection of the error log shows it's definitely the version of the table included in the .app that is already open, and that it is readonly. SET EXCLUSIVE is OFF.
>
>If I take the tables out of the project and set their attributes as readonly, there is no problem, but that defeats the 'neatness' of having them bound into the .app and distributing a copy to each user's machine.
>
>Any ideas what might be going wrong here? Is my understanding of what I am trying to do incorrect? I am using FPD2.5 (although I suspect this problem applies to FPW and VFP).
>
>Any help would be appreciated.
>
>Alan

Alan,

You have to use AGAIN clause in USE command in order to open table with different alias if it's already open in other workarea. It doesn't matter if table is included in app or not.

* Open for the first time - AGAIN is not req
USE MyTable IN 0
* Second time - AGAIN IS req
USE MyTable IN 0 AGAIN ALIAS MyTable2