Different Database

I have two databases one is active the other is HIstory data. I need a command button or link or some sort of interface to the other database. Can that be done with a trigger or stored procedure?? How would I go about doing that in (has an access interface, sql engine)You would do it the same way you build an interface to the production system. I guess I'm confused about what you are asking.