You can create view - base on table in another database - in new database.

MartinaJ

>Hello all...
>What would be the best way to use tables from a database into a new database?
>Im trying to improve an old application using the data already stored in it, but when I try to copy the old tables, even if I change their names, I get the message "Table could not be copied because it belongs to database suchandsuch"... (or something similar.)
>
>Thanks in advance