Attachments?

[NewShoes]

Hey all,

Just thinking about attachments (Access 2010) and if they're a good idea in general. I'm aware that the max size of an Access DB is around 2GB and that if I'm attaching various word and PDF docs, it's going to grow quite fast. I'm also aware that Access 2010 compresses attachments. Does anyone have any experience or advice on this?

I guess an alternative route would be to use hyperlinks to link to the documents which could be stored in a shared network drive. However, I'm aware that some of the people using the DB are not that tech savvy and may struggle entering file paths etc.

I should say I'm using a FE/BE design if it makes any difference.

Any advice would be great!

Thanks,
-NS

 

[rodmc]

There is a pre written module that calls the windows API so that you can store the UNC path by browsing to the file, is that what you're looking for?

You should look at the top 3 entries on this page one of them will do what your looking for I would imagine

 

[NewShoes]

Thanks rodmc, this does appear to be what I want! I'm a little confused by "the top 3 entries on this page". Please could you point me in the right direct?

Many thanks,
-NS

 

[rodmc]

This is possibly what you want although you may want to add the file name as well as the UNC path
http://access.mvps.org/access/api/api0002.htm

the other 2 are similar but probably not what you want but you may want to cannibalise parts from the other

 

[NewShoes]

Thanks Rod, I'll try this!
-NS