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:
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.