Results 1 to 2 of 2

Access2016: Linking SQL Server View

  1. #1
    Join Date
    Apr 2017
    Posts
    579

    Access2016: Linking SQL Server View

    I need to use SQL Server database View as Source for Access form (read only). I read, that unindexed Views Access can only read, so I created a read-only datasource - but it displays only tables (like the read-write one too)! How can I make Views available too?

    The query syntax is too complex to port it directly into Access, and I'm afraid it will be too slow when ported using interim saved queries.

    I have several SQL databases linked to Access project, and I searched the view in wrong DB

  2. #2
    ridders52's Avatar
    ridders52 is offline Long time standing
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    1,663
    How are you linking to SQL Server?
    I can link to SQL server views with no problems, both read only and where there is a PK field, editable.
    EDIT: I see your thread is marked solved so no longer an issue?
    Colin (Mendip Data Systems), Website, email

    If this has helped, please click the star button and leave a comment

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 01-23-2018, 02:21 AM
  2. Automate Linking to SQL Server.
    By RayMilhon in forum Access
    Replies: 2
    Last Post: 12-28-2017, 05:07 PM
  3. Linking tables to mdb database on extern server
    By mayja in forum Import/Export Data
    Replies: 1
    Last Post: 11-23-2016, 07:57 AM
  4. Linking to SQL Server from Access
    By JoeM in forum SQL Server
    Replies: 15
    Last Post: 05-11-2015, 08:53 AM
  5. Replies: 1
    Last Post: 04-24-2014, 04:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums