I have an Access 2007 front end and a SQL Server 2008 backend. When I try to view tblHistory within Access it shows #Deleted in all the fields. I tried deleting the link and recreating it but it's the same. I found an EE comment that suggested changing data types so I changed 4 fields from nvarchar to varchar. Then I deleted the link again and relinked it. Still not working. I think it may be my ChgTime field. In Access the datatype was Date/Time (before conversion). SQL Server shows it as just time. Now when I look at the data types for the newly linked table in Access design view it shows time as a text field. Do I need to change the data type to something else in SQL? If the data type is ok then any ideas on why the #deleted message?
I'm attaching a jpg of what I currently have in SQL Server as well as sample data.