By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,906 Members | 1,700 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,906 IT Pros & Developers. It's quick & easy.

Access 2000 and SQL Server 2005

P: n/a
JA
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.
Jan 21 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jan 21 '08 #2

P: n/a
Hi Erland,

I don't have the original post in my Windows Mail so I am replying to the
group by replying to your post. ADP stands for Access Data (or Database -
It's been a while)
Project. With Access 2000 you had the option to continue use .mdb files
that used primarily JET engine and you could use linked tables to connect
to SQL 2000. Using .adp you were directly connected to the SQL databases
and you could not use JET engine.
JA, it seems you can not use Access 2000 with SQL 2005

http://groups.google.com/groups/sear...0+adp+sql+2005

http://groups.google.com/group/micro...4b34707134f81f
"Erland Sommarskog" <es****@sommarskog.sewrote in message
news:Xn**********************@127.0.0.1...
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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jan 22 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.