[AccessD] ADPs - accessing SQL Views

I would immediately check the permissions the developer has on that View.

-Chris Mackin


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Roz Clarke
Sent: Thursday, September 23, 2004 2: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