C
Colin Halliday
I have an Access 2002 project working fine on my office computer. I backed
up the MSDE data and Access project and restored them on my home computer.
When I try to open any of the tables at home from within Access 2002, I
receive the message "ADO error: Cannot resolve collation conflict for column
2 in SELCT statement".
In Enterprise Manager I have reset the collation sequence on all relevant
fields to the database default but I still get the error. The stored
procedures still return all data correctly from the same tables within
Access, I just can't open the tables in design view or datasheet view in
Access.
Any ideas please?
Colin Halliday
up the MSDE data and Access project and restored them on my home computer.
When I try to open any of the tables at home from within Access 2002, I
receive the message "ADO error: Cannot resolve collation conflict for column
2 in SELCT statement".
In Enterprise Manager I have reset the collation sequence on all relevant
fields to the database default but I still get the error. The stored
procedures still return all data correctly from the same tables within
Access, I just can't open the tables in design view or datasheet view in
Access.
Any ideas please?
Colin Halliday