Access 2007 File Size

G

Glen CBC

The database has been in the 2007 format for about 6 months. Do regular
compact and repairs. The size has been around 160,000. Within a week it
jumped to 240,000.

Just converted from 32 bit to 64 bit. Don't see how that would have any
affect.

Have a dozen primary files and none of them have increased in size enough to
justify this big jump. The compact and repair is being done on the server,
however when I copy it to my C drive and do the compact and repair... there
is no resulting difference in size.

By the way someone left a cool suggestion about using KarenWare's Replicator
or QuikSync to back up on an hourly basis. Whoever posted this. Thanks!
This has been a worry for a long time. Any other suggestions?
 
T

Tom van Stiphout

On Sun, 27 Jul 2008 18:35:22 -0700, Glen CBC

Worry about something else, and allow Access in its infinite wisdom to
compact the db for you :)

-Tom.
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Size of RTF increasing 10x after minor edit 0
Database Size 13
reduce Access 2007 database size 6
Size of database keeps growing. 3
Problems Compacting Access in Office 2007 16
Access 2007 "compact and repair" asking password 0
Access database suddenly huge 1
Access 2007 Compact and Repair does nothing 3

Top