Remote Ms Access by vb 6

[surk]

Dear Sirs,

One problem that i have been confronting is that:

How to access the remote Ms access database from visual basic 6 in a simple way.
I wrote something in the connection string specifying the IP Addres of the machine where database resides. but fails. May be wrong in giving the correct path. i don't know how to specify exactly.
Please help me.


yours

surk

[vb5prgrmr]

Remote as in over a network or internet. Internet you cannot do with access unless you write a service as an intermediary on the machine hosting the mdb, like a webserver and an asp application. Over a network, see http://www.connectionstrings.com



Good Luck

[si_the_geek]

Thread moved to 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)

If it is within a network, share the folder that the database file is in, and set apt permissions. For more information, see the article How do I use an Access database from multiple computers (in a network)? from our Database Development FAQs/Tutorials (at the top of this forum)

If it is over the internet, it would be far easier and much more reliable to change from Access to a server-based database system.