I have a SQL server database with several tables that have GUIDs for primary keys that are automatically generated by SQL newID default value. (I don't want to get into a debate on the pro's and cons of that, that is just how it has to be for now). I am trying to create a basic front end to that in Access (2010 - but the issue seems to occur in 2007 as wel). I link to the SQL Server db using ODBC.
When I add a new record into the table using Access ODBC linked table I get an error message "No Current Record" and the whole table (all rows) displays #name?. Refreshing or requerying does not fix the problem, you have to close the table and open it again to get it working. The record that is added is successfully saved and usable in the table.
Any suggestions on how i might fix this.