Bloated database

[Tony Williams]

I have a database which is based on the Microsoft template Time and Billing
I haven't changed much apart from some field names. The database is about
24mb but after I've used it for a while it swells to 400mb and slows down.
Anyone any idea why this happens?
Thanks
Tony

 

[doodle]

you need to repair and compact the database.

Tools - Database Utilities - Repair Database
Tools - Database Utilities - Compact Database

-doodle

 

[Tony Williams]

Tried that but still gets bloated
Tony

 

[Joseph Meehan]

I have a database which is based on the Microsoft template Time and
Billing I haven't changed much apart from some field names. The
database is about 24mb but after I've used it for a while it swells
to 400mb and slows down. Anyone any idea why this happens?
Thanks
Tony

It does not have photos in it does it. OK it does not sound likely, but
I thought I would ask.

 

[John Vinson]

I have a database which is based on the Microsoft template Time and Billing
I haven't changed much apart from some field names. The database is about
24mb but after I've used it for a while it swells to 400mb and slows down.
Anyone any idea why this happens?
Thanks
Tony

I haven't used that template, but do you use a lot of temporary
tables, either make-table or append and then delete or empty? This can
eat a lot of disk.

John W. Vinson[MVP]

 

[Tony Williams]

No there aren't any pictures in there
Odd???
Tony

It does not have photos in it does it. OK it does not sound likely,
but I thought I would ask.

 

[Tony Williams]

Hi John as far as I can see not here aren't any temporary tables. I was
using it for about 15mins and it got up to over 700mb!!! I have Compact and
repair on close so it came down again but after a while went back up again.
Really odd
Tony

 

[aaron.kempf]

dude lose the training wheels.. converting a simple MDB like a
template-- into an ADP would probably take me less than 10 minutes

MDB always bloats
these ****ing retards around here are propping up an obsolete format

don't listen to these ****nuts; fire anyone that is using MDB and email
it to me... I'll proabbyl be AT your doorstep in a half hour with a
freeware scalable, dependable SQL Server SOLUTION to your bloatware

-Aaron
(e-mail address removed)

 

[Tony Williams]

Hi Jerry I changed all the field names from "Hours" to "days" and created
added a table to create some invoice information, a query based on that and
a report. I used the same items under Access 2000 and no problem but with
2003 it just keeps growing till I close it!!
Really odd
Tony