Access and OBDC connections

[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

 

[Arvin Meyer [MVP]]

The link is stored in the connect property. The easiest way is to delete the
linked table and recreate the new ODBC connection and link. After creating
the ODBC connnection, open Access, go to File ... Get External Data ...
Link. Then in the dialog change the database type to ODBC and follow the
next screen to your ODBC connection.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com