Solved

Split database, Why is it still 11 meg big?

Posted on 2000-03-28
5
161 Views
Last Modified: 2012-06-27
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
Comment
Question by:ASP_DRUG_DEALER
  • 3
  • 2
5 Comments
 
LVL 9

Accepted Solution

by:
BrianWren earned 100 total points
ID: 2665158
Compact, compact, compact...

Brian
0
 
LVL 9

Expert Comment

by:BrianWren
ID: 2665169

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
 

Author Comment

by:ASP_DRUG_DEALER
ID: 2665191
Holy Cow!  It went for 11meg to 1.2 meg!  You the man Brian!

Thanks,
Drug dealer.
0
 

Author Comment

by:ASP_DRUG_DEALER
ID: 2665194
The Man!
0
 
LVL 9

Expert Comment

by:BrianWren
ID: 2665357
1.2 million bytes can't be wrong . . .
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now