Move data to another database

P

pokdbz

Is it possible to move data to a seperate database by a click of a button?
So if I enter a customers information into one database when I click save
can it save the information into the current database and also save the same
information into a 2nd database?
 
R

Rick B

You could save the data to a linked table (which lives in another database)
but why? Just store the data in one database and link to that table from
any other databases that need to use the data. Why duplicate the data and
end up with two records to maintain?

Rick B
 
P

pokdbz

They need it to go to another database to do something else with it. So is
it possible to click on something to send the data to another database and
how would this be done?
 
R

Rick B

Again, yes, if you link the table in your database.

You still seem to be missing the point. If you store customer data in a
table, you can use that data in a hundred other database files. You seem to
be confusing databases and tables. I have one table in a back-end database
that stores my customer information. There is a database in the accounting
office that links to this table and uses the customer data when writing
checks, paying bills, billing customers, etc. There is another database in
my shipping and recieving department that does a totally different function,
BUT they still link to that same customer table. If accounting corrects an
address or phone number, we don't want S/R to not have it. We have a THIRD
database in our Software Training Department (again, it links to the same
customer table.)

Hopefully that will help you see the light of sharing that TABLE between
multiple DATABASES.

Rick B
 
P

pokdbz

Ok I get what you are saying. Linked tables won't work I don't think becasue
they are still looking at the same data from one back end. But the way they
want this to work is they need a seperate back end with the same information
as the first database. They need to do this for a special reason, I guess
not to taint the original data. I am just trying to figure out a way
evertime something is entered into the first one to copy it over to the 2nd
database.
 
J

John Vinson

Ok I get what you are saying. Linked tables won't work I don't think becasue
they are still looking at the same data from one back end. But the way they
want this to work is they need a seperate back end with the same information
as the first database. They need to do this for a special reason, I guess
not to taint the original data. I am just trying to figure out a way
evertime something is entered into the first one to copy it over to the 2nd
database.
Click to expand...

Well...

You can't have it both ways.

If you store data redundantly, then you have no choice - you are
storing the data in two places, so you must update it in two places,
somehow. You either need to redo the edits in the second database, or
periodically destroy the second database and generate a new copy.

If both databases are in active use, then this could be very, very
difficult!

John W. Vinson[MVP]
 
Top