copy queries and reports

  • Thread starter Thread starter northstar
  • Start date Start date
N

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?
 
northstar said:
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?
Click to expand...

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
 
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.
 
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.
Click to expand...

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.
 
Back
Top