Extremely Hard Task

Here is my problem:
I am almost complete with my application...I have several databases for different sections...What I am going to do is link all of them together to make one large database but here is where it gets tricky:

I would like to install my software on 3 computers that are linked together. All users no matter what computer they use will be able to add or modify my DB using my software. Can this be done. If I can be, please present me with the method, I will research..Thanks

If you are using Access and your computers are networked linked (i.e. you can have a shared drive) then:

1) Place you 3 main databases on one of the computers.

2) Create a new database (call it a composite database for want of a better name) and set up <B>Linked Tables</B> back to all three main databases. This way you have <I>one</I> database made up from the three

3) Place the new composite database on each computer with your app.
(Of course you should actually do the linking on each computer to make sure your network path is correct. Alternatively, make the same network drive point to your data on each computer and then you wont have to worry about relinking for each computer after you get the first one right.)

4) Make your app relate to the composite database tables on each local computer. (i.e. open this database in your app, not the main three.)


HTH

<font color=blue>Better to remain a fool than write a quote and remove all doubt. (****!!)</font color=blue>

Thanks a billion! I greatly appreciate your help!

James