Access 2010 & Sage 200 (2014) ODBC #Deleted results

[towners]

Hi,

I'm attempting to use Access to ODBC to Sage 200, I do this a lot with another SQL Database without problems however when I create my dynamic links and then create a query the results returned for many of the tables are "#Deleted" for each record. I've tried various ODBC drivers but still the same results. I've googled fruitlessly... I can link using excel no problem but I need access to create the complex queries and reports.

Does anyone have any experience with Access & Sage 200 and see/overcome this problem?

Thanks

Towners

 

[Micron]

See https://support.microsoft.com/en-us/kb/128809

 

[LeslyeE]

I have had a similar issue dealing with ODBC to Oracle and Legacy tables. Generally I see this when I have lost connectivity to the network. I am not sure if this helps but it is something I have seen.