Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Problem with ODBC when link Microsoft Axapta 4.0 table to Access 2
0 views
Skip to first unread message
Majsterek22
Jun 12, 2008, 5:04:00 AM6/12/08
to
Hi, i'm trying to link a big table from Microsoft Dynamics AX 4.0 with ODBC
connection into Access 2007 and when Acces show me a records from the table
they are empty (filled by the word !DELETED), is there any one who can help
me to i get normal table from Axapta into my MS Access 2007?
connection into Access 2007 and when Acces show me a records from the table
they are empty (filled by the word !DELETED), is there any one who can help
me to i get normal table from Axapta into my MS Access 2007?
Jim Hummer
Jul 22, 2008, 12:39:00 AM7/22/08
to
DAX 4.0 doesn't work with ODBC you need to use OLE DB connectors.
Jim
PvO_be
Oct 30, 2008, 1:26:15 PM10/30/08
to
I take it you have this #Deleted message in only some tables that you have
linked to with MS Access?
The problem as far as I learned, is that MS Access does not recognizes the
BIGINT data type - which is used by the RecId in DAX 4.0.
linked to with MS Access?
The problem as far as I learned, is that MS Access does not recognizes the
BIGINT data type - which is used by the RecId in DAX 4.0.
Thus if you try to look at the Address table from within Access it will
display the #Deleted, but if you look at the InventTable from within Access
all is fine.
If you open the Address table for design within Access (will be read only
mode) you will see that the table has some RecId (including references)
values as part of the unique identifyier (primary key). That is were your
problem is.
I read a suggestion to create views for these problem tables, but I'm still
looking for a MS Access fix versus a SQL work around.
Patrick
0 new messages