We help IT Professionals succeed at work.

SQL Server 2008 not updateable from ADP

Medium Priority
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?
Watch Question

Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Do the new tables have Primary Keys? This is one of the more common reasons ...

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts


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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.