[AccessD] ADPs - accessing SQL Views

O'Connor, Patricia (OTDA) Patricia.O'Connor at dfa.state.ny.us
Thu Sep 23 09:47:46 CDT 2004


Roz, 

What is the error you are getting?

Check the permissions for the TABLES underlying the View as well as the
view.  We ran into something similar because the Code tables that made
up the view did not have the same permissions as the main table.

HTH
Patti

******************************************************************
*Patricia O'Connor
*Associate Computer Programmer Analyst
*OTDA - BDMA
*(W) mailto:Patricia.O'Connor at dfa.state.ny.us
*(w) mailto:aa1160 at dfa.state.ny.us
******************************************************************
 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Roz Clarke
> Sent: Thursday, September 23, 2004 04:33 AM
> To: 'Access Developers discussion and problem solving'; 
> dba-sqlserver at databaseadvisors.com
> Subject: [AccessD] ADPs - accessing SQL Views
> 
> Dear all
> 
> I have had this problem raised by one of the developers on my 
> team. Can anyone assist?
> 
> "Using ADO objects via OLE DB, I can access data in my SQL 
> Server database in the form of tables and stored procs with 
> no problem.  When I try and retrieve records from a SQL 
> Server view, I get an OLE DB error.  I have tried using all 
> the different ways, command objects, recordsets etc."
> 
> TIA
> 
> Roz
> 
> 
> 



More information about the AccessD mailing list