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