Re: How to connect MS ACCESS in Netwaork base VB6.0 Programme from server

You can use ADO to connect to almost any data source. Here is a basic Code
Structure you can use to connect to and query an Access Database using ADO.

Dim cn As ADODB.Connection, rs As ADODB.Recordset
Dim strCn as String, strSql as String

Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
strCn = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Persist Security Info=False;" _
& "Data Source=\\Server\Share\DatabaseName.MDB"
cn.Open strCn
strSql = "SELECT * FROM SomeTable " _
& "WHERE SomeCondition = SomeValue " _
& "ORDER BY SomeColumn"
rs.Open strSql, cn, adOpenKeyset, adLockOptimistic
If Not rs.EOF Then
' Do your thing here ...
End If
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing

In future posts please use mixed case. It is generally considered impolite
to use all caps. All caps is looked upon as shouting. Good luck with your
project.

--
Ron W
www.WorksRite.com
<s_parvez_a78@xxxxxxxxx> wrote in message
news:1139312897.860985.61850@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
HI
How to connect MS ACCESS in Netwaork base VB6.0 Programme from server
I AM DEVLOPING A EMPLOYE ATTANEDENS RECORD PROJECT IN THIS
I AM USING VB6.0 AND MS ACCESS AND WINDOEW XP
IN MY PROJECT EMPLOY ENTER THERE ATTENDENS FROM HIS COMPUTER(CLINT
SIDE) AND ATTENDENS STORE OM MS ACCESS DATABASE WHICH IS STORED ON
SERVER SO
THIS PROJECT IS WORKED ON MORE THE 30 COMPUTERS NETWORK
I WANT TO KNOW HOW TO I CONNECT THE MS ACCESS DATABASE FROM SERVER TO
VB6.0

I HOPE U HELP ME
PLZ MAIL ON s_parvez_a78@xxxxxxxxx or s_parvez_a@xxxxxxxxxxxxxx

BYE



.