L
Lana
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
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