Easy Visual Basic 6 Question

[shacket]

I'm sorry. I have tried to look this up and can't seem to find the answer to this question. It should be simple.

In Visual Basic 6, where do you store the information? To use Access terminology, where are the "tables"?

Thank you to anyone that can help.

 

[Travis]

Visual Basic is not a database application. (in fact Access isn't either)

Access comes with its built in database engine "Jet", this allows for the "Table" screen that you see.

In VB handling of Database is different in the sense that you don't have "Linked" tables. You can establish connections to databases ("Tables") using various methods. The most common is through an ODBC Driver.

Thus with VB you will need a seperate Database application to create your data storage.

 

[shacket]

What are some of the common database applications that are used? I know Access is one, but what are others?

 

[Robert Dunstan]

MS SQL Server and Oracle are the most common database applications in use today.

Like Travis has said VB is not a database application but a development tool that will allow you to build custom .Exe applications which can make use of ODBC, ADO etc to connect to external databases such as SQL Server or Oracle.

 

[Travis]

Ahh Robert you are right SQL Server and Oracle are the most common in the business field, but you did miss a very big one that is most common in the Medical Field and has been in use (with many upgrades) since 1967... "MUMPS" or as it is better known "M".

 

[Robert Dunstan]

Well I must say I've not heard of that one. May be I should visit the doctors more often!!!