Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    May 2002
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Double Checking . . . (XP)

    Sorry that this is a dumb question, but I just wanted to check something . . .

    If I create a Table with an OLE Field then get the user to right-click and choose 'Insert Object', providing they use 'Create from File' and put a check in the Link checkbox and a check in the 'Display As Icon' checkbox, this won't increase the size of the DB very much, will it? Say there are eventually 2,000+ Records all with these 'Links', it's just a path, right? It won't explode the size of the database, will it?

    Again, sorry if this is a dumb question, but rather than having to get a user to type a Hyerlink into a Hyperlink Field, I thought that allowing them to Browse to a File (then click to open the file at a later date) would be a better option, but I don't want it to slow down the DB.

    Thanks in advance for clarifying this question. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Double Checking . . . (XP)

    I'm afraid it will bloat the database, but do a simple test by adding two or three records and then insert the link and see what happens. It's been some time since I tried that, and it was on Access 97, but it seemed to me that the database went up by nearly 1MB in size whether I embedded a picture or linked to it - and these were small JPEGs - not more than 20Kbytes.
    Wendell

  3. #3
    Lounger
    Join Date
    May 2002
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Double Checking . . . (XP)

    Thanks Wendell

    Since posting, I've just realized that if I make it a Hyperlink Field, the Hyperlink Toolbar Icon lights up and allows a user to 'Browse' to a file, which is even better than the OLE field, i.e., much faster!

    Thanks for your reply. [img]/forums/images/smilies/smile.gif[/img]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •