p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

activex_data_objects thread: ADO error in MS Access SQL Server Project


Message #1 by "Guy Harwood" <guy@h...> on Fri, 25 Jan 2002 16:07:21
Hi,





I use Access XP to develop a Client/Server app with a SQL server backend 

(in the access data project format).  Since installing vs.net and office 

xp service pack 1 i get the following error when opening any table in my 

database from the access project:



"ADO error: Cannot resolve collation conflict for column 2 in SELECT 

statement"



The default Northwind and Pubs databases work fine if connected to my 

project. whats up with mine??????



any help would be greatly appreciated.



Thanks in advance



Guy

  Return to Index