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?
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?