Database Architecture

  • Thread starter Thread starter Shree
  • Start date Start date
S

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.
 
Is the front-end 200MB? Compact and Repair?

Adding a few reports should not increase the size of the db by any
substantial amount, unless there are tons of graphics on them.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
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
Click to expand...

<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.
 
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?
 
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
 
I don't see any problem with adding reports based on what you have
described.

For Compacting FEs, Tools>>Options>>General check the Compact on Close
checkbox.

backend has to be done when everyone is out, so automating it may be a
challenge.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
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?
 
Back
Top