use data from other DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have 2 Databases which have some similar data, like "Client's Name" &
"Client's No" for expample. (I had to make 2 separate DBs as one of them has
the data with restricted access.)

Now I am looking for a way to avoid doing double job adding new Client's
Names to both Databases manually. - So that I would enter new data only in DB
"A" and will be able to use that new data in DB "B" as well.

If it is possible, then I believe I have to make a querry which will connect
2 databases and call the data from a table of DB "A" to make a table in DB
"B". (Which will look for new data every time I open DB "B".)

Hotestly, I have no idea how to to that in practice. I tried "Make-table
Querry", but insuccessfuly. I am not good at SQL, and the "Help" in Access
2002 was not very friendly with me neither.

Can somebody help me?

Thank you.
Lana
 
Lana,

You can just link the table in bd A into db B, so both bd's share one
table; this means all data entered / modified (or deleted) form within
either database is instantly available to both.
To link a table, while in database B go File > Get External Data > Link
Tables.

HTH,
Nikos
 
Wow!!!
Thank you Nikos!
It WORKED!!!!

Nikos Yannacopoulos said:
Lana,

You can just link the table in bd A into db B, so both bd's share one
table; this means all data entered / modified (or deleted) form within
either database is instantly available to both.
To link a table, while in database B go File > Get External Data > Link
Tables.

HTH,
Nikos
Click to expand...
 
Back
Top