Network connection

[Ah ez]

Dear Sirs,
I have made vb6 prog. and running well, I want to connect into two or three computers. I have named dbfile folder exampl : c:\Mydbfile\fil ename.mdb. How to connect the dbfile into other computers and can enter the datas by users... when i am connecting its telling me dbfile not found to run the prog. Any body can help me.... Thanks
Ah

[Guido Geurs]

just enter the path to the file like this:

     mobjConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
                              & "Data Source=" _
                              & "\\Rode_kruis\D-C on test\xfer\Cust.mdb"

where:
\\Rode_kruis = name of the PC
\D-C on test = name of the shared drive
\xfer = name of the folder
\Cust.mdb = name file

you can also obtain the path by opening Explorer and showing the properties (Location:) of the file.

Remark: the users must have permissions to change the DB file if you want write to the file!