My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Two Dbases contain same table, update 2nd dbase tbl from 1st?
|
|
 Jul 17 2006, 01:14 PM
Post
#1
|
|
|
UtterAccess Addict Posts: 217  |
There are two databases on a network drive. The one database is tied to the administrators who enter new employees into a UserTable. The other database uses the same exact UserTable but of course doesn’t get updated like the table in the admin database unless we do a ‘get external data’ and copy and paste the updated UserTable to the second database.
Is there a way to update this UserTable in Database2 with the one in Database1? |
 |
 
|
|
Jul 17 2006, 01:19 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 13,031 From: Leicester, UK |
Remove the table from database 2 and create a linked table to the table in database 1
|
|
|
|
|
Jul 17 2006, 01:31 PM
Post
#3
|
|
|
UtterAccess Addict Posts: 217 |
I'm sorry I never did anything like this, involving 2 databases, how to I go about creating a linked table? Any helpful web links? THanks for the quck reply.
|
|
|
|
|
Jul 17 2006, 05:18 PM
Post
#4
|
|
|
UtterAccess VIP Posts: 13,031 From: Leicester, UK |
Go to to database 2, select the tables section in the database window. Right click and select Link Tables, browse for database 1, select the table.
Then as soon as a edit/delete/addition to the data in database 1 it is in database 2 as well. |
|
|
|
|
Jul 18 2006, 06:37 AM
Post
#5
|
|
|
UtterAccess Addict Posts: 217 |
Ok, sounds easy, thats a great help.
Thanks. |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 20th June 2013 - 04:10 AM |