If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking Progress to Access
I am trying to link a table from a progress V9 DB to an access 2000 DB. I am
using an ODBC connection. All the tables work fine except for one. This table i can open in design view but i can not query the table or open it in datasheet view. When i try to do these actions i get the error "...table/view/synonym not found (7519) (#-20005)". I am using the "ODBC progress SQL92 driver". Also the table that does not work is comming from a seperate database then the tables that do work. Can somebody please help? I have had this problem before when trying to query a progress table using SQL Server 2000 but never with Access. To solve the SQL server problem i had to put the objects in double quotes. How would this be done in access if this is the problem? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking Large Access Table into Excel | Steven M. Britton | Links and Linking | 1 | December 31st, 2005 12:28 AM |
Data Access Page Design | r. howell | General Discussion | 7 | December 12th, 2005 03:16 PM |
The "Right" web hosting for data access pages?? | Ron Ehrlich | General Discussion | 9 | May 6th, 2005 05:49 AM |
starting access 97 | Edward Letendre | General Discussion | 2 | January 26th, 2005 03:15 AM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |