wicked1980
New Member
Hi there,
We're having some problems connecting MS Access to the Progress database of our third-party managed ERP software (Agresso Wholesale / Unit4)
First let me start by stating that due to the fact that we're using a third party DB, we cannot change any settings in the DB environment ourselves. That doesn't really help the whole troubleshooting process, but that’s just the way it is...
The first problem we encountered whas when we were setting up the link between Access and Progress using the ODBC software provided by Unit4 (Progress OpenEdge 10.1A). When we got to the point where you can choose a table, we got an error:
error(-7748) the is no message for this error
(thank you Microsoft for this helpful message...
)
Eventually we solved this problem by using the following solution:
http://stackoverflow.com/questions/...ing-workarounds28192-do-on-an-odbc-connection
(notice the link to the Daily WTF, clearly we weren't the only ones flabbergasted...)
So at this stage, we could start picking tables and run some basic queries. This seemed to work, but the following happened:
When a table has an empty Index/Primary key field, MS Access shows the value "#Deleted" for every field in the current record.
Both the Third party provided reporting tool Brio (Oracle) and MS Query just show an empty field and the correct values for the other fields in the same record.
So my question is, why does MS Access do this?
We did find a few hints to a possible cause, as described in: http://www.ingres.com/kb/article/418033
But the solution suggested did not work
We're having some problems connecting MS Access to the Progress database of our third-party managed ERP software (Agresso Wholesale / Unit4)
First let me start by stating that due to the fact that we're using a third party DB, we cannot change any settings in the DB environment ourselves. That doesn't really help the whole troubleshooting process, but that’s just the way it is...
The first problem we encountered whas when we were setting up the link between Access and Progress using the ODBC software provided by Unit4 (Progress OpenEdge 10.1A). When we got to the point where you can choose a table, we got an error:
error(-7748) the is no message for this error
(thank you Microsoft for this helpful message...
)Eventually we solved this problem by using the following solution:
http://stackoverflow.com/questions/...ing-workarounds28192-do-on-an-odbc-connection
(notice the link to the Daily WTF, clearly we weren't the only ones flabbergasted...)
So at this stage, we could start picking tables and run some basic queries. This seemed to work, but the following happened:
When a table has an empty Index/Primary key field, MS Access shows the value "#Deleted" for every field in the current record.
Both the Third party provided reporting tool Brio (Oracle) and MS Query just show an empty field and the correct values for the other fields in the same record.
So my question is, why does MS Access do this?
We did find a few hints to a possible cause, as described in: http://www.ingres.com/kb/article/418033
But the solution suggested did not work
