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