Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!sharkey!cfctech!teemc!ka3ovk!ki4pv!cdin-1!dsinc!wells!mdi386!bruce From: bruce@mdi386.UUCP (Bruce A. McIntyre) Newsgroups: comp.unix.xenix Subject: Re: Help! (SCO FoxBASE+) Summary: These are usually file protection problems.. Keywords: FoxBASE+, Index, File error Message-ID: <170@mdi386.UUCP> Date: 25 Oct 89 18:51:06 GMT References: <32@agtoa.UUCP> Distribution: usa Organization: Wells Computer Systems Corp., Levittown, Pa. 19058 Lines: 39 In article <32@agtoa.UUCP>, greyfox@agtoa.UUCP (Bruce Ide) writes: > I'm having serious difficulty getting SCO FoxBase+ to index. This is what > happens: >[description deleted ] > file is in use > > The runaround if I have ever seen one. Dogname is part of the data base > structure, and a smaller version of the file will index perfectly. The > large version is 1.27 megabytes, and the small version isn't more than > two or three Kbytes. Ulimit allows for files up to one Gigabyte, so > that's not the problem. Also, when I restore the file and the old index > off of backup and reindex, it says "file not found". Same goes for > PACK ALL and PACK. Does anyone out there have an idea as to what the > problem may be? This is SCO XENIX V2.2.3 SYS V, foxbase version 1.0.3. > Reply to me using mail, unless everyone else on this discussion would be > keenly interested in the solution. Thanks. > -Bruce uunet!agtoa!greyfox I have shipped several systems with large files (multi-mega) under Foxbase and Xenix, (V2.2.3) and found that usually the error is caused by file protection. If you don't have write permission in the directory, yu can't index. If the index is owned by someone else, and you don't have write permission, you will get the "file in use" error or if you don't have read permissions, it will get a "file not found". Make sure that all indexes are set to the right permissions, see if they are _rwxrwxrwx to insure that they don't have problems, or make sure that all users are in the same group and set them _rwxrwxr__. You will find most of your problems will disappear. In your code, right after you do an index, call a "run chmod ug+rw indexname.ndx" and that will fix it... I hope that this gets rid of your problem.. bruce -- ========================================================================= Bruce A. McIntyre, McIntyre Designs, Inc. VOICE(215)322-1895 143 Bridgetown Pike, Langhorne, Pa. 19047 DATA (215)357-2915 {wells|lgnp1}!mdi386!bruce bruce@mdi386 tbit+