Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 7 of 7 total

.dat and .idx files losing system users permissions

Thu, Dec 22 2011 4:54 AM	Permanent Link
Luis Conception Gonzalez	Hi! I don't know if this is related to DBISAM, Windows or maybe any antivirus software... Some customers are getting '#11010 Table or backup file companies does not exist' error, when trying to connect to a dbisam database in a shared folder. The file DOES exist, but I can't see it from another computer through the network, so... After some investigation, I noticed that 'companies.dat' and 'companies.idx' files had lose the 'Everyone - All' permission. After adding 'Everyone - All' permissions again only to those files, it works fine again! All other files were already well-shared! Is there any DBISAM related query, alter table, method or something that can make this happen? Maybe a wrong alter table query, wrong table open-close code, etc...? Thanks! Luis C.
Thu, Dec 22 2011 5:04 AM	Permanent Link
Chris Holland SEC Solutions Ltd. Team Elevate	Hi Luis, I have no idea what causes this be I have seen this quite a few time on our customers machines. When I have looked at the the servers they all appear to be running a network version of AVG anti virus so I am begining to suspect this. I am still trying to track down anything that the machines has in common so it would be interesting to know if your customer was also running this. Chris Holland [Team Elevate] On 22/12/2011 09:54, Luis Conception Gonzalez wrote: > Hi! > > I don't know if this is related to DBISAM, Windows or maybe any > antivirus software... > Some customers are getting '#11010 Table or backup file companies does > not exist' error, when trying to connect to a dbisam database in a > shared folder. > > The file DOES exist, but I can't see it from another computer through > the network, so... > After some investigation, I noticed that 'companies.dat' and > 'companies.idx' files had lose the 'Everyone - All' permission. > > After adding 'Everyone - All' permissions again only to those files, > it works fine again! All other files were already well-shared! > > Is there any DBISAM related query, alter table, method or something > that can make this happen? Maybe a wrong alter table query, wrong > table open-close code, etc...? > > Thanks! > Luis C.
Thu, Dec 22 2011 6:35 AM	Permanent Link
John Hay	Hi Luis, It might be the private directory setting used when altering tables. See http://www.elevatesoft.com/bulletin_9.htm for more info. John
Thu, Dec 22 2011 6:59 AM	Permanent Link
Chris Holland SEC Solutions Ltd. Team Elevate	<html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#FFFFFF" text="#000000"> Hi John,<br> <br> Thanks for that, that could well be the problem. I am using the ODBC driver though and I don't think that the    <b>CreateTempTablesInDatabase</b> option is part of the connection string, unless Tim can tell me otherwise. (or else add it as an option)<br> <br> Chris Holland<br> <div class="moz-signature">[Team Elevate] </div> <br> On 22/12/2011 11:35, John Hay wrote: <blockquote cite="mid:7085A63B-AF88-4F91-8A4C-35DF5CB55A79@news.elevatesoft.com" type="cite"> <pre wrap="">Hi Luis, It might be the private directory setting used when altering tables. See <a class="moz-txt-link-freetext" href="http://www.elevatesoft.com/bulletin_9.htm" name="http://www.elevatesoft.com/bulletin_9.htm">http://www.elevatesoft.com/bulletin_9.htm">http://www.elevatesoft.com/bulletin_9.htm">http://www.elevatesoft.com/bulletin_9.htm</a> for more info. John </pre> </blockquote> </body> </html>
Thu, Dec 22 2011 7:53 AM	Permanent Link
Luis Conception Gonzalez	Hi! I'm getting this problem in Windows 7 64 bits. "John Hay" escribió en el mensaje de noticias:7085A63B-AF88-4F91-8A4C-35DF5CB55A79@news.elevatesoft.com... Hi Luis, It might be the private directory setting used when altering tables. See http://www.elevatesoft.com/bulletin_9.htm for more info. John
Thu, Dec 22 2011 8:37 AM	Permanent Link
Raul Team Elevate	It still applies - the bulletin was written back in 2002 when XP was brand new. Raul On 12/22/2011 7:53 AM, Luis Conception Gonzalez wrote: > Hi! > > I'm getting this problem in Windows 7 64 bits.
Thu, Dec 22 2011 1:08 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Chris, << Thanks for that, that could well be the problem. I am using the ODBC driver though and I don't think that the CreateTempTablesInDatabase option is part of the connection string, unless Tim can tell me otherwise. (or else add it as an option) >> Yes, you can use the ODBC Driver Configuration Utility to enable that option. That utility is installed with the DBISAM 4.x ODBC Driver installation, and configures all engine-wide settings for the driver in the registry. -- Tim Young Elevate Software www.elevatesoft.com