asked on

VB and MS Access

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.

Arthur_Wood

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.

AW

angus_young_acdc

ASKER

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.

ASKER CERTIFIED SOLUTION

Arthur_Wood

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CleanupPing

angus_young_acdc:
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
EXPERTS:
Post your closing recommendations! No comment means you don't care.