Problems with ODBC in MBS 3.70

Pachi
Pachi Member Posts: 25
edited 2010-03-15 in NAV/Navision Classic Client
When connecting to the served Navision database from Excel, I can see twice every table with data and once all empty tables.

In adittion, I can see all field names duplicated in the duplicated tables.

When accessing from Access, I can not retrieve data from tables because Access can not manage two fields with the same name.

Could someone help me?

Thank you,

Comments

  • kine
    kine Member Posts: 12,562
    And how you see the tables in Navision?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Pachi
    Pachi Member Posts: 25
    In Navision tables are OK. I have checked captions but they are OK, too.

    Only tables with data in Navision are duplicated in the wizard to select tables and fields in Excel.

    Thank you,
  • Pachi
    Pachi Member Posts: 25
    Finally, I found the solution...

    Database have temporary tables from a interrumped restore process. I tried to restore a new backup and system asked me if I wanted to delete these tables. I said Yes and cancel the continuation of restoration.

    Thank you all,

Categories