Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    3

    Unanswered: Access 2000 connection failing to SQL Server2000

    Hi guys,
    I have an Access .adp project which is connecting to a SQL Server 2000 database. I am using Windows NT authentication.
    When I open my access project I get an error message indicating that the stored procedure called from my start up form could not be executed. The problem is that the connection does not appear to have created.
    In the main menu I click File and select Connection
    The server is correctly selected in the drop down list on the pop up screen.
    I click on 'Test Connection' and the I get a message indicating success. Now my project is connected and I can continue through the other forms and reports, executing stored procedures and getting records in my reports.
    Any ideas on why the project is not connecting on start up, and why simply testing the connection appears to resolve the problem?
    Has it something to do with DNS?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    First of what is the SP level on SQL server and what is the exact error message?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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