Database Copy?

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

Guest

I have two databases that I want to keep the data exactly the same, but I
want to keep one database password protected for data integrity reasons.
When updates are made to the tables in the passworded copy (about 15 tables),
I want a method to export those tables to the unpassworded copy. I want the
existing tables in that version to be overwritten with the updated ones I am
exporting.

What is the easiest and best method for doing this quickly w/o having to
delete and import or do massive appending. I have a lot of tables and there
are existing relationships.
 
There's no easy way of doing what you describe.

I'd tackle the situation by implementing user-level securty to control who
can edit or see what data.
 
I tried that, but they way we did it required us to use passwords for every
database we opened not just that one database. Staff got annoyed with that
solution. How do I do user-level security that effects that database only
and not any access file I open?
 
I agree with John and add that you might want to check out replication also.
Sounds like you might be working too hard.
 
Back
Top