I am trying to test a query in the system utility.  It is a simple inner join on two tables.  However, the system utility returns an ACCESS DENIED
message.  I tested the query in Delphi and it works.  I do not have Delphi or any other program running when I do this test so the tables are not
already open.

Thanks for any help.

-jheske jheske@mindspring.com

<< I am trying to test a query in the system utility.  It is a simple inner
join on two tables.  However, the system utility returns an ACCESS DENIED
message.  I tested the query in Delphi and it works.  I do not have Delphi
or any other program running when I do this test so the tables are not
already open. >>

This usually indicates that one of the tables involved in the query is open
exclusively by another application or the same application.  In some cases,
anti-virus software can cause this.  What is the table name in the error
message ?  If it is a numeric (temporary) table name, then the problem is
with the AV software:

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

--
Tim Young
Elevate Software
www.elevatesoft.com

The table returned is a number.  I have disabled autoprotect on my Norton AV but still can't do the inner join.  I do not have any other apps running
that access my tables.

Point the DBSYS temp file to the same place where you have your app temp
file.

Robert

"jheske" <jheske@mindspring.NOSPAM.com> wrote in message
news:C3ACED5B-7A3A-421F-AC31-F54AC1F71890@news.elevatesoft.com...
> The table returned is a number.  I have disabled autoprotect on my Norton
AV but still can't do the inner join.  I do not have any other apps running
> that access my tables.
>

<< The table returned is a number.  I have disabled autoprotect on my Norton
AV but still can't do the inner join.  I do not have any other apps running
that access my tables.  >>

In the File/Options dialog in the DBSYS utility, make sure that the Private
Directory setting is a valid directory that you have the proper rights to.

--
Tim Young
Elevate Software
www.elevatesoft.com