Accessing a Remote Database with VB6

Question

How to access a remote database with Visual Basic 6?

It's been a while since I've done any code in Visual Basic 6, I remember ODBC connections however I'm not sure how I would go about it. All that I need is to have a database on a host computer and then some clients would connect to it, probably without need to guarantee simultaneous access.

Edit: I'm trying to access a Microsoft Access database.

Answer 1

This tutorial should help you get started.

Answer 2

You need to use ADODB, here is a tutorial that covers most of what you need.

Answer 3

The methods mentioned by @rick_schott and @eric_j are good and legit, but if you want speed, that is not the way to go.

Instead, you want to use DAO and Jet (the technology released prior to ADODB). Here is a pretty good tutorial:

http://www.vb6.us/tutorials/using-dao-data-access-objects-code-tutorial