Solved

Split database, Why is it still 11 meg big?

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
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…
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…
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.

739 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