Hyperlink base

[Aprilhm14]

Hi,



I am designining an access database that will be used by various users with different computer capabilities. Some fields within the tables are hyperlink type fields which link to folders. The database can be stored on a flash drive with all accompaning documents. If the users save the database onto their computer the folder links will be broken. In Access 2007 there is a property setting where you can set a hyperlink base that I can ask each user to change each time they open the database and then I can specify the path the folder within the flash drive. However I am unable to find that in Access 2010 verisons. I was wondering if anyone had any advice on that? I don't want to write a code because I am trying to make it as user friendly as possible.

[June7]

Not seeing this property in Access 2007. Where is it?

I am not finding anything indicating this is available with 2007 and later.

Might have to use code. Code can pull the current project path and concatenate with a text value and execute that like a hyperlink. Review:

http://allenbrowne.com/func-GoHyperlink.html

http://www.allenbrowne.com/casu-09.html

http://blogs.office.com/b/microsoft-...hyperlink.aspx

Found this statement in MS KB:
If Microsoft Access can't resolve the HyperlinkAddress property setting to a valid URL or UNC path, it will assume you've specified a path relative to the base path contained in the Hyperlink Base setting or the current database path.

However, that same article also said it was for Office 2007 and the HyperlinkBase property could be found on the File menu and since Access 2007 does not have File menu ...