Is there any sample code showing how to log data to a Microsoft Access
2000 database from Visual Basic 6?  The data will be time/date stamped
ID tags from an RFID reader, and the tags will be referenced to part
numbers, descriptions, locations, etc.  I simply need to add records
to a table, and read from the database to display the part currently
at the reader.

---

Request for Question Clarification by mathtalk-ga on 25 May 2003 11:28 PDT

Hi, welday007-ga:

Access 2000 marks a "watershed" for the Access product lines between
the older DAO technology, highly optimized for ODBC, and the newer ADO
technology.  While ADO is in some sense the future of Microsoft data
access, Access 2000 still has a foot in both camps.  Do you have any
preference between these two API's?

regards, mathtalk-ga

---

Clarification of Question by welday007-ga on 27 May 2003 11:52 PDT

I would prefer the newer ADO.

---

Request for Question Clarification by mathtalk-ga on 18 Jun 2003 14:00 PDT

Hi, welday007-ga:

I was wondering if you were satisfied with the information provided as
a Comment by ferg_y2k-ga.  You will not be charged for "answers"
provided in Comments.  If you would like a more detailed illustration
of using MS Access databases from VB6 through ADO, please let me know.
 Otherwise you may wish to expire your question (by using the "Close"
button at top) to avoid being charged for an answer.

regards, mathtalk-ga

Hi there, found a cool example which will help u, shows u have to get
access and vb to interact

http://www.vbcode.com/asp/showzip.asp?ZipFile=http%3A%2F%2Fwww%2Evbcode%2Ecom%2Fcode%2Fsqlplus05062002%2Ezip&theID=6793

Remember Ms Access is juts another SQL language so u can connect to it
and execute normal sql querys.

btw, u can get any programing advice free, there r several bored for
programmers which will help u for free.

Hope this has been of some help, dont worry about anything like
payment.