Network Programming In VB

Hi

I developed a standalong application with VB using an access DB with ODBC database connection.

Now if i have to store the DB in PC01 & have to run the application from PC02,PC03 & PC04.

How can I do that , Any Help Please. :cry:

Can Contect me personally at www.solutiononline.org
or mail me at 'pratikdutta at solutiononline dot org'

use the package & deployment wizard to create a setup program that will install all the necessary file on any PC. It comes with VB6.

Quote:

---

Originally Posted by pratikdutta

Hi

I developed a standalong application with VB using an access DB with ODBC database connection.

Now if i have to store the DB in PC01 & have to run the application from PC02,PC03 & PC04.

How can I do that , Any Help Please. :cry:

Can Contect me personally at www.solutiononline.org
or mail me at 'see above post'

---

First off do not include you email in your post you will recieve lost of spam.

Secondly assumign the standalone app can connect to the db via a network? have a look here for installer
http://www.vbforums.com/showthread.php?t=315829

Let me know if that helps

Quote:

---

Originally Posted by Pino

First off do not include you email in your post you will recieve lost of spam.

---

Don't forget to edit the one in the quote too ;)

You'll need the DBMS to act as a server to be able to connect to it over a network. Access is really bad at this, as soon as you have more than one concurrent connection it often struggles and crashes :(.

If you want to do this then you should use Microsoft SQL server or MySql server or Oracle. These DBMS' are built to handle many concurrent connections from other PC's.

Should you still want to use access then have a look at these:

http://livedocs.macromedia.com/coldf...tasources8.htm
http://support.microsoft.com/kb/253580
http://msdn.microsoft.com/library/de...ccessguide.asp
http://support.microsoft.com/?kbid=209091