copy queries and reports

[northstar]

If I make new queries and reports in a copy of the original db can I copy and
paste them into the original db or do I have to build them in the original?

 

[Philip Herlihy]

If I make new queries and reports in a copy of the original db can I copy and
paste them into the original db or do I have to build them in the original?

Back up the original database as a precaution (File -> Backup). Then,
in the copy DB, select the query, form or report and pick File ->
Export. Select your original database, and you're done. Make sure you
export everything you need (think dependencies), like the query that a
report depends on.

Of course, if you have your database correctly split, so that the
back-end has only tables (with relationships defined), then there's no
reason why you can't have separate front-ends for different groups of
functions.

Phil, London

 

[northstar]

Thanks very much. The db is split and I want to be able to create queries and
reports, some to all fe users and some to selected users.

 

[John W. Vinson]

Thanks very much. The db is split and I want to be able to create queries and
reports, some to all fe users and some to selected users.

In that case you have a very good case for having separate frontends for the
selected users. If the reports exist in all of the users' frontends, it will
be much harder to reliably conceal them from people who shouldn't see them.