Linking Progress to Access

A

A.B.

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Create an S-Curve from Custom Field? 0
Sharing Access MDB or Accdb with client using older or newer version of Office 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Table Security in Access 2013 1
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Linking data in MS Word into Excel 5
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0

Top