Retrieve data from Access Linked Table

iansilvers
iansilvers Member Posts: 38
edited 2013-11-26 in NAV Three Tier
Looking for a bit of help here.

Our customer has an Access database which they want to be able to enquire on from within NAV. I have created a Linked Server in SQL for the Access database, and created a couple of views against it. I have created linked tables in NAV for each view. I have also created a couple of pages against these, and I can run both the table and the pages and see the data in Access. I can set filters on the page, and it all works as I would expect

The problem I have is that I am now trying to read the within a codeunit. I have following code

Collection.RESET;
IF Collection.FINDSET THEN
REPEAT
...
UNTIL Collection.NEXT = 0;

This consistently fails to return any records from the Access database, despite the fact that I can see them when I run the table and the page

The same happens when accessing the linked table via a report - I get no records returned.

I am using NAV2013 R2 with a SQL Server 2012 database.

Any help would be greatly appreciated

Categories