Forgive me as I'm a bit new at this and I tend to learn things as I pass and go. Aside from MS Access, what other databases can you use for VB?

Use Oracle, SQL server,My SQL for VB.

-V.Vadivelan

Hi,

Yes you can use any kind of older version databases like foxpro. Only thing is you have to use the appropriate library to make use of the databases. The above said databases will be accessed by adding the Microsoft DAO library to your project. and use the following command to open any kind of databases..

Dim db As Database
Set db = OpenDatabase(DatabaseName)

thanks

__________________
Karpagarajan. R
Necessity is the mother of invention

You can use any database with visual basic. But I use oracle and ms access you should use different connectivity string for each.

For oracle : provider = MSDAORA.1 and for access it is provider=Microsoft.jet.oledb.4.0 and you should give user name and password while using oracle.

Let me knwo if you have any problem regarding this , I may help you