1 Replies - 8579 Views - Last Post: 28 December 2012 - 10:00 AM Rate Topic: -----

#1 VIPER5646  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 90
  • Joined: 01-March 09

Access View Does Not Show In VS2010 Data Connections

Posted 27 December 2012 - 11:32 PM

Hi all
I have a Data connection in VS 2010 To an Access DB all Views are shown in the Data Connection accept one.
This View consists of the following 'GETLIST' Function coded in Access.
The Query works in Access Accept it is not displayed in VS.
Thanks in advance.
SELECT T.ID, GETLIST("SELECT T1.Hold From status_notes_tbl AS T1
 Where T1.CustomerID =" & T.[id]," ",",") AS Notes
FROM Customer_Tbl AS T;


Is This A Good Question/Topic? 0
  • +

Replies To: Access View Does Not Show In VS2010 Data Connections

#2 VIPER5646  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 90
  • Joined: 01-March 09

Re: Access View Does Not Show In VS2010 Data Connections

Posted 28 December 2012 - 10:00 AM

View PostVIPER5646, on 27 December 2012 - 11:32 PM, said:

Hi all
I have a Data connection in VS 2010 To an Access DB all Views are shown in the Data Connection accept one.
This View consists of the following 'GETLIST' Function coded in Access.
The Query works in Access Accept it is not displayed in VS.
Thanks in advance.
SELECT T.ID, GETLIST("SELECT T1.Hold From status_notes_tbl AS T1
 Where T1.CustomerID =" & T.[id]," ",",") AS Notes
FROM Customer_Tbl AS T;


Found it.
It is in a Function folder in the Data Connection.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1