? how can i get my vb-2008 program to work on a peer-to-peer network ?

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
<p style=" <span style="font-size:14pt -- i have a working vb-2008 program that i would like to network.
<p style=" <span style="font-size:14pt -- the program (adds/changes/deletes) records in a microsoft (2002) access database.
<p style=" <span style="font-size:14pt
<p style=" <span style="font-size:14pt .. i have an (xp-home) desktop and an (xp-pro) laptop networked thru a router.
<p style=" <span style="font-size:14pt .. i used the network setup wizard to network the 2 pcs.
<p style=" <span style="font-size:14pt .. i set up a shared folder on my desktop which contains the access database.
<p style="
<p style=" <span style="font-size:14pt -- my vb program is installed on both machines.
<p style=" <span style="font-size:14pt -- from either pc, using my vb program, i can open and work with the database that is on the desktop.
<span style="font-size:14pt -- but if both pcs are running my vb program, it is like each pc is working with a copy of the database. if (on one pc) i add a new record to the database the new record does not show on the other pc.
<span style="font-size:14pt -- if i close both programs and then run the program on either machine alone, it shows the latest changes to the database.

<span style="font-size:14pt .. if i right-click the shared folder and chose (sharing and security), both (share this folder) and (allow network users) are checked.
<span style="font-size:14pt .. if i go to (folder options) (view tab) .. (use simple file sharing) is checked.

<span style="font-size:14pt -- the database connection string in the program is --
<span style="font-size:14pt Provider=Microsoft.Jet.Oledb.4.0; Data Source= C:MySharedFolderDbX.mdb

<span style="font-size:14pt ?? any idea why the program wont network ?

<span style="font-family:Times New Roman; font-size:14pt thanks

View the full article
 
Back
Top