VB6 Databases

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

MyName

Thread Starter
Joined
Oct 25, 2001
Messages
316
I'm creating a budgetprogram, and I know some things about databases in Visual Basic. However, some things I am trying to do I am unsure of. Can anyone point me to a website that would help clarify the following things:

-creating new databases in vb run-time
-adding fields to databases during run-time (adding a new expense in a text box, I would then add it to the database)

Essentially, the program works as a user enters their name, if it is a new name it creates a database. It will ask to add categories and amounts. Then it will display those figures on the main form, and allow the user to add the amounts in etc. I know how to get from the database to display values in text boxes and labels, but I don't know how to create a database using Visual Basic, as well as adding fields to it. I've looked around, but haven't found anything that would help me out. Thanks in advance.
 
Joined
Aug 21, 2003
Messages
2,016
The answer depends on which database software you use. If, for example, you use Access, you should look into ADO.

You could then use SQL statements to create, modify, and delete tables and records. I am not sure you want to create a new database for every new user/name....look into, possibly, a new table for each.

Upon closer thought, you may be better off, depending on size, to create one dbase, with a table for user info, then other tables to track other information (using a unique key from the user table as the relationship).

Hope this helps,

MBN
 
Joined
Apr 17, 2004
Messages
8
I would pick up one of the WROX books on VB+Databases like Access... It the the best publication for beginners..
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top