Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
Read / Write permission error on data folder |
Mon, Jul 31 2006 8:57 PM | Permanent 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 AM | Permanent 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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. 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 AM | Permanent 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. > > 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 > > |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |