Options

Read Microsoft Access Database

mkmk Member Posts: 6
edited 2006-02-23 in Navision Financials
Is it possible to read records from a Microsoft Access database
within Navision?

I've tried to use the Microsoft Access 9.0 Object Library but
i can't seem to make it work!

(Or do I have to use the Microsoft DAO 3.6 Object Library)

I hope someone can help me...i'm probably not the first one
with this problem...

Thanks.

Comments

  • Options
    brucembrucem Member Posts: 86
    I have emailed you a couple of items that may help.

    Bruce
  • Options
    Andreas_LundinAndreas_Lundin Member Posts: 91
    Hi

    Just a comment. I'm using the ADO OCX, and it works just fine(both using data extraction from Access and DB2). If you would like a code snippet on how to use the control, just drop a note on this thread.

    Regards
    Andreas
  • Options
    PLIPLI Member Posts: 4
    Hi Andreas

    Could you please send me the code.

    Merry Christmas and happy new year to all

    TIA Preben Lindahl
    pli@oticon.dk

  • Options
    DarrenBezzantDarrenBezzant Member Posts: 13
    Hi Andreas, Any assistance would be greatly appreciated.
    dbz@nb.aibn.com
    Darren Bezzant NCPS, NCSD
    Bell Business Solutions
    Calgary, NB, CANADA
    darren.bezzant@bell.ca
  • Options
    Lars_WestmanLars_Westman Member Posts: 116
    Why not share a few lines of code in the download area instead of emailing to individuals? There are probably more out there who would gain from that.

    //Lars Westman
  • Options
    Andreas_LundinAndreas_Lundin Member Posts: 91
    Hi

    A good point! I'll post the code on this thread sometime next week.

    Happy New Year All
    Andreas Lundin
  • Options
    jtpjtp Member Posts: 9
    </font><blockquote><font size="1" face="Verdana, Arial">quote:</font><hr /><font size="2" face="Verdana, Arial">Originally posted by Andreas Lundin:
    <strong>Hi

    A good point! I'll post the code on this thread sometime next week.

    Happy New Year All
    Andreas Lundin</strong></font><hr /></blockquote><font size="2" face="Verdana, Arial">
    José Inácio Tira Picos
    Consulting Services
    SystemHouse - Consultoria e Sistemas
    j.tirapicos@systemhouse.pt
  • Options
    jtpjtp Member Posts: 9
    Hello Andreas

    Please send me a code example of this.

    Thanks

    José Tira Picos
    j.tirapicos@systemhouse.pt

    </font><blockquote><font size="1" face="Verdana, Arial">quote:</font><hr /><font size="2" face="Verdana, Arial">Originally posted by Andreas Lundin:
    <strong>Hi

    Just a comment. I'm using the ADO OCX, and it works just fine(both using data extraction from Access and DB2). If you would like a code snippet on how to use the control, just drop a note on this thread.

    Regards
    Andreas</strong></font><hr /></blockquote><font size="2" face="Verdana, Arial">
    José Inácio Tira Picos
    Consulting Services
    SystemHouse - Consultoria e Sistemas
    j.tirapicos@systemhouse.pt
  • Options
    NaveenReddyNaveenReddy Member Posts: 53
    How can i handle the NUll fields with ADO.
  • Options
    wirowiro Member Posts: 92
    Hi Andreas.
    Please send me a code example of this too.

    Thank you.
  • Options
    DenSterDenSter Member Posts: 8,304
    It would be so much more efficient if Andreas would just post the code in here.
Sign In or Register to comment.