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

Connecting to SQL Server 2000

P: n/a
JA
Hi,

I am total newbie to SQL Server. My new host tells me I can connect through
AccessXP or 2002. I have Access 2000. Can I not connect with that also?

Thanks, JA
Jul 23 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
JA wrote:
Hi,

I am total newbie to SQL Server. My new host tells me I can connect
through AccessXP or 2002. I have Access 2000. Can I not connect with
that also?

Thanks, JA


Yep, also Access 97, 95, and Access 2.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Jul 23 '05 #2

P: n/a
JA
Rick,

I didn't word that right. Does your answer mean Yes I can, or Yes I can't?

:-)
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:34*************@individual.net...
JA wrote:
Hi,

I am total newbie to SQL Server. My new host tells me I can connect
through AccessXP or 2002. I have Access 2000. Can I not connect with
that also?

Thanks, JA


Yep, also Access 97, 95, and Access 2.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Jul 23 '05 #3

P: n/a
There are some compatibility problems with ADP-s (Access Data
Project-s) in Access 2000 connecting to a SQL Server 2000. There are no
problems, however if you use MDB-s. Access 2000 ADP-s work best with
SQL Server 7. To use the latest features of SQL Server 2000 you need to
connect with Access XP (2002). For more informations, see:
http://support.microsoft.com/kb/269824

Razvan

Jul 23 '05 #4

P: n/a
JA wrote:
Rick,

I didn't word that right. Does your answer mean Yes I can, or Yes I
can't?


If you want to you use an Access Data Project then this is available from Access
2000 and up. If you use an MDB with ODBC than you can use any version you want.
All you need is the correct ODBC driver.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Jul 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.