Here i am again.
I would like to to know how to use/connect a database for my login program to a
Database from another computer.
I will be using 2 pc unit and connect them with a CROSSOVER connection UTP Ethernet cable.
My Dbase will be on the other unit while my app will be on the other one.
My questions are:
What are the Components i will use for my VB App?
Do I have to run my Program on both unit?
Do i have to install VB6 on both unit?
And would i have to use this code?
Set db = New ADODB.Connection
db.CursorLocation = adUseClient
db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path & "\Database.mdb"
Set rs = New ADODB.Recordset
rs.Open "select * from Users where UserName = '" & txtUser & "'", db, adOpenStatic, adLockOptimistic
How is the code if the source (Dbase) is on another PC..
Really need help on this one. ASAP :'(