More on Database Bloat

  • Thread starter Thread starter M Taimanov
  • Start date Start date
M

M Taimanov

I saw the post "Xcessive Database Bloat" and FredG and
John Vinson's reply. I do not store, embed or have linked
images - I have a form with 3 fields, one being an image
control into which I load filenames using the standard
technique :

Me![ImageFrame].Picture = Me![OLEPathName] & Me!
[OLEFileName]

And I also noticed that this simple report caused my mdb
to grow by over 9mb.

And yes I compact all the time.

I am curious too.

Mark
 
I sound like a broken record, but take a look at Microsoft
Knowledge Base Article - 210100
Roxie Aho
 
Roxie - thanks for your reply - but did you actually read
what I wrote ? Article 210100 is well known to me - and if
you look below - I am using exactly that technique. I do
not use OLE object fields, I do not store images - I load
filenames into an unbound image control.

My question and that of Matthew Therrien is quite
different - why would a report with 2-3 fields add 9mb to
the size of a database ?

Regards

Mark
-----Original Message-----
I sound like a broken record, but take a look at Microsoft
Knowledge Base Article - 210100
Roxie Aho
-----Original Message-----
I saw the post "Xcessive Database Bloat" and FredG and
John Vinson's reply. I do not store, embed or have linked
images - I have a form with 3 fields, one being an image
control into which I load filenames using the standard
technique :

Me![ImageFrame].Picture = Me![OLEPathName] & Me!
[OLEFileName]

And I also noticed that this simple report caused my mdb
to grow by over 9mb.

And yes I compact all the time.

I am curious too.

Mark
.
Click to expand...
.
Click to expand...
 
Drop a line to Stephen Lebans.
He is the expert on Access and images.
www.lebans.com
--
Joe Fallon
Access MVP



M Taimanov said:
Roxie - thanks for your reply - but did you actually read
what I wrote ? Article 210100 is well known to me - and if
you look below - I am using exactly that technique. I do
not use OLE object fields, I do not store images - I load
filenames into an unbound image control.

My question and that of Matthew Therrien is quite
different - why would a report with 2-3 fields add 9mb to
the size of a database ?

Regards

Mark
-----Original Message-----
I sound like a broken record, but take a look at Microsoft
Knowledge Base Article - 210100
Roxie Aho
-----Original Message-----
I saw the post "Xcessive Database Bloat" and FredG and
John Vinson's reply. I do not store, embed or have linked
images - I have a form with 3 fields, one being an image
control into which I load filenames using the standard
technique :

Me![ImageFrame].Picture = Me![OLEPathName] & Me!
[OLEFileName]

And I also noticed that this simple report caused my mdb
to grow by over 9mb.

And yes I compact all the time.

I am curious too.

Mark
.
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top