Link a table from Navision to Access

gostagosta Member Posts: 2
edited 2005-10-27 in Navision Attain

I want to link tables in a Navision database (not SQL-server) and use the native ODBC-driver C/ODBC 32 bit. I set up a file DSN. This works good with the small demo company "Cronus". But doing the same the huge production database > 80 Gbyte (the DBMS cach is set according to the documentation) I have problems. It is possible to link a table and see the records but when Access is closed and reopened the lincs are corrupted. There is an ODBC-fault and also Access may crash or not open at all. Any hint to solve this problem is appreciated.

Sign In or Register to comment.