(Msg. 1) Posted: Mon Nov 10, 2008 7:49 pm
Post subject: Analyse Table creates Lookup tables and bloats the db Archived from groups: microsoft>public>access>tablesdbdesign (more info?)
I am playing around with an old database in Access 2007, and thought I
would use the Analyse Table function. So I had it to analyse one of my
tool type tables and it made an extra 7 tables, which seemed to become
lookup tables.
I than noticed that the 1.5mb database had grown to 45mb!
Anyway, after reading up about lookup tables etc, it would seem that it
is not a good idea to use them.
So, if this is true, why does Access 2007 create lookup tables during
the Analylse process, or have I got it all wrong?
(Msg. 2) Posted: Mon Nov 10, 2008 7:50 pm
Post subject: Re: Analyse Table creates Lookup tables and bloats the db [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Bob
Lookup tables are good, lookup datatype fields are bad ... not the same
thing.
Make a copy of the file, then run Compact & Repair. Access doesn't tidy up
well after itself.
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Bob H" <bob.TakeThisOut@despammer.com> wrote in message
news:gfa33k$20to$1@energise.enta.net...
>I am playing around with an old database in Access 2007, and thought I
>would use the Analyse Table function. So I had it to analyse one of my tool
>type tables and it made an extra 7 tables, which seemed to become lookup
>tables.
> I than noticed that the 1.5mb database had grown to 45mb!
> Anyway, after reading up about lookup tables etc, it would seem that it is
> not a good idea to use them.
> So, if this is true, why does Access 2007 create lookup tables during the
> Analylse process, or have I got it all wrong?
>
> Thanks
(Msg. 3) Posted: Mon Nov 10, 2008 8:50 pm
Post subject: Re: Analyse Table creates Lookup tables and bloats the db [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Jeff,
yes that made a difference. Compact and Repair squashed it down from
45mb to just under 2mb, amazing!
mmm, I guess I'll have to read up on lookup datatype and lookup tables then.
Thanks
Jeff Boyce wrote:
> Bob
>
> Lookup tables are good, lookup datatype fields are bad ... not the same
> thing.
>
> Make a copy of the file, then run Compact & Repair. Access doesn't tidy up
> well after itself.
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Bob H" <bob DeleteThis @despammer.com> wrote in message
> news:gfa33k$20to$1@energise.enta.net...
>> I am playing around with an old database in Access 2007, and thought I
>> would use the Analyse Table function. So I had it to analyse one of my tool
>> type tables and it made an extra 7 tables, which seemed to become lookup
>> tables.
>> I than noticed that the 1.5mb database had grown to 45mb!
>> Anyway, after reading up about lookup tables etc, it would seem that it is
>> not a good idea to use them.
>> So, if this is true, why does Access 2007 create lookup tables during the
>> Analylse process, or have I got it all wrong?
>>
>> Thanks
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other