locked
Access 2000 ADP cannot be connected to SQL 2008 R2 Server RRS feed

  • Question

  • I try to use Access 2000 ADPs with SQL 2008 R2 Server. However the Data Link Windows in Access 2000 ADP shows only SQL 2000 and SQL 2005 Servers. Therefore I cannot select SQL 2008 R2 Server to link with Access 2000 ADP.  Is there any way to use Access 2000 ADPs with SQL 2008 R2 Server? With SQL 2005 server, Access 2000 ADPs work alright. I do not want to convert Access 2000 ADPs to other verson of Access. Thank you very much your consideration of this matter. Hope to hear from you soon.

    Friday, July 9, 2010 9:40 AM

Answers

  • It's likely that the SQL Server Browser Service is off.
    1. Go to the computer on which SQL Server is installed.
    2. Right-click [My Computer] and select Manage from the context menu.
    3. Expand [Services and Applications].
    4. Click [Services].
    5. Find [SQL Server Browser].
      (a)
      This service should be listed as 'Started'. If it's not, double-click it to display the Properties dialog.
      (b) Change the [Startup Type] to 'Automatic.
      (c) Click [Start].
      (d) Click [OK].
    You should then be able to see the server in the Datalink dialog.
     
     

    I try to use Access 2000 ADPs with SQL 2008 R2 Server. However the Data Link Windows in Access 2000 ADP shows only SQL 2000 and SQL 2005 Servers. Therefore I cannot select SQL 2008 R2 Server to link with Access 2000 ADP.  Is there any way to use Access 2000 ADPs with SQL 2008 R2 Server? With SQL 2005 server, Access 2000 ADPs work alright. I do not want to convert Access 2000 ADPs to other verson of Access. Thank you very much your consideration of this matter. Hope to hear from you soon.


    Regards, Graham R Seach Microsoft Access MVP Sydney, Australia
    • Marked as answer by Jinho Chung Saturday, July 10, 2010 6:22 AM
    Friday, July 9, 2010 10:35 AM

All replies

  • It's likely that the SQL Server Browser Service is off.
    1. Go to the computer on which SQL Server is installed.
    2. Right-click [My Computer] and select Manage from the context menu.
    3. Expand [Services and Applications].
    4. Click [Services].
    5. Find [SQL Server Browser].
      (a)
      This service should be listed as 'Started'. If it's not, double-click it to display the Properties dialog.
      (b) Change the [Startup Type] to 'Automatic.
      (c) Click [Start].
      (d) Click [OK].
    You should then be able to see the server in the Datalink dialog.
     
     

    I try to use Access 2000 ADPs with SQL 2008 R2 Server. However the Data Link Windows in Access 2000 ADP shows only SQL 2000 and SQL 2005 Servers. Therefore I cannot select SQL 2008 R2 Server to link with Access 2000 ADP.  Is there any way to use Access 2000 ADPs with SQL 2008 R2 Server? With SQL 2005 server, Access 2000 ADPs work alright. I do not want to convert Access 2000 ADPs to other verson of Access. Thank you very much your consideration of this matter. Hope to hear from you soon.


    Regards, Graham R Seach Microsoft Access MVP Sydney, Australia
    • Marked as answer by Jinho Chung Saturday, July 10, 2010 6:22 AM
    Friday, July 9, 2010 10:35 AM
  • Hi Graham,

    Graham R Seach wrote:

    It's likely that the SQL Server Browser Service is off.

    Isn't the Browser Service only necessary when the server runs as named
    instance?


    Peter Doering [MVP Access]

    Friday, July 9, 2010 1:20 PM
  • Hi Peter,
     
    Or if the default instance isn't running over port 1433. To be honest, I haven't looked into the specifics; I just recall having visibility issues that were solved by starting the service.
     
     

    Hi Graham,

    Graham R Seach wrote:

    It's likely that the SQL Server Browser Service is off.

    Isn't the Browser Service only necessary when the server runs as named
    instance?


    Peter Doering [MVP Access]


    Regards, Graham R Seach Microsoft Access MVP Sydney, Australia
    Friday, July 9, 2010 1:34 PM
  • Thank you so much for your reply.

    Please accept my deep appreciation of your kind assistance.

    With best regards.

     

    Saturday, July 10, 2010 6:25 AM
  • So did you resolve your problem?
     

    Thank you so much for your reply.

    Please accept my deep appreciation of your kind assistance.

    With best regards.

     


    Regards, Graham R Seach Microsoft Access MVP Sydney, Australia
    Saturday, July 10, 2010 6:57 AM
  • just because the combobox doesn't _LIST_ the server, that doesn't mean that you can't use it.

    Just type in the server name or IP address you lazy ____


    aaron_kempf
    Saturday, September 11, 2010 4:34 PM
  • Access 2000 is the buggiest version of Access in the whole wide world.

    You should buy a current version of Office, buddy.

    If you're not worth $300 to your employer then you should find a better job / skillset.

    Saturday, June 4, 2011 3:04 PM