database

how to create database and use it in Visual Basic annd further interface it with microcontroller

very simple :-)

1. make a database file using MSAccess ..
let u create a database named "students.mdb" which has a table in it named "info".
let this table contains 2 fields named..."name" and "age".
2.
then u declare a database in vb as

 Dim db As Database
Dim rs As Recordset

3.
then u initialize database in vb as

Set db = OpenDatabase(App.Path & "\students.mdb")
Set rs = db.OpenRecordset("info", dbOpenDynaset)

4.
thats it.....now u can create new records,edit,delete records from it.
for example to create a new record, u write as

rs.addNew
rs.Fields("name")="abbas"
rs.Fields("age")="20"
rs.upDate

hope it helps :-)

but how to interface this database with the microcontroller?

1.first interface your microcontroller to your PC (serial/parallel/usb connection)
2. collect data from microcontroller in your vb program
3. send it to your database... or do wat ever u want

how to collect data from microcontroller in your vb program. can u please explain me with one technical example.

let u have connected some sensor to uc.u want uc to read that sensor and send its data to pc (let say serially).
for this u first program ur microcontroller.
then u make a program in vb which reads data from serial port.
so whenever ur controller will send data, vb program will collect it .
and u can do whatever u want with that data

hope it will be clear now

just a hint.. check for MSCOMM in your VB
go to Project->Components->Microsoft Comm Control
just drag and drop in your project..

why i can't define variable db as database? i use vb6 and ms access 2003

ginseng
what error u r getting