Attain and Microsoft Access

balrog
balrog Member Posts: 14
edited 2003-10-10 in Navision Attain
Hello,
my problem is that I want to connect a table in Access database with a table in Navision database. I need to know if it is possible, what utility I need to do it and so on. Can anyone help me?

Comments

  • nunomaia
    nunomaia Member Posts: 1,153
    Can you define better connect .
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Sbhat
    Sbhat Member Posts: 301
    Hi,

    You will have to use CFRONT to do this.

    Thanks
    Best regards
    Suresh.
  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    When you use C/ODBC, you can create a "Linked table" in Access. This "Linked table" is just a reference to the table in Navision. When you open the table in Access, it gets the data, through ODBC, from the Navision database.

    Is this what you want?
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Denis_Petrov
    Denis_Petrov Member Posts: 107
    Hi,

    I would just convert Access file to .csv and then do dataport.
    Best regards,

    Denis Petrov.
  • balrog
    balrog Member Posts: 14
    nunomaia wrote:
    Can you define better connect .

    Hi,

    I`ll give a better definition of my problem. I need a table inside Access, which shows actual data from Attain table No. 27 - Item and I need this table to be related with another table inside Access. In present time I do it by exporting data to Excel Sheet. Then I import it to Access, but I have to do it once a day, and from time to time, some problems may occur.

    Can you give me an advice? Thanks a lot.
  • balrog
    balrog Member Posts: 14
    Luc Van Dyck wrote:
    When you use C/ODBC, you can create a "Linked table" in Access. This "Linked table" is just a reference to the table in Navision. When you open the table in Access, it gets the data, through ODBC, from the Navision database.

    Is this what you want?

    Hi,

    that really could be what I`m looking for. Can you give me some more information about C/ODBC? How can I use it? What do I need to use it? And in the end, will I be able to make relation between this linked table and another table inside Access?

    Thanks a lot.
  • shogan@mila.ie
    shogan@mila.ie Member Posts: 113
    Hi Balrog

    I do what you are looking for, using C/ODBC.

    C/ODBC extends the Data Sources (ODBC) in the Control Panel in Windows.

    I use Attain 3.01A. On the product CD, there is a CODBC folder. Run setup from here and follow instructions.

    In the ODBC Control Panel, Add a new System DSN (this works better than File DSN).

    The driver you will be using is C/ODBC 32 Bit. Set it up to work from your database (I have a server connection). Make sure you logon with admin rights, so that you have access to all tables!

    Then in Access, create a new Database.

    File - Get External Data - Import (or link...depends on your choice, I would recommend Import, as it is safer!)

    Change 'Files of type' at the bottom of the dialog box to 'ODBC Databases'.

    Click on 'Machine Data Source', and select the connection you just created, and wait for your company selection to appear.

    Just a note - I have found that you cannot switch companies until you shut down access and reopen the db you created initially.

    Hope this helps!

    Stephen H.

Categories