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

you need to repair and compact the database.

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

-doodle

Tried that but still gets bloated
Tony
"doodle" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> you need to repair and compact the database.
>
> Tools - Database Utilities - Repair Database
> Tools - Database Utilities - Compact Database
>
> -doodle
>

Tony Williams wrote:
> 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.

--
Joseph Meehan

Dia 's Muire duit

On Tue, 16 Jan 2007 16:56:56 -0000, "Tony Williams" <(E-Mail Removed)>
wrote:

>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]

No there aren't any pictures in there
Odd???
Tony
"Joseph Meehan" <(E-Mail Removed)> wrote in message
news:45ad199a$0$16936$(E-Mail Removed)...
> Tony Williams wrote:
>> 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.
>
> --
> Joseph Meehan
>
> Dia 's Muire duit
>
>
>

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
"John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:(E-Mail Removed)...
> On Tue, 16 Jan 2007 16:56:56 -0000, "Tony Williams" <(E-Mail Removed)>
> wrote:
>
>>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]

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 Removed)


Tony Williams wrote:
> 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
> "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
> news:(E-Mail Removed)...
> > On Tue, 16 Jan 2007 16:56:56 -0000, "Tony Williams" <(E-Mail Removed)>
> > wrote:
> >
> >>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]

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
"Jerry Whittle" <(E-Mail Removed)> wrote in message
news:2E5BB4DC-2DCD-483F-B094-(E-Mail Removed)...
> Hi,
>
> I just created a copy of it and didn't see any obvious problems like
> cartisian joins in any of the queries plus I looked at most of the forms
> and
> reports.
>
> Q: What field names did you change? Have you created or modified any
> queries? What was running when it started to bloat?
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Tony Williams" wrote:
>
>> 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
>>
>>
>>