Hi Denise ----
>>Still wrestling with ODBC, huh?
>Of course, but I'm going to lick this darn thing :)
>
OK, if you have your DSN defined there is an easy way out of this: Create a database and create a Connection based on the DSN. BTW, make sure that the database is specified (the .MDB) in the new DSN.
Here is the relevent code that GENDBC created to get, in this case, the Authors from the Booksale MDB that ships as a VB6 example.
CREATE DATABASE 'ACCTEST.DBC'
CREATE CONNECTION ACCCONNECT ;
DATASOURCE "mydata" ;
USERID "" ;
PASSWORD ""
CREATE SQL VIEW "VUEAUTHORS" ;
REMOTE CONNECT "ACCCONNECT" ;
AS SELECT Authors.Au_ID,Authors.Author,Authors."Year Born" FROM Authors
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05