Next Year

[Kirt M]

Tried this question under replication and was told to try
news groups?

We currently have a database for 2003. We would like to
create a 2004 and use it at the same time we are using
2003 at years end. Is there a simple way to do this with
a split database?

 

[Danny J. Lesandrini]

You can copy and paste the original database, rename it as 2004 and
delete the 2003 records ... but some day you will be sorry. Some day,
someone will ask, "How do 2003 sales compare with 2004?" Then you
will be back here, asking, "How do I combine data from two seperate
databases?"

If the year (that is, the date) is the only attribute that differs, then
find a way to keep all the data in a single file ... a single place. Add a
column with the YEAR attribute or give all the records a date field.

 

[Kirt M.]

Thanks

-----Original Message-----
You can copy and paste the original database, rename it as 2004 and
delete the 2003 records ... but some day you will be sorry. Some day,
someone will ask, "How do 2003 sales compare with 2004?" Then you
will be back here, asking, "How do I combine data from two seperate
databases?"

If the year (that is, the date) is the only attribute that differs, then
find a way to keep all the data in a single file ... a single place. Add a
column with the YEAR attribute or give all the records a date field.
--

Danny J. Lesandrini
(e-mail address removed)
http://amazecreations.com/datafast





.

 

[Roger Carlson]

It is a poor design to have separate databases for individual years. What
if you want to report across years?

Still, if you are not in a position to modify the design, it IS possible to
choose in the Front-end database which Back-end to connect to. On my
website (see sig below), there is a small sample database called
"LinkTables.mdb" which illustrates how to do this.