How Free Up Size when Delete Tables?

[Al Franz]

Have an Access 2007 data base that is getting close to the 2 Gig limit. I
deleted some tables but did not regain the bytes. Is there a tool or
process to clear out this unused space so my file size will decrease?

 

[Dirk Goldgar]

Have an Access 2007 data base that is getting close to the 2 Gig limit. I
deleted some tables but did not regain the bytes. Is there a tool or
process to clear out this unused space so my file size will decrease?

Have a backup copy saved, just in case. Then click Office button ->
Manage -> Compact and Repair Database.

 

[Al Campagna]

Al,
It's in Office/Manage. That's the Microsoft icon in the upper right of
the Access screen.

I've seen some issues regarding 2007 C&R, so backup before using.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[a a r o n _ k e m p f]

sql server shrinks the database automatically.

it works like a charm.

and the free version has a 4gb limit; not a mere 2gb limit.
and all databases are automatically linked to each other (where
permitted with enterprise level security)

jet is obscene for that much data

 

[a a r o n _ k e m p f]

if your database is bloated, move to one where you don't have to deal
with the hassle.

it's called 'enterprise ready'

either your database _IS_ or it _IS_NOT_.

Yah.. anyone with a clue knows that SQL Server is always always always
faster and cheaper than MS Access (JET).
More importantly; it is less risky because you do not have data
corruption.

Can _JET_ even prevent people from using unicode characters?

 

[a a r o n _ k e m p f]

personal environment.. corporate environment.. well if you download vb
2005 express onto any old desktop-- you have a fast free SQL Server

case closed