SQL Server 2008 not updateable from ADP

Posted on 2009-02-15
Last Modified: 2013-12-05
Using an Access ADP, I am using the Data Link Properties to connect to SQL Server 2008. I am using Windows NT itegrated security to log on to the server.  The user logon is a role member of db_owner.
Previously, using SQl 2005 there were no issues. Now I am using SQl 2008.

In the tables object in Access, all tables from the Server are seen and updateable, except for newly created tables. Recently, I created a new table in SQl Server Management Studio. The table is updateable in SQl Server, but not Access 2003. In Access, I get the message: This recordset is not updateable. In trying another way to update the Table, I have opened the troublesome Table in Visual Studio 2008 with no problems updating.

Is this a:
1. Problem with Access 2003 connecting to SQL Server 2008 or
2. Permission issue?
3. Is there a setting on new tables that I am overlooking?
Question by:411arch
    LVL 84

    Accepted Solution

    Do the new tables have Primary Keys? This is one of the more common reasons ...

    Author Closing Comment

    That was it. I forgot the key on the table I made in SQL Server. Also, there were a half dozen tables that I created in an access mdb, that I imported into the SQL db via the access adp. The tables had primary keys, but the primary keys did not import.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now