Access 2007 ColumnHistory Memo Field to SQL Server 2008

[Abdulkawi]

Hi,

I was using a Append Only Memo Field in Access 2007 to show Column History for "Comments".

However, I have now converted the back-end to SQL Server 2008 whilst the Front-end is still Access 2007. Since I have done this, the field that shows the column history for "Comments" does not work anymore, it shows "#Error"

This is the control source used in the form:

=ColumnHistory([RecordSource],"Comments","[Asset_No]=""" & Nz([Asset_No],0) & """")

It was working before the conversion.

The column "Comments" is set to nvarchar(MAX) in SQL Server.

I'm not really sure what needs to be done, I would appreciate all the help.

This has happened to all the columnhistory fields.

Thanks