DB Server Conectivity

[shanmugham]

access97
vb6
Windows XP

i need to write a very small program updating a database
which is located on another machine on a local area network and i have no clue where to start this., how can 2 pcs update the same database at the same time

this is how i used to connect to mdb on my own pc

cmk = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & App.Path & "\fileman.mdb"
Set con = New ADODB.Connection
With con
.ConnectionString = cmk
.Open
End With

is there a quick fix, say if the network PC is called SERVER,

thanks!

shan

 

[mattKnight]

this'll do it

dim strPathToMDB as string

strPath = "\\server\sharedfolder\fileman.mdb"
'cmk = "Provider=Microsoft.Jet.OLEDB.3.51;'Persist Security Info=False;Data Source=" & 'App.Path & "\fileman.mdb"

cmk = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & strPathToMDB

Set con = New ADODB.Connection
With con
.ConnectionString = cmk
.Open
End With

Take Care

Matt
If at first you don't succeed, skydiving is not for you.