Mass copying of table, query and report templates on annual basis

We use Access 97 and each maintain databases with multiple tables, queries
and report templates. Each year we have to copy each account's table, then
query, then report structure . This is quite time consuming! Is there a
shortcut or way of mass duplicating this imformation?

Why are you doing this? Why not just add a year field to your tables, and
not bother creating new databases each year?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)


"JenB" wrote in message
...
We use Access 97 and each maintain databases with multiple tables, queries
and report templates. Each year we have to copy each account's table, then
query, then report structure . This is quite time consuming! Is there a
shortcut or way of mass duplicating this imformation?

This sounds like the set-up one of my clients had when I
first did some work for this client. The client has over
250 databases, one for each of his customers.

It is a wrong set up, though. It is more appropriate to
consolidate all data into one MDB file in general. You
will need to add extra Fields/Tables to "classify" Records
in the consolidated MDB file so that you can select
Records the way your office works. For example, you may
want to add the Field "TransYear" (or "TransDate") in your
Tables so that you can select Records by year (or date).

Unfortunately, this may take some time for you to re-
design / modify the Tables and consolidate the data as
well as queries and Reports.

HTH
Van T. Dinh
MVP (Access)


-----Original Message-----
We use Access 97 and each maintain databases with
multiple tables, queries
and report templates. Each year we have to copy each
account's table, then
query, then report structure . This is quite time
consuming! Is there a
shortcut or way of mass duplicating this imformation?
.

Doug-

Each fiscal year we have to carryover allocations and
balances from the previous year. We then use the new query
and report to track current year expenses. Some allocations
are not depleted in a year and while created in, say 2001,
may extend to 2004. We already use date fields for
reference purposes but if we were to rely on this for
report purposes, wouldn't we exclude old- but still viable-
records?




-----Original Message-----
Why are you doing this? Why not just add a year field to
your tables, and
not bother creating new databases each year?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)


"JenB" wrote in message
...
We use Access 97 and each maintain databases with
multiple tables, queries
and report templates. Each year we have to copy each
account's table, then
query, then report structure . This is quite time
consuming! Is there a
shortcut or way of mass duplicating this imformation?


.