AW: Access Bound Forms and ODBC-Driver

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