Member Avatar for sackymatt

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..
thanx

  • 2 Contributors
  • 1 Reply
  • 137 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by vb5prgrmr
Member Avatar for vb5prgrmr

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.