Collation Error

  • Thread starter Thread starter Colin Halliday
  • Start date Start date
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
 
Back
Top