GeoffS Level: VB Lord

 Registered: 29-09-2004 Posts: 618
|
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.
|