• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 172
  • Last Modified:

Split database, Why is it still 11 meg big?

Hey all I just split my access db and the size has not really changed that much.  I have maybe around 5-6 forms and a total of 8-10 querys it there.  Before I split the db it was around 11 meg, after the split it is still around 11 meg.  I dont understand it at all.  What I need is to bring the size down to a couple of megs at the most.  I am using SQL 7.0 for the back-end.  What can I do?

Thanks,
Drug dealer
0
ASP_DRUG_DEALER
Asked:
ASP_DRUG_DEALER
  • 3
  • 2
1 Solution
 
BrianWrenCommented:
Compact, compact, compact...

Brian
0
 
BrianWrenCommented:

Remove the code from behind forms where code is not needed.  (Has Module = No)

Remove comments, etc., from existing code.

(Compacting should bring it down, if it only has the elements you say it does in the question...)

Brian
0
 
ASP_DRUG_DEALERAuthor Commented:
Holy Cow!  It went for 11meg to 1.2 meg!  You the man Brian!

Thanks,
Drug dealer.
0
 
ASP_DRUG_DEALERAuthor Commented:
The Man!
0
 
BrianWrenCommented:
1.2 million bytes can't be wrong . . .
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now