i have created VPN connection both side (Server and client), and i can access shared folder which is on server from client machine. ( \\myservername\sharedfolder)
vb application is on the client side and database is on the server.
How can i connect database through my vb6 application
i can connect local database using following connection string.
con.Open "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & App.Path & "\Tran.mdb;Jet OLEDB:Database Password=88888"
But how can i connect remote access database, what string must i use,
Please reply me soon as possible
Its urgent i need to solve this problem