Hi Guy

I got the Exact same problem with my database - and i've tryed to 
reinstall my office XP developer, but same problem.

Maybe Microsoft only try new developments systems on there on databases.

Best regards
Jan Borup Coyle
Denmark

> 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

We had a similar problem.  I believe that the problem is with vs.net.  We
were able to download a hotfix from MS that solved the problem.

Rosalind Philips
Tech Services
rosalind115@a...

----- Original Message -----
From: "Jan Borup Coyle" <jb@x...>
To: "ActiveX_Data_Objects" <activex_data_objects@p...>
Sent: Friday, June 14, 2002 11:05 AM
Subject: [activex_data_objects] Re: ADO error in MS Access SQL Server
Project


> Hi Guy
>
> I got the Exact same problem with my database - and i've tryed to
> reinstall my office XP developer, but same problem.
>
> Maybe Microsoft only try new developments systems on there on databases.
>
> Best regards
> Jan Borup Coyle
> Denmark
>
> > 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
>