Is it possible that a Table believes it's open when it isn't?

[bebbo]

I'm constently having problems with indexing on a certain file. Often it can't be opened exclusively although the file isn't open anywhere else. It's always the same file. Is there something I can do about this. Also it is only at one site. the program is else where and it works fine all the time.

Thanks

 

[ShyFox]

bebbo (Programmer)
Need more info. Do you use this file remotely or local? Is behind a site or behind an application?

As I go deeper the road seems to go further. We're just simply pasangers on the road of knowledge.

 

[Mike Lewis]

Bebbo,

Is it possible that another application has the file open? It doesn't necessarily have to be a VFP application that opens the file. For example, a virus scanner might open the file to check it for viruses when you try to access it from within VFP.

By the way, you say you have the problem when indexing the file. You don't need exclusive use to create an index.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[flintstone42]

There maybe a way to get exclusive access even when someone is in the file by renaming
On some type of networks (Novell hav not tried on MS)

You can get exclusive access by doing the following.
1. rename the file (DBFname.* dbfname.*)
make sure to be do this through a DOS/command line interace.

2. copy the renamed files(,dbf .cdx fpt) back to orginal name

3. QUICKLY open if up in Foxpro exclusively
(If you wait someone may reopen the application and get to the file, it this happens repease step 1 and 2).

4. Make what ever changes you need

Tell your users to exit the application and go back in.

Unfortunately, all changes the users make the file
old(renameD) file will not go into the new one intill
the users reopen the application.

This procedure does work on a Novell network (Have not tried it on a WIN NT/200X) system

Let me know how this works