Results 1 to 3 of 3

Thread: SQL/Jet ODBC

  1. #1
    Join Date
    Dec 2002
    Posts
    2

    Unanswered: SQL/Jet ODBC

    I have linked tables in Acess2k linked to a SQL backend. I link the tables through code by supplying a connect string. In this string I supply all information needed so the user does not get a prompt.

    If the connection fails, a SQL server ODBC dialog appears and the user can enter new connect info and try again. I do not want this dialog to appear. I am not sure if it is SQL or Jet causing this to appear. Does anyone know how to suppress this connection dialog box?

    Phil

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

    Me too

    Im in the same situation...

    Can't find an example of this, although in the meantime I've written some code to delete the linked table then re-attach it when the db opens.

    Bit crude but it solves the problem - Anyone got a better way?

    Thanks

  3. #3
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Re: Me too

    Originally posted by garethdart
    Im in the same situation...

    Can't find an example of this, although in the meantime I've written some code to delete the linked table then re-attach it when the db opens.

    Bit crude but it solves the problem - Anyone got a better way?

    Thanks
    Have you tryied error handeling. If you know the error number you should be able to trap it and eather suppress it or make a diff mesg appear.
    Jim

Posting Permissions

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