VB 6.0 and MS Access Connection String from the Server

[Hiren Joshi]

I am using following connection string for VB 6.0 and MS Access project, I have a server Windows 2003 Server with SP2.

Con.Open "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" & _
"P:\Main\Databa se\Master.mdb;" & _
"Jet OLEDB:Database Password=admin; "

My Application is in Server's "E:\Main\Applica tion" Folder

Now in this case, If i put My Database on the server's "E:\Main\Databas e" Folder then I have to Map Network Drive from All Workstations to P:

is there any simpler way that Application automatically checks the Connection path from the server.

If you can give me the solution for both Server With "Domain Name - XYZ" and as a "Workgroup".

Regards,

Hiren (Nairobi - Kenya)

[debasisdas]

Please find the details here .

[Hiren Joshi]

YES,

It has given me what I wanted.

Thank You Very Much Debasis for This Help.

Hiren

[debasisdas]

You are most welcome.