I connect to SQL server 2008 with Access 2010 through ODBC connection. I can see the server, connect to the database I want, and even import the table. After importing, all records in the gtable are imported correctly.
But when I link the table, and then open it, all fields in all records show as #DELETED. I can even add new records through the linked table, they show up when I browse the table through the SQ server Management studio. But as soon as they're
added, Access shows them as #Deleted. When I use the Refresh all data button, the first record (dependent on the sort order) is shown correctly, but all others remain #DELETED. I had this problem already with Access 2007 on the SQL 2008 server,
but hoped it would be solved after upgrading to Access 2010, so now I suppose it's a problem on the SQL server side.
Hope someone has an idea....
View Complete Post