Member Avatar for annain

Hi,
I want to develop RFID access system. I create a user database using Microsoft Access.When system and connection are ready, user will swap the card on the RFID reader and the card id will show on retrieve data column. The card id will use to compare with the data in Access database. If the card id matching with database, the user information such as name will show on other column. Now, my problem is how to compare data in visual basic 6 with the data in access database. I want to know how to compare data in visual basic 6 with the data in access database.Thank you in advance :)

  • 4 Contributors
  • 4 Replies
  • 2K Views
  • 5 Months Discussion Span
  • Latest Post Latest Post by Qing _1
Member Avatar for Sulaiman_1

1.Get the name(data) from RFID to frm.name
2.Select data from the access using SQL query
ex:

select * from tblname where name='" & (name from frm.name) & "'

Hope. the code will help you!

Member Avatar for Aslam Mansoor

Yes, when you swipe the card the User ID or Whatever it is to be shown on a Text BoxVB Form. Then by a SQL filtering Query, you may check whether that ID no. is already existing in the table of your Access or whatever the DataBase. If it is existing you may write the coding to retrieve the details including the ID No. on to a Grid or Listview, pertaining to that ID accordingly.

Member Avatar for annain

Thank you so much Sulaiman 1 and Aslam Mansoor for the idea. It solved my problem :)

Member Avatar for Qing _1

hai,I face same problems with you.Can you give me your source code to compare data in visual basic with access database?Thanks so much

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.