Solved

Split database, Why is it still 11 meg big?

Posted on 2000-03-28
5
162 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

776 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