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 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?