Hi all, i would like to know how to access data in the database using vb6 and the database in ms access 2007. for example i have a table in the database called item, with data fields such as itemname, item-id ,etc, so if i want to access the data in this table suppose in itemname, wat code must i put in vb6 to access this? Supposed i want a total of all the items in the table..i have connected my db using adodc.

please help..

Use the data form wizard with the option of code (search for it in this forum and you will find my instructions on how to find it if you don't know where it is). Then see http://www.connectionstrings.com

Good Luck