[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 731
  • Last Modified:

SQL Server 2008 not updateable from ADP

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?
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Do the new tables have Primary Keys? This is one of the more common reasons ...
411archAuthor Commented:
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now