By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,196 Members | 1,866 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,196 IT Pros & Developers. It's quick & easy.

Access OLE objects vs hyperlinks

P: 1

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
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,761
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

Expert Mod 15k+
P: 31,761
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.