Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78

    Question Unanswered: ODBC--call failed

    I have a database in SQL Server 2000 which is accessed using MS Access 2000. Everything works in the database apart from one form that displays the message ODBC--call failed when attempting to open.

    There is an on open event on the form but that just sets a visible property on a button. The data source for the form is from a query that works fine when opened by its self.

    Im stuck for ideas!

    Can anyone help on this one?

    Thanks in advance!

    NeilA.

  2. #2
    Join Date
    Feb 2002
    Posts
    64
    Do you get any sort of time out message?

    I use ODBC for Client Access and I know that if there is anything too "complicated" the call will time out.

    Are there any fancy calculations being performed on your form?

  3. #3
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78
    Thanks for replying.

    There is no time-out message and as far as I can see nothing complex is happening. It does however have a subform within the form which may be affecting it?

    I am at present creating the form from scratch to try and pin point the problem.

    I'll let you know what the problem is if I find it.

    Thanks

    Neil.

  4. #4
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Lightbulb Re-Link tables

    Try re-linking any of the odbc tables

    ONE AT A TIME

    Ensure that when you do, you check the "save password" tick box at the bottom of the link tables dialogue form.

    THINK!!! This should do it - let me know
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  5. #5
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78
    This hasn't worked either im affraid.

    Is there like a White Paper by Microsoft that describes how to get a database from Access to SQL Server?

    Thanks anyway!

    Neil.

Posting Permissions

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