Do OLE Objects make Database Get Bigger

[dvannoy]

Yesterday I compacted my Database it reached 1.0GB. Once compacted it dropped down to 16mb. Today it has already jummped back up to 350MB. I was reding on micosoft's web site something about OLE objects cause a database to get bigger.

My question is. Is this true? I also have a button that runs about 10 append queries. would that cause this to happen? I dont think that running append queries would make the database grow that large.

The reason I have OLE objects is , I created splash forms that would tell the user there data is downloading etc...

On those splash forms there are OLE objects that contain Animated GIFS.

Can someone help me with this?

Thanks
DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[JoeMiller]

OLE on the forms here and there is no big deal, OLE in the tables is a big deal and CAN lead to serious file bloat. However, I don't believe your problem is OLE. Instead it's probably the action queries (append, delete, update, make-table). Records/tables/forms/reports when deleted stay in the database until you run a compact on the database. This is analagous to emptying the recycle bin.

HTH Joe Miller
joe.miller@flotech.net

 

[dvannoy]

i have compacted many times before and it still grows very large...why would append queries cause the database to blow up like that??? DVannoy
A+,Network+,CNA
dvannoy@onyxes.com

 

[JoeMiller]

Not really sure, if this is A2K then it may be a service pack issue. I know there are many file bloat problems with A2K, not sure why (don't run it!).

Joe Miller
joe.miller@flotech.net

 

[Aivars]

Yes, indeed...
DB's which include OLE objects boom incredibly. Service packs don't flag down it. My advice - never save embedded OLE objects in the Ac tables but create links or hyperlinks to disk files.

Aivars