469,326 Members | 1,220 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

Access OLE objects vs hyperlinks


I'm currently creating a database to manage a large filing system (so about 2,500 pdf documents). I was going to link the documents in as OLE objects; however, the 2 GB limit in Access has stopped me from doing this.
Does Access have a large enough storage capacity to link the documents in through hyperlinks or are these just as large as OLE objects? Also, is there a way for me to change the OLE objects I've already put into the database into hyperlinks? (Probably not, but it would be a big time saver if there was!)

Or do you think I should just upsize to SQL to avoid the space limitations of Access?

Thanks in advance for your help!
Sep 15 '08 #1
2 2373
32,181 Expert Mod 16PB
As far as I understand it, hyperlinks store little more than the text of the link, so should prove a lot more manageable.

Do your OLE objects have any links to the original? If so, then I'm sure some code could be written to extract the link data into a separate field. This all really depends on precisely what you have.
Sep 15 '08 #2
32,181 Expert Mod 16PB
As long as you don't try it on a continuous form, you can also add an Image control onto your form and display the image from the link whenever a record becomes current.
Sep 16 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Janelle.Dunlap | last post: by
5 posts views Thread by Steve Richter | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.