Results 1 to 2 of 2
  1. #1
    tzvi is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    5

    Updating SQL Server Views via MS Access front-end?

    Hello!

    I have a "SQL View" link in access



    if i try to change data on it... I get a messageas attached... but i know that no one is editing the file now... and i can also change data direct from "sql server manager" just not from access

    If i need to redo the quiry in access this will be a pain for me...

    what can i do so i can edit this view from access.

    Thank you!
    Attached Thumbnails Attached Thumbnails Capture.PNG  

  2. #2
    tzvi is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    5
    any ideas??

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

Similar Threads

  1. Replies: 4
    Last Post: 11-29-2012, 12:45 AM
  2. Using Access as Front End for SQL Server
    By workinstiff in forum Access
    Replies: 4
    Last Post: 07-18-2012, 12:16 PM
  3. After front end shut down - server shows still open!
    By skyview chick in forum Access
    Replies: 10
    Last Post: 07-10-2012, 04:14 PM
  4. Replies: 6
    Last Post: 05-14-2012, 08:32 PM
  5. Replies: 3
    Last Post: 01-15-2011, 11:38 AM

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