Software

Ask something
Discussion Locked

ODBC

0 helpful
3 replies

by john_wills 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a test database with an associated database, to which my database is linked via ODBC. I started with the links to the production version of the associated database, to which I have no rights. I used the Linked Table Manager to change the links to to the test version of the associated database. There are 3 tables, 1 of which I need, for which I cannot do this: when I click OK I get the message "aplication-defined or object-defined error". The database administrator assures me that I have read, write and update rights to the table in the test version of the associated database. What might I be doing wrong?

3 replies

by bob sellman

You haven't said what kind of databases these are. I'll make a suggestion based on the assumption that your front end database is in Access and the back end database you are linking to through ODBC is SQL, Oracle, or something like that.

First, be sure that your ODBC connection really is to the test version of the ODBC database. Go to the control panel, ODBC, and define (or re-define) a connection to the test database with your log in. (Ideally, you are using server rights, rather than database rights, if the database will recognize server rights.) Use a different name for the test database, like DBTEST.

In the front end delete all tables linked linked to the ODBC database.

Then use the get external data function on the menu to create new links to the table(s) you need in the test ODBC database, being sure to pick DBTEST (or whatever you've named it).

If you're using VB rather than Access, a similar set of procedures should let you accomplish the same goal of deleting the existing connections and re-creating them.

by john_wills

I have, independently of suggestions here, deleted the link and replaced it; this works. My problem remains, though: why could I not refresh the link as I had done with the other linked tables? My front-end is Access, my back-end SQL Server. The first answer below is satisfactory as a solution, but not for general future use: there must be something special about the tables I cannot relink.

This discussion is closed to new replies.