Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Foxpro

Status
Not open for further replies.

KLinC

Technical User
Jan 8, 2001
5
AU
I had reason to SET EXCLUSIVE OFF to test a program.
I now have trouble because I get a repeated error message that EXCLUSIVE USE of a database is required.
I have tried SET EXCLUSIVE ON but this does not solve the problem.
Any suggestions please?
 
SET EXCLUSIVE ON does not work retroactively. IOW, if you have DBF1 already open in shared mode, issuing SET EXCLUSIVE ON does not affect it; you would have to close the file and reopen it.

An alternative to using SET EXCLUSIVE is to explicitly state it when you open the DBF, as in:

USE MYTABLE EXCLUSIVE
or
USE MYTABLE SHARE

Robert Bradley
 
Thank you Robert

It has taken me some time to find my way in this far.
I have now found my way in and thankfully received your advice which I will certainly try.
I had programmed around my problem and given up what I was trying to do.
I did not mention my purpose which was to reduce .IDX files by reindexing at start up so that back up times were reduced.
I think that this would have been OK except that we have two computers running off the same system hence the share problem.

Again - thank you from an old tryer in Australia
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top