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
  • 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
When you discover the power of the R programming language, you are going to wonder how you ever lived without it! Learn why the language merits a place in your programming arsenal.
Six Sigma Control Plans
Starting up a Project

609 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