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?