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

What are the pros and cons between linking and embedding OLE objects

What are the pros and cons between linking and embedding OLE objects

What are the pros and cons between linking and embedding OLE objects

Also how do I update or change the value of a general field.

RE: What are the pros and cons between linking and embedding OLE objects

I can not think of any pros only cons.

One problem as I see it is speed / performance / size of file.
The general field is stored in the dbf.fpt file. It is just another relation the database has to maintain and 99% of the moves around records never involve looking at the general field so you just move pointer in the ftp file for nothing.  
Most people will say, with the speed of processors and hard disk why worry about it.
Fine, one "do-not-worry-about-it" may be OK, but when adding up all the "do-not-worry-about-its" the speed of the application suffers.

The main problem is data corruption.  Now, I know no one has ever had a file server crash on them with a database and memo field open.  After all server crashes with NTs' are so RARE.  The database header becomes corrupt and the link to the fpt file is contaminated and can not be repaired. You lose every link from the database to the memo field.  If you can afford the down time to restore from a backup with the lose of all data since the backup, then you are OK.  If the information is critical then you better have a mirrored server system set up with Big $$$$ to maintain it.

I use a character field to store the drive:/directory/filename. I then use a DDE / RUN call into the application that is associated with the file.  A simple if file() statement prevents displaying a blank screen or an error message.  A simple scan with the if file() in a nightly maintenance program keeps a check on the links and it can produce a report of missing files.

For the record, I have redundant mirrored servers with mirrored drives on both servers,  A Daily Tape Backup and a Nightly Server to Hard Drive back up.  Yes I've been called paranoid, but when it cost you $10,000 per hour of down time is it really being paranoid??

Any Way That Is One Mans Opinion.

David W. Grewe

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