|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 16th, 2005, 02:11 PM
|
|||
|
|||
how do you combine or link several access databases ?
how do you combine or link several access databases ?
I want to be able to add information once into the database and it is updated into the other databese. If I can combine I will be really happy. It is access 97. 
|
|
#2
March 16th, 2005, 02:36 PM
|
|||
|
|||
|
You can create links to tables that are contained in other MDBs.
-- Duane Hookom MS Access MVP -- "joe1sawyer" wrote in message ... how do you combine or link several access databases ? I want to be able to add information once into the database and it is updated into the other databese. If I can combine I will be really happy. It is access 97.
|
|
#3
March 16th, 2005, 06:19 PM
|
|||
|
|||
|
please explain forther. I don't know how to create links.
"Duane Hookom" wrote: You can create links to tables that are contained in other MDBs. -- Duane Hookom MS Access MVP -- "joe1sawyer" wrote in message ... how do you combine or link several access databases ? I want to be able to add information once into the database and it is updated into the other databese. If I can combine I will be really happy. It is access 97.
|
|
#4
March 16th, 2005, 06:31 PM
|
|||
|
|||
|
On Wed, 16 Mar 2005 06:11:04 -0800, "joe1sawyer"
wrote: how do you combine or link several access databases ? File... Get External Data... Link. I want to be able to add information once into the database and it is updated into the other databese. If I can combine I will be really happy. It is access 97. Well... DON'T. Storing the same data redundantly in multiple tables, whether in the same or a different database, is *very* rarely a good idea. Could you explain what these databases are, and why you feel that having information in one database "updating" information in another database is necessary? John W. Vinson[MVP]
|
|
#5
March 16th, 2005, 06:52 PM
|
|||
|
|||
|
Press F1 and ask the Answer Wizard "how do I link a table"
-- Duane Hookom MS Access MVP "joe1sawyer" wrote in message ... please explain forther. I don't know how to create links. "Duane Hookom" wrote: You can create links to tables that are contained in other MDBs. -- Duane Hookom MS Access MVP -- "joe1sawyer" wrote in message ... how do you combine or link several access databases ? I want to be able to add information once into the database and it is updated into the other databese. If I can combine I will be really happy. It is access 97.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| is Access 2003 any better than XP? | Gorb | Using Forms | 2 | November 11th, 2004 09:20 AM |
| Adding staff photographs to my database | KK | New Users | 2 | September 3rd, 2004 07:41 AM |
| What is MDE | Charlie | General Discussion | 4 | August 24th, 2004 04:15 PM |
Linear Mode
