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.  

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.  

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]

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