Hi, I am trying to link my access table to one on an AS400. The table structure with all the fields seems to be importing/linking fine, but when I attempt to view the table, I get the Windows ODBC driver connect screen. When I select ok, I then get a "Reserved error (-7778) there is no message for this error". Any idea why this is happenening. Since the table structure seems to be fine, I am thinking there is a problem with the data.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ODBC link table problem
- Thread starter btrini10
- Start date
Are you using the IBM Client Access ODBC drivers? If memory serves, you need to set up a logical file for the index, and make sure you have rights to the library, etc.
Also, check the field count, I vaguely recall Access not correctly reporting a 'too many fields' error and just giving a 'no message for this error' response.
--Jim
Also, check the field count, I vaguely recall Access not correctly reporting a 'too many fields' error and just giving a 'no message for this error' response.
--Jim
- Status
Similar threads
- Question
- Locked
- Question