this time, I have a question, for a change... A client of mine has a SharePoint site with a few tables and an Access database, where the SharePoint tables are defined as Aliases. He developed a SQL query that loads one of the "local" Access Tables, joined with a few SharePoint tables.
The loads just fine from his local machine, but it fails when it's ran as a QVS task.
Our first stop was to compare security rights between the local machine and the server's account that runs the services. We could validate that the service account has full access to the SharePoint site and to the tables in question. It looks to me like all the bases are covered, and yet the SQL statement fails with an error "Cannot find Object ...".
