We help IT Professionals succeed at work.

SQL Server 2008 not updateable from ADP

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

Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
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

Author

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.
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.

OR

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.