Heres the deal:
Im using a visual basic 6 program that I want to store a username and a password in a database. Now the database is going to be an online database..not residing on the same computer as the program. How can i access the database if say the address is: http://www.database.com/database.mdb

From the program I want to connect to this database, add username and password and update it.

heres a sample of how I did it when the database was on my computer:
_____________________________________________
Public Sub openANDupdateDB()
Dim db As ADODB.Connection
Set db = New ADODB.Connection

Dim primaryRS As ADODB.Recordset
Set primaryRS = New ADODB.Recordset

db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\WINDOWS\Desktop\databases\UserInfo.mdb;"
primaryRS.Open "PlayerStats", db, adOpenStatic, adLockOptimistic



primaryRS.AddNew
primaryRS("UserName") = name
primaryRS("Password") = pass
primaryRS.Update
primaryRS.MoveNext

databaseBool = True
primaryRS.MoveLast
primaryRS.Close
db.Close
_____________________________________________
This works fine but now instead of the source being: C:\WINDOWS\Desktop\databases\UserInfo.mdb

I need it to be:
http://www.database.com/database.mdb

How can i connect to this server and add and update my database...thanks in advance

Anyone?

You can't directly open database over the internet. But you can use Microsoft RDS object to access data.
You need to create server COM object which
access data locally on a server and expose
some public methods which do work like adding
users to the table.
Add reference to the Microsoft Remote Data services on a client computer.
On a client side you use such :
dim rs as new RDS.DataSpace
set oRemote = rs.CreateObject("yourserverproject.yourclass","http://www.database.com")
and then use methods of this object:
oRemote.Adduser "UserId","Password"
I hope this help.
Alex