A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Linking Progress to Access



 
 
Thread Tools Display Modes
  #1  
Old March 2nd, 2006, 08:16 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 11:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.