Originally posted by: MMM12

HOW  CAN I USE MICROSOFT ACCESS WITH MULTIDIMENTIONAL PARAMETER WITHOUT TUPLE?  (syntaxe i write in  .data)

FOR EXAMPLE FOR THIS PARAMETER :

 int capacity_prod [product][Production_sites] [PlatformsU][scenario]

Originally posted by: davidoff

You can write a query such as :

products,productionSites,platorms,scenarii, capa from DBRead(db, "select product, prodSite, platformU, scenario, capa from TABLE")

Originally posted by: MMM12

Ok thank you.

Just to verify how to connect with access?

DBconnection db("odbc","\ what we write here? the adresse or the file name//");

Originally posted by: davidoff

with access, there is a dedicated connector DBconnection db("access", "myaccessinstance.mdb")

Originally posted by: MMM12

Thanks. I have tried products, productionSites,platorms, scenarii, capa from DBRead(db, "select product, prodSite, platformU, scenario, capa from TABLE") but it didn't work. Can you explain me how I use index (product, prodsite...) and parameter (capacity_prod in my case). thanx.