> DIM App.SuperAceDB AS ODBCDatabase // declared in App > > App.SuperAceDB = NEW ODBCDatabase > App.SuperAceDB.DataSource = "" // this line > should request an open file dialog box > > IF App.SuperAceDB.Connect THEN > MsgBox "we are connected to SuperAce" > ELSE > MsgBox "we are not connected" > END IF > > > As I read the LR, the third line should generate an open file dialog > box for the user to specify the Access database file's location. > Nothing happens and control falls through to the "we are not > connected" message. > > The ODBC plugin is working, else it would not have recognized the > ODBCDatabase class. The Connect returns FALSE, probably since there > is nothing to connect to. > > What am I missing? Thank you, TJH
It works for me. It opens the DSN window for you to pick one. Try taking out your App. References and running it, then reassign the variable if it works. There must be something funky going on. HTH, -seanA _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
