Options

Writing to an Access db

MrBill1962MrBill1962 Member Posts: 28
edited 2013-08-28 in NAV Three Tier
Hi all. I've done some work in the past with writing to SQL server via ADO automation recordsets but have never really done it with MS Access db. I would think that it would be similar. I searched the forumn and found little pieces but nothing too definitive.

Can someone provide me for what they believe with be the simplest method of reading and writing to a Access 2007 db using NAV 2009 R2?

Just the connection method a very small codes sample would be very helpful!

Thanks all, very much!

Comments

  • Options
    deV.chdeV.ch Member Posts: 543
    Yes you can use ADO Recordset like you do with sql server, just use another connection string:
    'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<path To mdb File>'
    
Sign In or Register to comment.