By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,761 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

My DB is 2GB and won't come down!

P: n/a
I know the 2 GB file size limit in Access, and my database apparently
has hit it. My problem is, I've gone and deleted tables that contained
old data, but when I check file size again, it reports exactly the same
size! I even made a copy of it, and deleted tables that I know were
the larger tables, yet I still get the same file size. I checked it in
DOS as well....still the same. Is there some sort of cleaning routine
I can do to get this fixed? There are no forms, no reports, just
tables.

May 10 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
> I know the 2 GB file size limit in Access, and my database apparently
has hit it. My problem is, I've gone and deleted tables that contained
old data, but when I check file size again, it reports exactly the same
size! I even made a copy of it, and deleted tables that I know were
the larger tables, yet I still get the same file size. I checked it in
DOS as well....still the same. Is there some sort of cleaning routine
I can do to get this fixed? There are no forms, no reports, just
tables.


Hi, sounds like you need to compact the database to retrieve the used space.
In Access 97 this is in Tools | Database Utilities | Compact....not sure
about later versions though.

Alan
May 10 '06 #2

P: n/a
Close enough for me (Access 2000). However, Access keeps telling me
that I have already exclusively opened it, so it can't compact it. I
have one instance of Access open, and I give the command to compact the
database without opening it (straight from the Access opening menu).
No open tasks or processes refer to MS Access if I close it down, so I
don't know how to release my "exclusive open" on the database.

(Just FYI, I'm also trying to clear duplicate rows out of another
table, but I run into another known Access bug when running a INSERT
INTO .... SELECT DISTINCT * query. I can't wait until I get to do
something in Access that works.)

May 10 '06 #3

P: n/a
>However, Access keeps telling me
that I have already exclusively opened it, so it can't compact it. I
have one instance of Access open

You sure about the above? I would close down ms-access, and re-boot your
computer......

Then open the mdb file, and then use the tools->compact...

If you still can't compact, then I would exit ms-access, and look for a ldb
file..and delete it...

So, you do open the mdb file regular way (assuming there is no startup form,
or startup code)...

You then should be able to compact....

If you can't compact, you can create a blank mdb file..and then go file->get
external data..and import everything.....

I would try and determine why you can't compact. When *developing* code, I
compact several times daily.....
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal
May 10 '06 #4

P: n/a
"Albert D. Kallal" <ka****@msn.com> wrote in
news:bn78g.143329$7a.33553@pd7tw1no:
If you can't compact, you can create a blank mdb file..and then go
file->get external data..and import everything.....


The JetCompact utility is also an option. It can sometimes compact
MDBs that are prevented by their corruption from being opened in
Access.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
May 10 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.