I tried this code in Access 2000, using a SQL Server 2008 Express backend:
the record gets inserted fine into tblSCInbox, but I get this error after ".Bookmark = .LastModified":
and DBEngine.Errors(0).Description is:
There are two datetime2 columns that have default of getdate(), and they got inserted fine, I'm not sure what's wrong.
I get the feeling there's a bit of code missing...
What's the definition of tblSCInbox? (ie what columns, and data types)?
Can you trace the SQL being passed between Access & SQL Server? What does that show? edit this is done using SQL Server Profiler <http://msdn.microsoft.com/en-us/library/ms181091.aspx>, <http://msdn.microsoft.com/en-us/library/ms187929.aspx>. If you search for SQL Server Profiler (<http://www.google.co.uk/search?q=sql+server+profiler>), you'll find all sorts of useful resources - videos, blog posts etc - that talk you through the process.
I also suspect that Access has some nasty date/time restrictions, but it's been so long since I last programmed against it, I really can't remember.