You need to create Recordset objects using OLE. Take a look at

• Retrieving the last insert ID with Access
• Cannot insert into MS Access Memo field with DBI

Hope that helps :)