Connect a report to a table in a diff database

[crobaseball]

I've got an interesting situation. I need to have a sales force be able to print out a report. And naturally, I don't want them to have any access (pun intended) to the database. The db is constantly changing, so consistently putting locks on tables/queries/other reports is a pain. Basically, I want the report to "live" elsewhere and be connected to the master db. I was thinking the logical thing was to have a report which only lived in a separate db, but was connected to my data in the "master".



1.) Can this be done?

2.) Is this the right way to go about it?

Thanks!

[crobaseball]

Never mind, I just import the data. Duh. It's Friday. I need a beer

[orange]

You could LINK to the data vs IMPORT.

[crobaseball]

That's what I meant . . . so it would be dynamic

[crobaseball]

Wait, when I link the data, is there a way to make it "Read only", so that I can't make changes?