Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 5 of 5 total |
System Utility won't allow inner join |
Thu, Jan 12 2006 9:38 AM | Permanent Link |
jheske | 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 |
Thu, Jan 12 2006 11:47 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.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 |
Thu, Jan 12 2006 1:49 PM | Permanent Link |
jheske | 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. |
Thu, Jan 12 2006 4:23 PM | Permanent Link |
"Robert" | 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. > |
Fri, Jan 13 2006 4:02 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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. >> 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 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |