Solved

Split database, Why is it still 11 meg big?

Posted on 2000-03-28
5
164 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

756 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