borderAndreaVB free resources for Visual Basic developersborder
AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2016 Andrea Tincani

AndreaVB Home | News Home | Forum Home | Downloads | Register | Search | PM | Profile

Previous Topic (FTP)Next Topic (Networking Router) New Topic Post Reply
AndreaVB OnLine : Network : Database Sharing Update
Poster Resource
qwerty018
Level: Trainee

Registered: 21-11-2008
Posts: 3
icon Database Sharing Update

I have a problem in

having 2 computers w/c uses peer-to-peer named PC1 and PC2

the problem is

once i updated the database in PC1

PC2 does not recognize the update and still remains with the old database

please help me

i need to do this...

21-11-2008 at 03:12 AM
View Profile Send Email to User Show All Posts | Add Comment
GeoffS
Level: Wizard


Registered: 29-09-2004
Posts: 643
icon Re: Database Sharing Update

For "shared" Database tables the usual method is to split your database into a "Frontend" containing all the "user" parts - Forms, Reports, etc. and a "Backend" containing just the data tables.
You need to decide which one of your computers is going to hold the "Live" data and place the "Backend" database in a shared folder on this computer, then Link all the "Frontend" databases to the "Backend" tables. Once you have done this all changes to the data will be seen by all users.
The precise mechanics of how you link the tables will vary according to the database program that you are using, if you are using Microsoft Access it is very easy, just open your Frontend database, on the main menu go to "File" select "Get External Data", choose "Link Tables" and just follow the instructions.


____________________________
multi-tasking - the ability to hang more than one app. at the same time.

21-11-2008 at 09:22 AM
View Profile Send Email to User Show All Posts | Add Comment
qwerty018
Level: Trainee

Registered: 21-11-2008
Posts: 3
icon Re: Database Sharing Update

sir geoff

how can i do the things u said above?

21-11-2008 at 11:57 AM
View Profile Send Email to User Show All Posts | Add Comment
GeoffS
Level: Wizard


Registered: 29-09-2004
Posts: 643
icon Re: Database Sharing Update

Hi,
Without knowing which database you are using I cannot give any more information than I already have. IF you are using MS Access then typing "split" or "Link Tables" into the Access Help will give you lots of assistance on this. Also, take a look at Microsoft support at http://support.microsoft.com/kb/304932/en-us



____________________________
multi-tasking - the ability to hang more than one app. at the same time.

27-11-2008 at 08:03 AM
View Profile Send Email to User Show All Posts | Add Comment
qwerty018
Level: Trainee

Registered: 21-11-2008
Posts: 3
icon Re: Database Sharing Update

i'm using MS Access 2007 and i cant seem to find the link table properties

01-12-2008 at 03:10 PM
View Profile Send Email to User Show All Posts | Add Comment
GeoffS
Level: Wizard


Registered: 29-09-2004
Posts: 643
icon Re: Database Sharing Update

Use the Link to the Microsoft Support Article that I put in my last post - it tells you there exactly what to do for your version of Access



____________________________
multi-tasking - the ability to hang more than one app. at the same time.

02-12-2008 at 11:32 AM
View Profile Send Email to User Show All Posts | Add Comment
AndreaVB OnLine : Network : Database Sharing Update
Previous Topic (FTP)Next Topic (Networking Router)New Topic Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
borderAndreaVB free resources for Visual Basic developersborder
borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2016 Andrea Tincaniborder