Results 1 to 3 of 3
  1. #1
    Robert2150 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    102

    Can not change data in a SQL Database Linked to Access Front End

    I have had an Access Front End linked to SQL Server Database Tables that has been working fine.
    All of the sudden I cannot alter data in those tables.
    Any suggestions?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Are you in charge of the SQL Server Database Tables?
    If not, it may be that the SQL Server DBA or management has modified the characteristics of those tables or has put some constraint on your account.
    We really need more info on your environment and the players involved.
    Good luck.

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Also, go into design mode in Access and select a SQL table, see if you can directly add a record or change a field. If you can that SQL probably ok. If not, maybe try the Link Manager and relink all the SQL tables.

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

Similar Threads

  1. Replies: 1
    Last Post: 09-04-2018, 02:24 PM
  2. Replies: 2
    Last Post: 07-14-2017, 09:38 AM
  3. Replies: 1
    Last Post: 06-09-2016, 04:03 PM
  4. Replies: 1
    Last Post: 10-08-2015, 09:15 AM
  5. Replies: 1
    Last Post: 03-26-2014, 09:28 AM

Tags for this Thread

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