D7 Pro DBISAM V4 latest build

A couple of clients are getting the following error when running querys that
always seemed to work in the past... Any ideas o nwhat I should be looking
for?

"access denied to table or backup file query" Often the results will still
be produced after acknowledging the errors.

Many thanks, Sean

Sean McDermott wrote:
> A couple of clients are getting the following error when running querys that
> always seemed to work in the past... Any ideas o nwhat I should be looking
> for?
>
> "access denied to table or backup file query" Often the results will still
> be produced after acknowledging the errors.

Perhaps you have left TDataSets open and you are trying to drop tables
to which they refer.


   Oliver

Sean,

<< A couple of clients are getting the following error when running querys
that always seemed to work in the past... Any ideas o nwhat I should be
looking for? >>

It's most likely the anti-virus software, especially with query result sets:

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

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks, I am not dropping any tables so that is not the issue. However, the
omnipresent Norton AV is a likely culprit. Would setting the scan functions
in Norton to exclude dot dat extensions also solve the issue?

Thanks, Sean

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:9D51929A-3C58-4F78-A6C4-ACE5E1F67F57@news.elevatesoft.com...
> Sean,
>
> << A couple of clients are getting the following error when running querys
> that always seemed to work in the past... Any ideas o nwhat I should be
> looking for? >>
>
> It's most likely the anti-virus software, especially with query result
> sets:
>
> http://www.elevatesoft.com/bulletin_14.htm
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Sean,

<< Thanks, I am not dropping any tables so that is not the issue. However,
the omnipresent Norton AV is a likely culprit. Would setting the scan
functions in Norton to exclude dot dat extensions also solve the issue? >>

It should, but they change the behavior of the AV software so often that it
might be more advisable to plan on changing the temporary table extension
(per the bulletin) in any future release of your software.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks Tim, I made the changes as per your bulletin and re-released and all
appears well now. Thanks for the great support, Sean

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:E36FBF9A-A837-4FA6-B2EC-3E952D377483@news.elevatesoft.com...
> Sean,
>
> << Thanks, I am not dropping any tables so that is not the issue. However,
> the omnipresent Norton AV is a likely culprit. Would setting the scan
> functions in Norton to exclude dot dat extensions also solve the issue? >>
>
> It should, but they change the behavior of the AV software so often that
> it might be more advisable to plan on changing the temporary table
> extension (per the bulletin) in any future release of your software.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

> It should, but they change the behavior of the AV software so often that it
> might be more advisable to plan on changing the temporary table extension
> (per the bulletin) in any future release of your software.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com

Changing temp table extension does not work if the app cannot get exclusive
rights to the database. This means that I cannot have several instances of the
app on the desktop.

Any way to fix this?

Latest build, Delphi 5.

Sanford,

<< Changing temp table extension does not work if the app cannot get
exclusive rights to the database. This means that I cannot have several
instances of the app on the desktop. >>

Could you please elaborate ?  I'm not exactly sure what you're talking
about - changing the temporary table extension is a code issue, not a
database rights issue.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

> Sanford,
>
> << Changing temp table extension does not work if the app cannot get
> exclusive rights to the database. This means that I cannot have several
> instances of the app on the desktop. >>
>
> Could you please elaborate ?  I'm not exactly sure what you're talking
> about - changing the temporary table extension is a code issue, not a
> database rights issue.
>

Now it seems to work!

Actually, correct me if I am wrong, but I should be able to change by
dropping an engine component on the main form, and changing the property
(setting active = false).

Sanford,

<< Actually, correct me if I am wrong, but I should be able to change by
dropping an engine component on the main form, and changing the property
(setting active = false). >>

Yes, that will permit you to change any TDBISAMEngine property at
design-time.

--
Tim Young
Elevate Software
www.elevatesoft.com