Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
SQL Issue on Windows 8 Maybe |
Wed, Jul 10 2013 7:50 PM | Permanent Link |
Owen | I have a simple SQL that I am running on a windows 8 machine and a windows XP machine. I am running this SQL through the Database System Utility. It will run on XP but not on Windows 8. With W8, I get an 11013 Access denied to table or backup 123280.
select inventoryitems.sku, inventoryitemaccount.lastreceived from inventoryitems, inventoryitemaccount where inventoryitems.itemid = inventoryitemaccount.itemid Also, if I just try to run something even more simple: select sku from inventoryitems I have to click the Live Result Set for it to run on W8, and on XP it does not care. Anybody have any ideas what is going on. |
Wed, Jul 10 2013 8:16 PM | Permanent Link |
Owen | I figured it out on the commute home. It is a run as administrator thing. Not sure what is going on behind the scenes, but if I run as administrator on the W8 it is fine.
Owen wrote: I have a simple SQL that I am running on a windows 8 machine and a windows XP machine. I am running this SQL through the Database System Utility. It will run on XP but not on Windows 8. With W8, I get an 11013 Access denied to table or backup 123280. select inventoryitems.sku, inventoryitemaccount.lastreceived from inventoryitems, inventoryitemaccount where inventoryitems.itemid = inventoryitemaccount.itemid Also, if I just try to run something even more simple: select sku from inventoryitems I have to click the Live Result Set for it to run on W8, and on XP it does not care. Anybody have any ideas what is going on. |
Thu, Jul 11 2013 2:58 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Owen
It looks like a PrivateDir and privileges thing. As administrator you have access to all the directories, as a user no. So if you want to run as user make sure the sessions PrivateDir (ie where temporary files are kept) is accessible to the user. Roy Lambert [Team Elevate] |
Fri, Jul 12 2013 1:31 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Owen,
<< I have a simple SQL that I am running on a windows 8 machine and a windows XP machine. I am running this SQL through the Database System Utility. It will run on XP but not on Windows 8. With W8, I get an 11013 Access denied to table or backup 123280. >> In DBSYS, go to File/Options/Global and make sure that the Private Directory setting is set to a valid temporary files directory for the current user account. That should resolve the problem without requiring Administrator access. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Friday, September 20, 2024 at 05:39 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |