How Free Up Size when Delete Tables?

  • Thread starter Thread starter Al Franz
  • Start date Start date
A

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?
 
Al Franz said:
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?
Click to expand...


Have a backup copy saved, just in case. Then click Office button ->
Manage -> Compact and Repair Database.
 
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
 
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?
 
personal environment.. corporate environment.. well if you download vb
2005 express onto any old desktop-- you have a fast free SQL Server

case closed
 
Back
Top