Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Read / Write permission error on data folder
Mon, Jul 31 2006 8:57 PMPermanent Link

"Paul"
Hi All,

every now and then we get an error stating Access denied to table.... It has
always been on simple networks. On the machne that has the data on it, all
is fine. On networked machines, one or two data files will be completely
locked. A restart of all machines does not help.

The fix is quite simple. On the server, we copy all files out of the folder
and into a new folder. Point all the machines to the new folder and we are
away. This is only possible on the server. From all other machines, we
cannot even copy the affected files. But it seems to be a corruption with
the folder rather than the files, because once we copy them out of the
original folder, they are fine in the new folder.

It seems to happen when we are updating the data structures, but it is
fairly rare. Out of the hundreds of times I have done this, it has only
happened half a dozen times, and only with version 4. They have all been on
different sites.

Any one had this problem or have any idea how to stop it happening ?

Cheers,
Paul

Tue, Aug 1 2006 2:05 AMPermanent Link

"Roj Ash"
The problem occurs because when you change structures, DBISAM creates
temporary tables with the new structures in the defined private folder, then
copies them to the data folder.
This means that they inherit their permissions from the local folder, to
which other users don't have rights.
The simplest way to overcome it is to set session.privatedir to be the same
as the data folder immediately before restructuring. That way the newly
crated tables inherit the same rights as the originals.
Tue, Aug 1 2006 8:47 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roj,

<< The problem occurs because when you change structures, DBISAM creates
temporary tables with the new structures in the defined private folder, then
copies them to the data folder. This means that they inherit their
permissions from the local folder, to which other users don't have rights.
The simplest way to overcome it is to set session.privatedir to be the same
as the data folder immediately before restructuring. That way the newly
crated tables inherit the same rights as the originals. >>

Exactly correct. Smiley

And, further to this issue, there's a property in the TDBISAMEngine
component that can fix this:

http://www.elevatesoft.com/dbisam4d5_tdbisamengine_createtemptablesindatabase.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Aug 2 2006 9:40 AMPermanent Link

"Paul"
Hi Roj and Tim,

thanks. That's great, thanks for the help.

Cheers,
Paul

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:0C4567A3-E6A0-40FB-8E6D-246FB4537705@news.elevatesoft.com...
> Roj,
>
> << The problem occurs because when you change structures, DBISAM creates
> temporary tables with the new structures in the defined private folder,
> then copies them to the data folder. This means that they inherit their
> permissions from the local folder, to which other users don't have rights.
> The simplest way to overcome it is to set session.privatedir to be the
> same as the data folder immediately before restructuring. That way the
> newly crated tables inherit the same rights as the originals. >>
>
> Exactly correct. Smiley
>
> And, further to this issue, there's a property in the TDBISAMEngine
> component that can fix this:
>
> http://www.elevatesoft.com/dbisam4d5_tdbisamengine_createtemptablesindatabase.htm
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Image