software to shrink/compact database

[Marco]

hello.
I already had asked for solutions to shrink/compact my front-end database
and I tried several things but nothing so far.

Does anyone know any external good software to shrink access database?

my front-end has 185 after compacted after I import a few queries and forms.
the size was 30mb and now 185mb

Please help a desespareted man here.

Thaks,
Marco

 

[Daniel Pineault]

Try importing your db objects into a new db, then perform a compact and
repair. See if that helps.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Marco]

Hi,

I tried that. it was a suggestion of my last post about this subject but it
stays with the same size.

Thanks anyway.

Marco

 

[Tom van Stiphout]

On Tue, 25 Nov 2008 10:41:02 -0800, Marco

How come your FE was 30 MB? How many *tables* did it have? How many
objects of each category?

-Tom.
Microsoft Access MVP

 

[Marco]

Hi.

I run the access option "Performance" and onthe of the results was:

Aplication: the application is not saved in a fully compiled state

What is this and where can I change it to fully compiled state?


Thanks.
Marco

 

[John W. Vinson]

Hi.

I run the access option "Performance" and onthe of the results was:

Aplication: the application is not saved in a fully compiled state

What is this and where can I change it to fully compiled state?

Open the database; type Ctrl-G to open the VBA editor. Select Debug... Compile
<your database name here>.

Fix any compile errors and repeat until there are none.

After you're done, close VBA and Compact again.

 

[Marco]

Hi,

I've got many tables, queries, forms and reports.