×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Do OLE Objects make Database Get Bigger

Do OLE Objects make Database Get Bigger

Do OLE Objects make Database Get Bigger

(OP)
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

RE: Do OLE Objects make Database Get Bigger

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

RE: Do OLE Objects make Database Get Bigger

(OP)
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

RE: Do OLE Objects make Database Get Bigger

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

RE: Do OLE Objects make Database Get Bigger

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close