Database Architecture

[Shree]

Hello!
I have a database design / architecture question.
I have a large database which has forms for user input.
There are about 10 different forms that have various
different fields to feed about 7 different tables in the
backend database. (The database is split and the front end
is an mde )
This database is already about 200MB. The users also need
about 10 to 15 different reports from this database.
Should I design a different database for reports and link
the tables with this one? I think the size of the existing
datase will blow up when I add more objects like reports
to it. Please advice as to how I should handle this
situation. Thanks in advance.
Shree.

 

[John Vinson]

This database is already about 200MB. The users also need
about 10 to 15 different reports from this database.
Should I design a different database for reports and link
the tables with this one? I think the size of the existing
datase will blow up when I add more objects like reports
to it. Please advice as to how I should handle this

<checking>

One of my databases has 96 Forms and 124 Reports. It's largish for a
frontend, 13MByte, but works fine.

Compact your frontend (which should be routine maintenance); remove
any Pictures that arent' absolutely essential, they cause severe
bloat; and don't worry about it.

 

[Guest]

Thanks for your email.
The front end is about 7 MB. So you think it will be ok
just to add a switchboard with a list of all the needed
reports for the users to get ,whenever they want them?

 

[Guest]

Thanks a lot for your email.
The front end I have is about 7MB. Is there a way I can
automate the compact and repair for both front and
backends routinely? Its Access 2000 . I know 2002 does it
on open (you can set it to).
Thanks!
Shree

 

[Albert D. Kallal]

The front end is only 7 mb, how large is the back end after a compact?

I mean, a database with 100,000 records is only going to be about 10, or 15
megs. Do you really have that many records in the back end?

You are not storing pictures or somthing else you are not telling us about?