Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 16 total
Thread Losing my mind with these DBISAM 11013 Access Denies to Table Errors
Fri, Oct 14 2011 6:03 PMPermanent Link

J.R.

I am regularly inundated with people suffering from this error.

Reading the forum i see tons of posts about it, suggesting the most common cause is that some antivirus program or another is temporarily blocking access to a temp file created by dbisam and that is causing the error.

This indeed seems to be the case for most of the users that i have had long back and forth discussions with trying to get my program working again on their system..

I have experimented with different PrivateDir settings, which seem to help some people and not others, and of course i try to walk them through the process of setting up exclusions for their antivirus engines on specific folders.  Needless to say this is painful for all involved and very hard to explain to new users.

----

I see this problem seems to be very common for users of dbisam software for several years now..

Is there *REALLY* nothing that elevate can do about this problem to fix it?  Is there really no way to make the database not throw up an error if the antivirus program locks the temp file for a few milliseconds? I don't understand why no other program has this problem with antivirus software locking their files during scanning?

I don't mean to sound obnoxious but isn't there something you can do short of throwing an unrecoverable error -- like waiting until the antivirus program finishes scanning the file? Or reusing creating temp files ahead of time and reusing them?

Does elevatedb suffer from this same problem?

Sorry if i sound harsh, i'm just really frustrated by how much this problem seems to be known for a long time now with no good solution other than try to walk end users through disabling their antivirus software.
Fri, Oct 14 2011 6:05 PMPermanent Link

J.R.

To clarify, specific error is "DBISAM Engine Error #11013 Access denied to table or backup"
Sat, Oct 15 2011 3:57 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Jesse


>Is there *REALLY* nothing that elevate can do about this problem to fix it? Is there really no way to make the database not throw up an error if the antivirus program locks the temp file for a few milliseconds?

From previous posts from Tim I think the answer is no. Part of the problem is the extensions that DBISAM uses (dat is very common) and you could try changing those to see if it will help. Part is due to the fact that different AV systems have different approaches. The worst don't just lock the files they delete them! Some will apply a brief lock others longer ones.

>I don't understand why no other program has this problem with antivirus software locking their files during scanning?

Why do you think this? I've seen quite a few posts on other forums (including MS) bemoaning this behaviour for databases.

Roy Lambert
Sat, Oct 15 2011 8:36 AMPermanent Link

Rita Tipton



"Jesse Reichler" wrote in message
news:D90D9C51-BA4F-4AD3-A322-6FE2C3BFBA22@news.elevatesoft.com...

To clarify, specific error is "DBISAM Engine Error #11013 Access denied to
table or backup"

########################################################################################

I found that making sure all the tables Active property got set "False"
during
app firing up stopped #11013 errors.
Then when the app has started set them active = true
I have EDB and not used it much but never came across it, but as I now dont
have any tables active during startup I will never know.

Rita
Fri, Oct 21 2011 2:07 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jesse,

What version of DBISAM are you using ?  Later versions of DBISAM include
some code to help alleviate this issue.  More specifically, DBISAM won't
close the file handle after creating a temporary file, and instead keeps it
open, thus denying the AV software an opportunity to open the file and cause
the "access denied" error when DBISAM attempted to open the file after
creating it.  There is still the possibility for other errors, though, if
the realtime AV scanning is left in place on the temporary files directory.

<< I don't understand why no other program has this problem with antivirus
software locking their files during scanning? >>

That's not correct - one that I can think of right off the top of my head is
MS Exchange Server, which has warnings all over the place about making sure
to exclude its directories from AV scanning.

--
Tim Young
Elevate Software
www.elevatesoft.com
Wed, Jan 18 2012 6:35 PMPermanent Link

samjones

>>  Later versions of DBISAM include some code to help alleviate this issue.

Tim,

Specifically, what version/build of DBISAM v4 is needed for that alleviation?

Thanks!
Fri, Jan 20 2012 1:56 PMPermanent Link

samjones4

Tim,

Specifically, what version/build of DBISAM v4 is needed for that alleviation?

Thanks!
Mon, Jan 23 2012 10:56 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com


<< Specifically, what version/build of DBISAM v4 is needed for that
alleviation? >>

The version/build that you want is 4.28 B2 or higher.

--
Tim Young
Elevate Software
www.elevatesoft.com
Mon, Jan 30 2012 6:09 PMPermanent Link

samjones

"Tim Young [Elevate Software]" wrote: The version/build that you want is 4.28 B2 or higher.

Ack, so if we are using 4.29 Build 2, and still see this issue a lot , then what?


Thank you!
Tue, Feb 7 2012 5:14 AMPermanent Link

Philip Luke

samjones wrote:

"Tim Young [Elevate Software]" wrote: The version/build that you want is 4.28 B2 or higher.

Ack, so if we are using 4.29 Build 2, and still see this issue a lot , then what?


Thank you!

We're also seeing this when there is a lot of database activity on 4.30 Build 5. This is on a laptop where there is no Antivirus software running.
Page 1 of 2Next Page
Jump to Page:  1 2
Image