Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2017
    Posts
    1,673

    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
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    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, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Replies: 3
    Last Post: 01-23-2018, 03:21 AM
  2. Automate Linking to SQL Server.
    By RayMilhon in forum Access
    Replies: 2
    Last Post: 12-28-2017, 06: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, 08:57 AM
  4. Linking to SQL Server from Access
    By JoeM in forum SQL Server
    Replies: 15
    Last Post: 05-11-2015, 09:53 AM
  5. Replies: 1
    Last Post: 04-24-2014, 05: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
  •  
Other Forums: Microsoft Office Forums