Printable View
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
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
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.