I can tell you that to access Access, the usual API is DAO 
(http://en.wikipedia.org/wiki/Data_Access_Objects). Using ODBC and Access I 
think you would need to have the database already created to create a DSN; 
you need a file to which it will point. If you don't have Access you might 
be able to start with a populated mdb then drop the tables you don't need 
then create the ones you do though.

-- 

Post a reply to this message