VB and MS Access

Posted on 2003-03-13
Medium Priority
Last Modified: 2010-04-17
I am doing a Visual Basic program to sell software, but I need to know how to link a MS Access database to the VB project, also how to subtract the stock when products are purcahsed.  For example if there are 3 copies of a game left, when one if bought how can you subtract that one from the database with VB.
Question by:angus_young_acdc
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 44

Expert Comment

ID: 8129047
you have basically two choices, largely dependent on WHICH version of Access you intend to support.

With Access 97, you would probably want to use the Data Access Objects (DAO) library, while with Access 2000 and newer, use ActiveX Data Objects (ADO).

The choice is made by adding the necessary Reference to you VB project (Project/References).

It also sounds as though you have NO IDEA how to interact with the underlying database, in which case I would STRONGLY suggest that you should purchase AND READ, at least one of several VERY good books on the general subject of Database programming with Visual Basic:

Beginning Visual Basic 6 Database Programming
John L. Connell, John Connell
ISBN 1861001061

Mastering Database Programming with Visual Basic 6
Evangelos Petroutsos
ISBN 0782125980

Professional Visual Basic 6 Databases
Charles Williams
ISBN 1861002025

any of these should be sufficient to help you get started.


LVL 15

Author Comment

ID: 8134871
Cheers AW, I am a first year student at college so yes I have basically no idea LOL.

If you could give me some examples that I could practice with it would be most appreciated...if you cant thats ok.
LVL 44

Accepted Solution

Arthur_Wood earned 400 total points
ID: 8135789
as I said, check out at least one of the books I mentioned...they might even be available in the Library???

as an alternative, check out this web-site:


and then click on DataBase Programming, there you will find tutorials on Dtabase programming using VB, depending on which Database you will be using.


Expert Comment

ID: 9447169
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Post your closing recommendations!  No comment means you don't care.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This is about my first experience with programming Arduino.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question