Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    75

    Unanswered: Selecting from a View on SQL Server from VBA

    Hello,

    How can I select data from a view that exists on the SQL Server from Access VBA?

    I create a querydef (which works fine) and then open a rs with the qdf.openrecordset statement. That statement results in err 3078 (Jet cannot find the input table or query "viewname")

    Any ideas?

    Thank you!

  2. #2
    Join Date
    May 2010
    Posts
    601
    Quote Originally Posted by vasilyok View Post
    Hello,

    How can I select data from a view that exists on the SQL Server from Access VBA?

    I create a querydef (which works fine) and then open a rs with the qdf.openrecordset statement. That statement results in err 3078 (Jet cannot find the input table or query "viewname")

    Any ideas?

    Thank you!
    Have you created a linked table to the view?

    It would really help is you would post your VBA code.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •