How to connect DB in Lan Connection?

[JC KaNNaN]

hi, i did simple db connect with server and client across LAN. actually i pass connection string from global file. how to give server location for client side during run time. or give some other suggestion. plz

Yours, KaNNaN ----------------------------------------------------------------- "Success is When Ur Signature Becomes An Autograph" Mail To : foreverkans@gmail.com

[Lost User]

We used to connect to the MS Access file through the network. What you need is the shared folder over a LAN where DB file is placed Now to access the file give path as \\<IP Address>\<Folder Name>\<File Name>

Regards Aman Bhullar www.arlivesupport.com[^]

[Dave Kreskowiak]

All you do is change the connection string to reflect the name of the new server. It's nothing more than simple string manipulation. You can create your connection string with a well-known tag in place of the server name, then just search for and replace the tag in the string with the name of the server. The result is your updated connection string.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008

[loid grey manuel]

well, i have a similar issue that i am working on. maybe this will work on Win XP OS's.. but i tried it on my Win Vista and 7, i get an error that says. cannot open DB, restrictions are blah blah blah..you do not have enough permission. but the folder/file is shared with full read/write control. even in my Xp workstation, sometimes i get the same error. maybe because there are a lot of computer trying access the db simultaneously? any ideas on Win Vista and 7?