Hello, if I had manually linked the tables I had activated the "store password" checkbox. If I automatically linked the tables I used the following connection-String: ""DEVEL", dbDriverNoPrompt, False, ODBCConnect" with ODBCConnect = ""ODBC;DSN=DEVEL;SERVER=IP.Ad.re.ss;DATABASE=DEVEL;UID=" & myUser & ";PWD=" & myPassword" and I wasn't getting asked for a password for that linking. But if I opened a bound form in these two cases the ODBC-Driver opened. Maybe cause I'm using VBA-Code with SQL-Statements to assign items to combo-boxes, but my understanding is, if I have linked the tables everything should work without any changes. (This was true if I made a "Access"-split (means: using the Access-Wizard for dividing frontend from backend)).
Now I'm going to try the other suggestions. Peter > -----Urspr�ngliche Nachricht----- > Von: Koetter, Thomas Theodor [SMTP:[EMAIL PROTECTED] > Gesendet am: Mittwoch, 13. August 2003 15:43 > An: H�bschen, Peter; Mailingliste SAPDB (E-Mail) > Betreff: RE: Access Bound Forms and ODBC-Driver > > Hi Peter, > > > -----Original Message----- > > From: "H�bschen, Peter" [mailto:[EMAIL PROTECTED] > > Sent: Mittwoch, 13. August 2003 15:38 > > To: Mailingliste SAPDB (E-Mail) > > Subject: Access Bound Forms and ODBC-Driver > > > > > > Hello, > > > > in Access 97 I have bound forms. I have linked my sapdb > > tables manually and > > via VBA into Access. If I open such a bound form the > > dialog-box from the > > ODBC-Driver opens and asks for a valid login. > > I guess, the popup dialog is the one initiated by SQLDriverConnect. > > > > Sometimes I'm > > getting asked a > > lot of times. And even if I type a valid login the form > > doesn't work like > > under a pure Access-Environment. > > SQLDriverConnect can be called with the attribute NO_PROMPT. > Then no popup is shown and a logon is performed if all > necessary data is provided. > > > How can I get rid of this dialog-box? Maybe then my forms > > will work again. > > In VB the NO_PROMPT attribute is surely available, too. > > > > HTH Thomas > > > ---------------------------------------------- > Dr. Thomas K�tter > SAP DB, SAP Labs Berlin > > > Hurry up, SAP DB is open source www.sapdb.org > > > > > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
