Connecting to SQL Server 2000

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • JA
    #1

    Connecting to SQL Server 2000

    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


    Tags: None
    • Rick Brandt
      #2
      Re: Connecting to SQL Server 2000

      JA wrote:[color=blue]
      > 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[/color]

      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


        Comment

        • JA
          #3
          Re: Connecting to SQL Server 2000

          Rick,

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

          :-)


          "Rick Brandt" <rickbrandt2@ho tmail.com> wrote in message
          news:346h7iF45h j8fU1@individua l.net...[color=blue]
          > JA wrote:[color=green]
          >> 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[/color]
          >
          > 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
          >[/color]


            Comment

            • razvansocol@yahoo.com
              #4
              Re: Connecting to SQL Server 2000

              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:
              Error - Office.com - Microsoft Support
              http://support.microsoft.com/kb/269824


              Razvan

                Comment

                • Rick Brandt
                  #5
                  Re: Connecting to SQL Server 2000

                  JA wrote:[color=blue]
                  > Rick,
                  >
                  > I didn't word that right. Does your answer mean Yes I can, or Yes I
                  > can't?[/color]

                  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


                    Comment

                    Previous template Next
                    Working...