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
|
|||
|
|||
Lining tables between databases - HELP!
Hi guys, I'm hoping someone can help me with this one;
Currently we have a training database listing employee names and all training undertaken while they have been in the company (generic training really, H&S, Management, Office Skills, etc). We now want to create a Key Skills Database which lists other information such as whether someone is trained on specific in house equipment (e.g. an industrial blender), analytical methods, etc (can you guess I work in a Lab?) - the rationale is that any member of staff will be able to access the database if they need help with a specific method / piece of equipment and find out who is trained and to what level so they can go to them for help. As the training database and key skills database will have the common factor of employee names, I want to link the employee list from the training database to the key skills database. Ideally, I would also like to be able to access information from the training database and incorperate that into queries. As the training database is rather large already, and also rather important we want to keep them seperate. My questions are these; 1. Would I need to replicate the 'Employee' table in both databases, or can I use one table for both databases? 2. Can I link tables so that I can use information from one database in a query in a second database? 3. How do I link tables?! (I have looked through office online and I can only find information for ADP, not MDB files). I hope this makes sense and thanks in advance, Astrid x |
#2
|
|||
|
|||
Lining tables between databases - HELP!
Also, you can use the linked table manager to refresh as needed. You don't
need to duplicate tables, just write queries off the linked tables. "Astrid" wrote: Hi guys, I'm hoping someone can help me with this one; Currently we have a training database listing employee names and all training undertaken while they have been in the company (generic training really, H&S, Management, Office Skills, etc). We now want to create a Key Skills Database which lists other information such as whether someone is trained on specific in house equipment (e.g. an industrial blender), analytical methods, etc (can you guess I work in a Lab?) - the rationale is that any member of staff will be able to access the database if they need help with a specific method / piece of equipment and find out who is trained and to what level so they can go to them for help. As the training database and key skills database will have the common factor of employee names, I want to link the employee list from the training database to the key skills database. Ideally, I would also like to be able to access information from the training database and incorperate that into queries. As the training database is rather large already, and also rather important we want to keep them seperate. My questions are these; 1. Would I need to replicate the 'Employee' table in both databases, or can I use one table for both databases? 2. Can I link tables so that I can use information from one database in a query in a second database? 3. How do I link tables?! (I have looked through office online and I can only find information for ADP, not MDB files). I hope this makes sense and thanks in advance, Astrid x |
#3
|
|||
|
|||
Lining tables between databases - HELP!
Sorry, I'm using Access 2003, but I'm glad that it can be done without
duplicating tables and information. Thanks guys, Astrid |
#4
|
|||
|
|||
Lining tables between databases - HELP!
Astrid
You don't mention which version of Access you are using, so the instructions are necessarily general... You will use "External" data commands and select "Link" rather than "Import"... You'll be given a way to select which source you want to link to... -- Regards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ "Astrid" wrote in message ... Hi guys, I'm hoping someone can help me with this one; Currently we have a training database listing employee names and all training undertaken while they have been in the company (generic training really, H&S, Management, Office Skills, etc). We now want to create a Key Skills Database which lists other information such as whether someone is trained on specific in house equipment (e.g. an industrial blender), analytical methods, etc (can you guess I work in a Lab?) - the rationale is that any member of staff will be able to access the database if they need help with a specific method / piece of equipment and find out who is trained and to what level so they can go to them for help. As the training database and key skills database will have the common factor of employee names, I want to link the employee list from the training database to the key skills database. Ideally, I would also like to be able to access information from the training database and incorperate that into queries. As the training database is rather large already, and also rather important we want to keep them seperate. My questions are these; 1. Would I need to replicate the 'Employee' table in both databases, or can I use one table for both databases? 2. Can I link tables so that I can use information from one database in a query in a second database? 3. How do I link tables?! (I have looked through office online and I can only find information for ADP, not MDB files). I hope this makes sense and thanks in advance, Astrid x |
#5
|
|||
|
|||
Lining tables between databases - HELP!
On Tue, 28 Oct 2008 05:52:02 -0700, Golfinray
wrote: Also, you can use the linked table manager to refresh as needed. You don't need to duplicate tables, just write queries off the linked tables. The linked table manager will work fine. But if you want a more automated approach to relinking tables, there are lots of free techniques out there, including our J Street Access Relinker at: http://www.jstreettech.com/cartgenie...rDownloads.asp Armen Stein Microsoft Access MVP www.JStreetTech.com |
Thread Tools | |
Display Modes | |
|
|