There might be easier way, but I would use ODBC. Set up an ODBC source on each of the computers (Start -->control pannel --> Administrative Tools --> Data Sources). In there you can set the IP address of the computer that hosts the database. If your VB program does not currently use ODBC you will have to change that too.
Last edited by Ancient Dragon; Dec 13th, 2006 at 7:00 pm.
Sponsor
Team Colleague
Featured Poster
Reputation Points: 5608
Solved Threads: 2282
Retired and Enjoying Life
Offline 21,950 posts
since Aug 2005