Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    6

    Unanswered: Access 2000 lionked to SQL Server

    Does anyone know why I can't seem to get Access 2000 to act as a clinet to my SQL Server database which lives on the Internet? I'm able to get Access 2000 to talk to a database that's on the same LAN and Access XP to talk to a database on the net. Is this a limitation of Access 2000? Unfortunately my client uses 2000 and I can't require them to upgrade as part of my solution.

    Thanks. -- Aaron

  2. #2
    Join Date
    Sep 2003
    Posts
    6

    Re: Access 2000 lionked to SQL Server

    Originally posted by Aaron Edwards
    Does anyone know why I can't seem to get Access 2000 to act as a clinet to my SQL Server database which lives on the Internet? I'm able to get Access 2000 to talk to a database that's on the same LAN and Access XP to talk to a database on the net. Is this a limitation of Access 2000? Unfortunately my client uses 2000 and I can't require them to upgrade as part of my solution.

    Thanks. -- Aaron
    Nevermind. I figured it out. The Client machine needs to have the latest version of MDAC on it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •