I have an A2k mdb that uses a linked SQL 2k view. In SQL Server, the
underlying table uses datatype 'nvarchar'. When I try to view the data in
Access (SQL server works fine for the view), I get:
ODBC--call failed.
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification (#0)
If I use design view to look at the linked view, I see that the 'nvarchar'
columns are now 'number'. I have deleted and re-linked the tables in
question and still get the error. There is alpha-numeric text in these
fields and am having a difficult time understanding the problem, let alone
using the table.
Thanks,
Eric J Owens