VB code conenction with OBDC to database

[wan2fly99]

I havd created an OBDC connection for a Pervasive database.

In my access application in one of the events I was able to access
the tables in this databse. (It is a btree database).


In the event all I did was to code the select stmt for the specific
table I wanted.
It would go and conenct to the OBDC connection.


Now they have upgraded and I cannot figure out how the sql conencts
to the database.
It keeps telling me table is not found.


Where does access know that I want that OBDC connection? Cannot figure
out How I did it before


Thanks for any help

 

[Timtropolis]

hi Wan,

If they upgraded your btree database, then they may have upgraded the drivers too, in which case you'll have to create a new ODBC connection.

In Access , go to File, Get Extrernal data, then either Import or link tables option. When the popup windows displays, go to the "Files of type" drop down and select ODBC. This will open up the Select data source window which will allow you to edit/create ODBC connections.

HTH,
Tim