Posted by Erland Sommarskog on 01/21/08 22:06

JA (jarmour at kc.rr.com) writes:
> Is it possible to connect to Sql Server 2005 using an Access 2000 adp? I
> keep trying, but it doesn't want to accept my id, even though it is right.

You cannot accuse me for knowing too much Access, but I don't see why
it would not work. (Mind you, I don't even know an ADP is.)

It could help if you post the error message you get and the connection
string you are using.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Timestamp Precision
• Prev in forum: Re: SQL query timeout
• Thread view: Re: Access 2000 and SQL Server 2005

[Reply to this message]